APPS.IEX_COLL_IND_PUB dependencies on AR_PAYMENT_SCHEDULES

Line 131: FROM ar_payment_schedules ps, hz_cust_accounts ca

127: IEX_COLL_IND.GET_ADJ_TOTAL(ps.payment_schedule_id, TRUNC(sysdate)) +
128: nvl(ps.acctd_amount_due_remaining, 0)
129: )
130: INTO l_wtd_days_terms
131: FROM ar_payment_schedules ps, hz_cust_accounts ca
132: WHERE ps.gl_date between TRUNC(add_months(sysdate, -12)) and TRUNC(sysdate)
133: AND ps.class in ('INV','DEP','DM','CB')
134: AND ps.payment_schedule_id <> -1
135: AND ps.customer_id = ca.cust_account_id

Line 153: FROM ar_payment_schedules ps

149: IEX_COLL_IND.GET_ADJ_TOTAL(ps.payment_schedule_id, TRUNC(sysdate)) +
150: nvl(ps.acctd_amount_due_remaining, 0)
151: )
152: INTO l_wtd_days_terms
153: FROM ar_payment_schedules ps
154: WHERE ps.gl_date between TRUNC(add_months(sysdate, -12)) and TRUNC(sysdate)
155: AND ps.class in ('INV','DEP','DM','CB')
156: AND ps.payment_schedule_id <> -1
157: AND ps.customer_id = p_cust_account_id;

Line 174: FROM ar_payment_schedules ps

170: IEX_COLL_IND.GET_ADJ_TOTAL(ps.payment_schedule_id, TRUNC(sysdate)) +
171: nvl(ps.acctd_amount_due_remaining, 0)
172: )
173: INTO l_wtd_days_terms
174: FROM ar_payment_schedules ps
175: WHERE ps.gl_date between TRUNC(add_months(sysdate, -12)) and TRUNC(sysdate)
176: AND ps.class in ('INV','DEP','DM','CB')
177: AND ps.payment_schedule_id <> -1
178: AND ps.customer_site_use_id = p_customer_site_use_id;

Line 225: FROM ar_payment_schedules ps, hz_cust_accounts ca

221: IEX_COLL_IND.GET_ADJ_TOTAL(ps.payment_schedule_id, TRUNC(sysdate)) +
222: nvl(ps.acctd_amount_due_remaining, 0)
223: )
224: INTO l_wtd_days_late
225: FROM ar_payment_schedules ps, hz_cust_accounts ca
226: WHERE ps.gl_date between TRUNC(add_months(sysdate, -12)) and TRUNC(sysdate)
227: AND ps.class in ('INV','DEP','DM','CB')
228: AND ps.status = 'OP'
229: AND ps.payment_schedule_id <> -1

Line 248: FROM ar_payment_schedules ps

244: IEX_COLL_IND.GET_ADJ_TOTAL(ps.payment_schedule_id, TRUNC(sysdate)) +
245: nvl(ps.acctd_amount_due_remaining, 0)
246: )
247: INTO l_wtd_days_late
248: FROM ar_payment_schedules ps
249: WHERE ps.gl_date between TRUNC(add_months(sysdate, -12)) and TRUNC(sysdate)
250: AND ps.class in ('INV','DEP','DM','CB')
251: AND ps.status = 'OP'
252: AND ps.payment_schedule_id <> -1

Line 270: FROM ar_payment_schedules ps

266: IEX_COLL_IND.GET_ADJ_TOTAL(ps.payment_schedule_id, TRUNC(sysdate)) +
267: nvl(ps.acctd_amount_due_remaining, 0)
268: )
269: INTO l_wtd_days_late
270: FROM ar_payment_schedules ps
271: WHERE ps.gl_date between TRUNC(add_months(sysdate, -12)) and TRUNC(sysdate)
272: AND ps.class in ('INV','DEP','DM','CB')
273: AND ps.status = 'OP'
274: AND ps.payment_schedule_id <> -1

Line 380: FROM ar_payment_schedules ps,

376: g_base_precision,
377: g_base_min_acc_unit) +
378: IEX_COLL_IND.GET_ADJ_FOR_TOT_REC(ps.payment_schedule_id,p_end_date))
379: INTO l_tot_rec
380: FROM ar_payment_schedules ps,
381: hz_cust_accounts ca
382: WHERE ps.class in ('INV', 'DM', 'CB', 'DEP' )
383: AND ps.payment_schedule_id <> -1
384: AND ps.gl_date BETWEEN l_temp_start AND p_end_date

Line 396: FROM ar_payment_schedules ps

392: g_base_precision,
393: g_base_min_acc_unit) +
394: IEX_COLL_IND.GET_ADJ_FOR_TOT_REC(ps.payment_schedule_id,p_end_date))
395: INTO l_tot_rec
396: FROM ar_payment_schedules ps
397: WHERE ps.class in ('INV', 'DM', 'CB', 'DEP' )
398: AND ps.payment_schedule_id <> -1
399: AND ps.gl_date BETWEEN l_temp_start AND p_end_date
400: AND ps.customer_id = p_cust_account_id;

Line 410: FROM ar_payment_schedules ps

406: g_base_precision,
407: g_base_min_acc_unit) +
408: IEX_COLL_IND.GET_ADJ_FOR_TOT_REC(ps.payment_schedule_id,p_end_date))
409: INTO l_tot_rec
410: FROM ar_payment_schedules ps
411: WHERE ps.class in ('INV', 'DM', 'CB', 'DEP' )
412: AND ps.payment_schedule_id <> -1
413: AND ps.gl_date BETWEEN l_temp_start AND p_end_date
414: AND ps.customer_site_use_id = p_customer_site_use_id;