DBA Data[Home] [Help]

APPS.IGI_EXP_BALANCE dependencies on RA_CUSTOMER_TRX

Line 38: FROM ra_customer_trx rct,

34: WHERE asic.checkrun_name = p_checkrun_name;
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'