APPS.ARP_PROCESS_CREDIT_UTIL dependencies on AR_PAYMENT_SCHEDULES

Line 234: FROM ar_payment_schedules ps

230: +--------------------------------------------------------------------*/
231:
232: SELECT count(*)
233: INTO l_num_installments
234: FROM ar_payment_schedules ps
235: WHERE ps.customer_trx_id = p_ct_id;
236:
237: SELECT count(decode(ctl.line_type,
238: 'LINE', 1,

Line 409: from ar_payment_schedules ps

405: select decode(nvl(sum(ps.amount_applied), 0),
406: 0, 'N',
407: 'Y')
408: into p_payment_exist_flag
409: from ar_payment_schedules ps
410: where customer_trx_id = p_ct_id;
411:
412:
413: IF PG_DEBUG in ('Y', 'C') THEN