Skip to content

SQL-057 Delete a benefit payment (twin class stop processing)

Deletes a benefit-payment row when no released scheduled payment exists; identical logic to clsActiveBenefitSchedule.*

Classification

Field Value
SQL ID SQL-057
Operation type Delete
Execution method Inline SQL
Database Oracle
Schema [unqualified]**
Command type Text
Business object clsBenefitSchedule
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
Delete CL_BENEFIT_PAYMENT
 Where CLAIM_ID                = :ClaimID
   And BENEFIT_PAYMENT_SEQ_NUM = :BenefitPaymentSeqNum

Sources

  • SAIF.Business.Claim/clsBenefitSchedule.vb (not compiled)