DBA Data[Home] [Help]

APPS.OZF_AR_SETTLEMENT_PVT dependencies on OZF_SETTLEMENT_DOCS

Line 935: FROM ozf_settlement_docs

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;

Line 1327: FROM ozf_settlement_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

Line 2000: FROM ozf_settlement_docs

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;