DBA Data[Home] [Help]

APPS.AR_CALC_LATE_CHARGE dependencies on AR_PAYMENT_SCHEDULES_ALL

Line 4925: FROM ar_payment_schedules_all ps,

4921: sum(ps.amount_due_remaining) open_bal,
4922: sum((case when (decode(ps.class,'CM',ps.due_date,ps.due_date + NVL(cust_site.payment_grace_days,0))) < p_as_of_date then 1 else 0 end)
4923: * ps.amount_due_remaining) overdue_bal,
4924: ps.org_id
4925: FROM ar_payment_schedules_all ps,
4926: ar_lc_cust_sites_t cust_site,
4927: ra_customer_trx ct,
4928: ra_cust_trx_types typ
4929: WHERE ps.customer_id = cust_site.customer_id