SQL-054 Delete a benefit payment (stop processing)¶

Deletes a benefit-payment row (cascading delete) when no released scheduled payment exists during stop processing.

Classification¶

Field	Value
SQL ID	SQL-054
Operation type	Delete
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsActiveBenefitSchedule`
Criteria property	`DeletePaymentSQL`
Lifecycle method	`ProcessBenefitPayment`

Parameters¶

Parameter	Direction	Type	Max length	Description
`ClaimID`	Input	Decimal	—	Row key
`BenefitPaymentSeqNum`	Input	Decimal	—	Row key

Tables¶

Table	Access	Columns used
CL_BENEFIT_PAYMENT	DELETE	CLAIM_ID, BENEFIT_PAYMENT_SEQ_NUM

Sample SQL¶

-- Delete benefit payment (no released scheduled payment)
Delete CL_BENEFIT_PAYMENT
 Where CLAIM_ID                = :ClaimID
   And BENEFIT_PAYMENT_SEQ_NUM = :BenefitPaymentSeqNum

Operations and processes¶

Benefit-payment stop processing

Business rules¶

BR-010: Benefit payment delete must affect a row

Sources¶

SAIF.Business.Claim/clsActiveBenefitSchedule.vb