APPS.AR_DEP_BAL_RPT_PKG dependencies on RA_CUSTOMER_TRX_ALL
Line 206: ,ra_customer_trx_all RCT
202: BEGIN
203: SELECT NVL(SUM(APSA.amount_due_original),0)
204: INTO ln_deposit_cancel
205: FROM ar_payment_schedules_all APSA 206: ,ra_customer_trx_all RCT 207: WHERE RCT.previous_customer_trx_id=p_customer_trx_id
208: AND APSA.gl_date < gc_per_start_date
209: AND RCT.customer_trx_id=APSA.customer_trx_id
210: AND APSA.class = 'CM';