SQL-134: clsBenefitScheduleCollection¶

This statement supports clsBenefitScheduleCollection by executing a Other operation through inline.

Classification¶

Field	Value
SQL ID	SQL-134
Operation type	Other
Execution method	Inline SQL
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	`clsBenefitScheduleCollection`
Criteria property	`RetrieveSQL`
Lifecycle method	`BeforeRetrieve`

Parameters¶

Parameter	Direction	Type	Max length	Description
`:inClaimId`	Input	Unknown	—	Passed from clsBenefitScheduleCollection via BeforeRetrieve.
`:inBenefitPaymentSeqNum`	Input	Unknown	—	Passed from clsBenefitScheduleCollection via BeforeRetrieve.
`:inNextIssueDate`	Input	Unknown	—	Passed from clsBenefitScheduleCollection via BeforeRetrieve.
`recordset`	Output	REF CURSOR	—	Passed from clsBenefitScheduleCollection via BeforeRetrieve.

Tables¶

Table	Access	Columns used
`CL_BENEFIT_SCHEDULE`	Other	Not enumerated directly in the stage findings.**

Sample SQL¶

-- When retrieving by claim and benefit payment
EXEC pk82394_claim_benefit.getbenefitschedulebyclaimid(inClaimId => :inClaimId, inBenefitPaymentSeqNum => :inBenefitPaymentSeqNum, recordset => :recordset);

-- When retrieving by next issue date
EXEC pk82394_claim_benefit.getBenefitSchedulebyDate(inNextIssueDate => :inNextIssueDate, recordset => :recordset);

Operations and processes¶

clsBenefitScheduleCollection BeforeRetrieve

Note: Statements marked with ** could not be confirmed; treat them as unknown until verified.

Sources¶

Business/SAIF.Business.Claim.Payment/Payments/TimelossPayments/clsBenefitScheduleCollection.vb