APPS.IEX_COLL_IND dependencies on IEX_DELINQUENCIES

Line 86: FROM ar_payment_schedules ps, iex_delinquencies del

82: --Begin Bug 8201317 14-Jun-2010 barathsr
83: SELECT round(sum(TRUNC(decode(sign(gl_date_closed-trunc(sysdate)),1,sysdate,ps.gl_date_closed)) - ps.due_date)
84: / COUNT(1)) AVG_DAYS_LATE
85: INTO l_avg_days_late
86: FROM ar_payment_schedules ps, iex_delinquencies del
87: WHERE ps.gl_date between TRUNC(add_months(sysdate, -12)) and TRUNC(sysdate)
88: and ps.payment_schedule_id=del.payment_schedule_id
89: AND ps.class in ('INV','DEP','DM','CB')
90: AND ps.due_date <= TRUNC(sysdate)

Line 97: FROM ar_payment_schedules ps, iex_delinquencies del

93: ELSIF p_cust_account_id IS NOT NULL THEN
94: SELECT round(sum(TRUNC(decode(sign(gl_date_closed-trunc(sysdate)),1,sysdate,ps.gl_date_closed)) - ps.due_date)
95: / COUNT(1))AVG_DAYS_LATE
96: INTO l_avg_days_late
97: FROM ar_payment_schedules ps, iex_delinquencies del
98: WHERE ps.gl_date between TRUNC(add_months(sysdate, -12)) and TRUNC(sysdate)
99: and ps.payment_schedule_id=del.payment_schedule_id
100: AND ps.class in ('INV','DEP','DM','CB')
101: AND ps.due_date <= TRUNC(sysdate)

Line 108: FROM ar_payment_schedules ps,iex_delinquencies del

104: ELSIF p_customer_site_use_id IS NOT NULL THEN
105: SELECT round(sum(TRUNC(decode(sign(gl_date_closed-trunc(sysdate)),1,sysdate,ps.gl_date_closed)) - ps.due_date)
106: / COUNT(1))AVG_DAYS_LATE
107: INTO l_avg_days_late
108: FROM ar_payment_schedules ps,iex_delinquencies del
109: WHERE ps.gl_date between TRUNC(add_months(sysdate, -12)) and TRUNC(sysdate)
110: and ps.payment_schedule_id=del.payment_schedule_id
111: AND ps.class in ('INV','DEP','DM','CB')
112: AND ps.due_date <= TRUNC(sysdate)

Line 272: FROM ar_payment_schedules ps,iex_delinquencies del

268: GET_ADJ_TOTAL(ps.payment_schedule_id, TRUNC(sysdate)) +
269: nvl(ps.acctd_amount_due_remaining, 0)
270: ))WTD_AVG_DAYS_LATE
271: INTO l_wtd_days_late
272: FROM ar_payment_schedules ps,iex_delinquencies del
273: WHERE ps.gl_date between TRUNC(add_months(sysdate, -12)) and TRUNC(sysdate)
274: and ps.payment_schedule_id=del.payment_schedule_id
275: AND ps.class in ('INV','DEP','DM','CB')
276: AND ps.due_date <= TRUNC(sysdate)

Line 296: FROM ar_payment_schedules ps, iex_delinquencies del

292: GET_ADJ_TOTAL(ps.payment_schedule_id, TRUNC(sysdate)) +
293: nvl(ps.acctd_amount_due_remaining, 0)
294: ))WTD_AVG_DAYS_LATE
295: INTO l_wtd_days_late
296: FROM ar_payment_schedules ps, iex_delinquencies del
297: WHERE ps.gl_date between TRUNC(add_months(sysdate, -12)) and TRUNC(sysdate)
298: and ps.payment_schedule_id=del.payment_schedule_id
299: AND ps.class in ('INV','DEP','DM','CB')
300: AND ps.due_date <= TRUNC(sysdate)

Line 320: FROM ar_payment_schedules ps, iex_delinquencies del

316: GET_ADJ_TOTAL(ps.payment_schedule_id, TRUNC(sysdate)) +
317: nvl(ps.acctd_amount_due_remaining, 0)
318: ))WTD_AVG_DAYS_LATE
319: INTO l_wtd_days_late
320: FROM ar_payment_schedules ps, iex_delinquencies del
321: WHERE ps.gl_date between TRUNC(add_months(sysdate, -12)) and TRUNC(sysdate)
322: and ps.payment_schedule_id=del.payment_schedule_id
323: AND ps.class in ('INV','DEP','DM','CB')
324: AND ps.due_date <= TRUNC(sysdate)