APPS.ARP_CUSTOMER_AGING dependencies on AR_PAYMENT_SCHEDULES_ALL

Line 601: ar_payment_schedules_all ps

597: ps.payment_schedule_id
598: UNION ALL
599: SELECT -sum(nvl(adj.amount,0)) amount_due_remaining,1,0,0,0,0,0,0
600: FROM ar_adjustments adj,
601: ar_payment_schedules_all ps
602: WHERE adj.GL_date > p_as_of_date
603: AND ps.payment_schedule_id = adj.payment_schedule_id
604: AND adj.status = 'A'
605: AND ps.gl_date_closed > p_as_of_date

Line 1127: ar_payment_schedules_all ps

1123: ps.payment_schedule_id
1124: UNION ALL
1125: SELECT -sum(nvl(adj.amount,0)) amount_due_remaining,1,0,0,0,0,0,0
1126: FROM ar_adjustments adj,
1127: ar_payment_schedules_all ps
1128: WHERE adj.GL_date > p_as_of_date
1129: AND ps.payment_schedule_id = adj.payment_schedule_id
1130: AND adj.status = 'A'
1131: AND ps.gl_date_closed > p_as_of_date

Line 1656: ar_payment_schedules_all ps

1652: ps.payment_schedule_id
1653: UNION ALL
1654: SELECT -sum(nvl(adj.amount,0)) amount_due_remaining,1,0,0,0,0,0,0
1655: FROM ar_adjustments adj,
1656: ar_payment_schedules_all ps
1657: WHERE adj.GL_date > p_as_of_date
1658: AND ps.payment_schedule_id = adj.payment_schedule_id
1659: AND adj.status = 'A'
1660: AND ps.gl_date_closed > p_as_of_date

Line 2176: ar_payment_schedules_all ps

2172: ps.payment_schedule_id
2173: UNION ALL
2174: SELECT -sum(nvl(adj.amount,0)) amount_due_remaining,1,0,0,0,0,0,0
2175: FROM ar_adjustments adj,
2176: ar_payment_schedules_all ps
2177: WHERE adj.GL_date > p_as_of_date
2178: AND ps.payment_schedule_id = adj.payment_schedule_id
2179: AND adj.status = 'A'
2180: AND ps.gl_date_closed > p_as_of_date

Line 2701: ar_payment_schedules_all ps

2697: ps.payment_schedule_id
2698: UNION ALL
2699: SELECT -sum(nvl(adj.amount,0)) amount_due_remaining,1,0,0,0,0,0,0
2700: FROM ar_adjustments adj,
2701: ar_payment_schedules_all ps
2702: WHERE adj.GL_date > p_as_of_date
2703: AND ps.payment_schedule_id = adj.payment_schedule_id
2704: AND adj.status = 'A'
2705: AND ps.gl_date_closed > p_as_of_date