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 6140: ar_payment_schedules_all cm_app_ps,

6136: ra_cust_trx_types ctt,
6137: ra_terms rt,
6138: ra_terms_lines rtl,
6139: ar_receivable_applications_all ra_cm,
6140: ar_payment_schedules_all cm_app_ps,
6141: ar_trx_summary trx_sum
6142: where trx.customer_trx_id = ps.customer_trx_id
6143: and trx.request_id = p_req_id
6144: and trx.previous_customer_trx_id = prev_trx.customer_trx_id(+)

Line 7181: from ar_payment_schedules_all trx_ps

7177: sum(decode(trx_ps.class,'DEP',trx_ps.amount_due_remaining,0)),
7178: /* OP chargebacks */
7179: count(decode(trx_ps.class,'CB',trx_ps.payment_schedule_id, null)),
7180: sum(decode(trx_ps.class,'CB',trx_ps.amount_due_remaining,0))
7181: from ar_payment_schedules_all trx_ps
7182: where trx_ps.status = 'OP'
7183: and trx_ps.customer_id = main_sum.cust_account_id
7184: and trx_ps.customer_site_use_id = decode(main_sum.site_use_id,-99,
7185: trx_ps.customer_site_use_id,