SAIF.Business.EPay.USBank SQL catalog¶

This page indexes the inline Oracle SQL statements identified in the database-analysis findings for SAIF.Business.EPay.USBank.

Create operations¶

SQL ID	Description	Type	Tables	Business object
SQL-003	Inserts a new nonpayment-notice row.	Inline	US_BANK_NONPAY_NOTICE	`clsUSBankNonpayNotice`
SQL-004	Inserts a new user row.	Inline	US_BANK_USER	`clsUSBankUser`

SQL ID	Description	Type	Tables	Business object
SQL-005	Retrieves one nonpayment notice by primary key.	Inline	US_BANK_NONPAY_NOTICE	`clsUSBankNonpayNotice`
SQL-006	Retrieves nonpayment notices by policy number.	Inline	US_BANK_NONPAY_NOTICE	`clsUSBankNonpayNoticeCollection`
SQL-007	Retrieves one user row by primary key.	Inline	US_BANK_USER	`clsUSBankUser`
SQL-008	Retrieves one user row by policy number and business-online user ID.	Inline	US_BANK_USER	`clsUSBankUser`
SQL-009	Retrieves user rows by policy number.	Inline	US_BANK_USER	`clsUSBankUserCollection`

SQL ID	Description	Type	Tables	Business object
SQL-010	Updates an existing nonpayment-notice row.	Inline	US_BANK_NONPAY_NOTICE	`clsUSBankNonpayNotice`
SQL-011	Updates an existing user row.	Inline	US_BANK_USER	`clsUSBankUser`

SQL ID	Description	Type	Tables	Business object
SQL-012	Deletes a nonpayment-notice row.	Inline	US_BANK_NONPAY_NOTICE	`clsUSBankNonpayNotice`
SQL-013	Deletes a user row.	Inline	US_BANK_USER	`clsUSBankUser`

SQL ID	Description	Sequence	Tables	Business object
SQL-001	Selects the next notice sequence value.	`US_Bank_Nonpay_Notice_SEQ`	DUAL	`clsUSBankNonpayNotice`
SQL-002	Selects the next user sequence value.	`US_Bank_User_SEQ`	DUAL	`clsUSBankUser`