SQL-001: Select US Bank nonpay notice sequence

Retrieve the next Oracle sequence value used when a new clsUSBankNonpayNotice object is created.

Classification

Field	Value
SQL ID	SQL-001
Operation type	Sequence
Execution method	Framework sequence helper with Oracle CreateSQL property present
Database	Oracle
Schema	Unqualified in library SQL
Command type	Text
Business object	clsUSBankNonpayNotice
Criteria property	CreateSQL
Lifecycle method	Create

Tables

Table	Access	Columns used
DUAL	SELECT	US_BANK_NONPAY_NOTICE_SEQ_NUM_NEXTVAL

Sample SQL

SELECT US_BANK_NONPAY_NOTICE_SEQ_NUM_NEXTVAL FROM DUAL

Operations and processes

• Persist and retrieve SAIF-side integration records

Sources

• Business\SAIF.Business.EPay.USBank\clsUSBankNonpayNotice.vb