931:
932: CURSOR csr_del_settle_doc(cv_claim_id IN NUMBER) IS
933: SELECT settlement_doc_id
934: , object_version_number
935: FROM ozf_settlement_docs
936: WHERE claim_id = cv_claim_id;
937:
938: BEGIN
939: SAVEPOINT Update_Docs;
1323:
1324: CURSOR csr_del_settle_doc(cv_claim_id IN NUMBER) IS
1325: SELECT settlement_doc_id
1326: , object_version_number
1327: FROM ozf_settlement_docs
1328: WHERE claim_id = cv_claim_id;
1329:
1330:
1331: BEGIN
1996:
1997: CURSOR csr_setl_doc(cv_claim_id IN NUMBER) IS
1998: SELECT payment_method
1999: , settlement_amount
2000: FROM ozf_settlement_docs
2001: WHERE claim_id = cv_claim_id
2002: AND payment_status = 'PENDING_PAID';
2003:
2004: l_claim_rec csr_claim_rec%ROWTYPE;