DBA Data[Home] [Help]

APPS.IGI_EXP_BALANCE dependencies on AR_PAYMENT_SCHEDULES

Line 39: ar_payment_schedules aps

35:
36: CURSOR ar_balance IS
37: SELECT NVL(SUM(aps.amount_due_remaining),0)
38: FROM ra_customer_trx rct,
39: ar_payment_schedules aps
40: WHERE aps.customer_trx_id = rct.customer_trx_id
41: AND rct.bill_to_customer_id = l_customer_id
42: AND aps.class = 'INV'
43: AND aps.due_date <= trunc(sysdate);