APPS.AR_BUS_EVENT_SUB_PVT dependencies on AR_PAYMENT_SCHEDULES_ALL

Line 234: ar_payment_schedules_all cm_app_ps,

230: ra_cust_trx_types ctt,
231: ra_terms rt,
232: ra_terms_lines rtl,
233: ar_receivable_applications_all ra_cm,
234: ar_payment_schedules_all cm_app_ps,
235: ar_trx_summary trx_sum
236: where trx.customer_trx_id = ps.customer_trx_id
237: and trx.request_id = p_req_id
238: and trx.previous_customer_trx_id = prev_trx.customer_trx_id(+)

Line 6112: ar_payment_schedules_all cm_app_ps,

6108: ra_cust_trx_types ctt,
6109: ra_terms rt,
6110: ra_terms_lines rtl,
6111: ar_receivable_applications_all ra_cm,
6112: ar_payment_schedules_all cm_app_ps,
6113: ar_trx_summary trx_sum
6114: where trx.customer_trx_id = ps.customer_trx_id
6115: and trx.request_id = p_req_id
6116: and trx.previous_customer_trx_id = prev_trx.customer_trx_id(+)

Line 7136: from ar_payment_schedules_all trx_ps

7132: sum(decode(trx_ps.class,'DEP',trx_ps.amount_due_remaining,0)),
7133: /* OP chargebacks */
7134: count(decode(trx_ps.class,'CB',trx_ps.payment_schedule_id, null)),
7135: sum(decode(trx_ps.class,'CB',trx_ps.amount_due_remaining,0))
7136: from ar_payment_schedules_all trx_ps
7137: where trx_ps.status = 'OP'
7138: and trx_ps.customer_id = main_sum.cust_account_id
7139: and trx_ps.customer_site_use_id = decode(main_sum.site_use_id,-99,
7140: trx_ps.customer_site_use_id,