DBA Data[Home] [Help]

APPS.AR_DEP_BAL_RPT_PKG dependencies on AR_PAYMENT_SCHEDULES_ALL

Line 204: FROM ar_payment_schedules_all APSA

200:
201: BEGIN
202: SELECT NVL(SUM(APSA.amount_due_original),0)
203: INTO ln_deposit_cancel
204: FROM ar_payment_schedules_all APSA
205: ,ra_customer_trx_all RCT
206: WHERE RCT.previous_customer_trx_id=p_customer_trx_id
207: AND APSA.gl_date < gc_per_start_date
208: AND RCT.customer_trx_id=APSA.customer_trx_id