SQL-009: Fetch next paymentplandefaultvalues collection
Fetch next paymentplandefaultvalues collection in the context of clsPaymentPlanDefaultValuesCollection.
Classification
Field
Value
SQL ID
SQL-009
Operation type
Sequence
Execution method
Scalar (Text)
Database
Oracle
Command type
Text
Schema
[unqualified]**
Business object
clsPaymentPlanDefaultValuesCollection
Criteria property
CreateSQL
Lifecycle method
BeforeInsert (key generation)
Parameters
Parameter
Direction
Type
Max length
Description
None
—
—
—
No parameters.
Tables
Table
Access
Columns used
N/A
Sequence / procedure
No direct table row in this library.
Sample SQL
SELECT PAYMENT_PLAN_TYPE_NEXTVAL FROM DUAL
Note: Statements marked with * were inferred from code structure, naming conventions, or
contextual evidence where direct confirmation was not available in source artifacts. Statements
marked with ** could not be confirmed; treat as unknown until verified.
Sources
Business/SAIF.Business.Policy.Premium/Billing/clsPaymentPlanDefaultValuesCollection.vb