APPS.OZF_AR_PAYMENT_PVT dependencies on OZF_CLAIMS_ALL

Line 277: FROM ozf_claims_all

273: ,x_claim_rec.deduction_attribute15
274: ,x_claim_rec.org_id
275: ,x_claim_rec.wo_rec_trx_id
276: ,x_claim_rec.legal_entity_id
277: FROM ozf_claims_all
278: WHERE claim_id = p_claim_id ;
279: x_return_status := FND_API.g_ret_sts_success;
280: EXCEPTION
281: WHEN OTHERS THEN

Line 473: FROM ozf_claims_all

469: --Start:Bug:2781186
470: --Cursor to get customer reason,customer ref, reason code id
471: CURSOR csr_get_more_root_clm_dtls (cv_claim_id IN NUMBER) IS
472: SELECT claim_number, claim_id, customer_ref_number
473: FROM ozf_claims_all
474: WHERE claim_id = cv_claim_id;
475:
476: --Cursor to get customer reason,customer ref, reason code id in case of child cliam
477: CURSOR csr_get_more_chld_clm_dtls (cv_claim_id IN NUMBER) IS

Line 1300: FROM ozf_claims_all

1296: SELECT customer_reason, customer_ref_number, reason_code_id
1297: --, customer_ref_date --11.5.10 enhancements - TM should pass
1298: -- Uncomment and Corresponding change for this has to be done while assigning to code after
1299: -- AR enhancement for this is done.
1300: FROM ozf_claims_all
1301: WHERE claim_id = cv_claim_id;
1302:
1303: -- Cursor to get claim reason name
1304: CURSOR csr_get_reason_name (cv_reason_code_id IN NUMBER) IS

Line 1619: FROM ozf_claims_all

1615: --Start:Bug:2781186
1616: -- Cursor to get customer reason,customer ref, reason code id
1617: CURSOR csr_get_more_root_clm_dtls (cv_claim_id IN NUMBER) IS
1618: SELECT claim_number, claim_id, customer_ref_number
1619: FROM ozf_claims_all
1620: WHERE claim_id = cv_claim_id;
1621:
1622: --Cursor to get customer reason,customer ref, reason code id in case of child cliam
1623: CURSOR csr_get_more_chld_clm_dtls (cv_claim_id IN NUMBER) IS

Line 1964: UPDATE ozf_claims_all

1960:
1961: --//Bug 5345095 BK Modif
1962: IF l_receivables_trx_id IS NOT NULL THEN
1963: BEGIN
1964: UPDATE ozf_claims_all
1965: SET wo_rec_trx_id = l_receivables_trx_id
1966: WHERE claim_id = p_claim_rec.claim_id
1967: AND wo_rec_trx_id IS NULL;
1968:

Line 3982: SELECT claim_id, amount_due_remaining FROM ozf_claims_all, ar_payment_schedules_all

3978: l_settlement_amount NUMBER := NULL ;
3979:
3980: -- Start Fix for Bug4324426
3981: CURSOR csr_ded_details(p_customer_trx_id IN NUMBER) IS
3982: SELECT claim_id, amount_due_remaining FROM ozf_claims_all, ar_payment_schedules_all
3983: WHERE source_object_id = customer_trx_id
3984: AND source_object_class = class
3985: AND claim_class = 'DEDUCTION'
3986: AND cust_account_id = customer_id