SQL-032 Retrieve benefit payments for an award¶

Retrieves benefit-payment rows for an award as part of the award-to-Pending cascade.

Classification¶

Field	Value
SQL ID	SQL-032
Operation type	Read
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsSetAwardPaymentPending`
Criteria property	`RetrieveBenefitPaymentSQL`
Lifecycle method	`RetrieveBenefitPayment`

Parameters¶

Parameter	Direction	Type	Max length	Description
`ClaimID`	Input	Decimal	—	Claim identifier
`AwardNum`	Input	Decimal	—	SAIF award number

Tables¶

Table	Access	Columns used
CL_BENEFIT_PAYMENT	SELECT	CLAIM_ID, SAIF_AWARD_NUM

Sample SQL¶

-- Retrieve benefit payments for award
Select CL_BENEFIT_PAYMENT.*
  From CL_BENEFIT_PAYMENT
 Where CL_BENEFIT_PAYMENT.CLAIM_ID = :ClaimID
   And CL_BENEFIT_PAYMENT.SAIF_AWARD_NUM = :AwardNum

Operations and processes¶

Set award to Pending

Business rules¶

BR-011: Award must be successfully updated to pending

Sources¶

SAIF.Business.Claim/clsSetAwardPaymentPending.vb