SAIF.Business.Claim.EAIP SQL catalog¶

This page indexes SQL statements and stored-procedure calls used by SAIF.Business.Claim.EAIP.

Create operations¶

SQL ID	Description	Type	Tables	Business object
SQL-008	StoredProc create used by Criteria	StoredProc	N/A	`Criteria`
SQL-009	StoredProc create used by Criteria	StoredProc	N/A	`Criteria`
SQL-010	StoredProc create used by Criteria	StoredProc	N/A	`Criteria`
SQL-011	Inline create used by Criteria	Inline	EAIP_PERIOD_TIMECARD	`Criteria`
SQL-012	StoredProc create used by Criteria	StoredProc	N/A	`Criteria`
SQL-013	StoredProc create used by Criteria	StoredProc	N/A	`Criteria`
SQL-014	StoredProc create used by Criteria	StoredProc	N/A	`Criteria`
SQL-015	StoredProc create used by Criteria	StoredProc	N/A	`Criteria`
SQL-016	StoredProc create used by Criteria	StoredProc	N/A	`Criteria`
SQL-017	StoredProc create used by Criteria	StoredProc	N/A	`Criteria`

SQL ID	Description	Type	Tables	Business object
SQL-018	StoredProc read used by Criteria	StoredProc	N/A	`Criteria`
SQL-019	StoredProc read used by Criteria	StoredProc	N/A	`Criteria`
SQL-020	StoredProc read used by Criteria	StoredProc	N/A	`Criteria`
SQL-021	StoredProc read used by Criteria	StoredProc	N/A	`Criteria`
SQL-022	StoredProc read used by Criteria	StoredProc	N/A	`Criteria`
SQL-023	StoredProc read used by Criteria	StoredProc	N/A	`Criteria`
SQL-024	StoredProc read used by Criteria	StoredProc	N/A	`Criteria`
SQL-025	StoredProc read used by Criteria	StoredProc	N/A	`Criteria`
SQL-026	StoredProc read used by Criteria	StoredProc	N/A	`Criteria`

SQL ID	Description	Type	Tables	Business object
SQL-027	StoredProc update used by clsCreditCardPayment	StoredProc	N/A	`clsCreditCardPayment`
SQL-028	StoredProc update used by Criteria	StoredProc	N/A	`Criteria`
SQL-029	StoredProc update used by Criteria	StoredProc	N/A	`Criteria`
SQL-030	StoredProc update used by Criteria	StoredProc	N/A	`Criteria`
SQL-031	Inline update used by Criteria	Inline	EAIP_PERIOD_TIMECARD	`Criteria`
SQL-032	StoredProc update used by Criteria	StoredProc	N/A	`Criteria`
SQL-033	StoredProc update used by Criteria	StoredProc	N/A	`Criteria`
SQL-034	StoredProc update used by Criteria	StoredProc	N/A	`Criteria`
SQL-035	StoredProc update used by Criteria	StoredProc	N/A	`Criteria`
SQL-036	StoredProc update used by Criteria	StoredProc	N/A	`Criteria`
SQL-037	StoredProc update used by Criteria	StoredProc	N/A	`Criteria`

SQL ID	Description	Type	Tables	Business object
SQL-038	StoredProc delete used by Criteria	StoredProc	N/A	`Criteria`
SQL-039	StoredProc delete used by Criteria	StoredProc	N/A	`Criteria`
SQL-040	StoredProc delete used by Criteria	StoredProc	N/A	`Criteria`
SQL-041	Inline delete used by Criteria	Inline	EAIP_PERIOD_TIMECARD	`Criteria`
SQL-042	StoredProc delete used by Criteria	StoredProc	N/A	`Criteria`
SQL-043	StoredProc delete used by Criteria	StoredProc	N/A	`Criteria`
SQL-044	StoredProc delete used by Criteria	StoredProc	N/A	`Criteria`
SQL-045	StoredProc delete used by Criteria	StoredProc	N/A	`Criteria`
SQL-046	StoredProc delete used by Criteria	StoredProc	N/A	`Criteria`
SQL-047	StoredProc delete used by Criteria	StoredProc	N/A	`Criteria`
SQL-048	StoredProc delete used by CriteriaBase	StoredProc	N/A	`CriteriaBase`

SQL ID	Description	Sequence	Tables	Business object
SQL-001	`select eaip_billing_seq.nextval from dual` sequence used by Criteria	`select eaip_billing_seq.nextval from dual`	N/A	`Criteria`
SQL-002	`select eaip_pay_period_seq.nextval from dual` sequence used by Criteria	`select eaip_pay_period_seq.nextval from dual`	N/A	`Criteria`
SQL-003	`select eaip_period_timecard_seq.nextval from dual` sequence used by Criteria	`select eaip_period_timecard_seq.nextval from dual`	N/A	`Criteria`
SQL-004	`select eaip_period_seq.nextval from dual` sequence used by Criteria	`select eaip_period_seq.nextval from dual`	N/A	`Criteria`
SQL-005	`select eaip_reimb_seq.nextval from dual` sequence used by Criteria	`select eaip_reimb_seq.nextval from dual`	N/A	`Criteria`
SQL-006	`select eaip_reimb_detail_seq.nextval from dual` sequence used by Criteria	`select eaip_reimb_detail_seq.nextval from dual`	N/A	`Criteria`
SQL-007	`select eaip_expense_seq.nextval from dual` sequence used by CriteriaBase	`select eaip_expense_seq.nextval from dual`	N/A	`CriteriaBase`