DBA Data[Home] [Help]

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';