DBA Data[Home] [Help]

APPS.OZF_AR_PAYMENT_PVT dependencies on AR_PAYMENT_SCHEDULES_ALL

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