APPS.OZF_AR_PAYMENT_PVT dependencies on AR_PAYMENT_SCHEDULES_ALL

Line 4603: SELECT claim_id, amount_due_remaining FROM ozf_claims_all, ar_payment_schedules_all

4599: l_settlement_amount NUMBER := NULL ;
4600:
4601: -- Start Fix for Bug4324426
4602: CURSOR csr_ded_details(p_customer_trx_id IN NUMBER) IS
4603: SELECT claim_id, amount_due_remaining FROM ozf_claims_all, ar_payment_schedules_all
4604: WHERE source_object_id = customer_trx_id
4605: AND source_object_class = class
4606: AND claim_class = 'DEDUCTION'
4607: AND cust_account_id = customer_id

Line 4665: FROM ar_payment_schedules_all

4661: WHERE secondary_application_ref_id = cv_claim_id;
4662:
4663: CURSOR csr_trx_amt(cv_customer_trx_id IN NUMBER) IS
4664: SELECT amount_applied
4665: FROM ar_payment_schedules_all
4666: WHERE customer_trx_id = cv_customer_trx_id;
4667:
4668: l_source_obt_class VARCHAR2(10);
4669: l_receipt_amt NUMBER;