APPS.ARP_PROCESS_HEADER_POST_COMMIT dependencies on AR_PAYMENT_SCHEDULES

Line 145: FROM ar_payment_schedules

141: customer_site_use_id,
142: trx_date,
143: amount_credited,
144: status
145: FROM ar_payment_schedules
146: WHERE customer_trx_id = p_cust_trx_id;
147: l_counter NUMBER := 0;
148: l_amt_credited NUMBER;
149: l_stat VARCHAR2(10);

Line 206: FROM ar_payment_schedules ps,

202: l_old_complete_flag,
203: l_true_open_receivables_flag,
204: l_ps_rev_cash_id,
205: l_ct_rev_cash_id
206: FROM ar_payment_schedules ps,
207: ra_cust_trx_types ctt,
208: ra_cust_trx_line_gl_dist lgd,
209: ra_customer_trx ct
210: WHERE ct.customer_trx_id = ps.customer_trx_id(+)

Line 576: /* This second select on the ar_payment_schedules

572: END IF;
573:
574: l_counter := nvl(l_counter,0) + 1;
575:
576: /* This second select on the ar_payment_schedules
577: has been placed here temporarily. Going forward this
578: needs to be changed, we need to use analytic function in the
579: cursor get_existing_ps and get the count from there itself
580: */

Line 585: from ar_payment_schedules_all

581: IF l_counter = 1 THEN
582:
583: select count(*)
584: into l_trx_sum_hist_rec.installments
585: from ar_payment_schedules_all
586: where customer_trx_id = p_customer_trx_id;
587:
588: END IF;
589:

Line 724: FROM ar_payment_schedules ps,

720: 'Y', DECODE( ct.term_id,
721: MAX( ps.term_id ),'N', 'Y'))
722: INTO l_recreate_ps_flag,
723: l_term_changed_flag
724: FROM ar_payment_schedules ps,
725: ra_cust_trx_types ctt,
726: ra_cust_trx_line_gl_dist lgd,
727: ra_customer_trx ct
728: WHERE ct.customer_trx_id = ps.customer_trx_id(+)

Line 825: /* This second select on the ar_payment_schedules

821: EXIT;
822: END IF;
823: l_counter := nvl(l_counter,0) +1;
824:
825: /* This second select on the ar_payment_schedules
826: has been placed here temporarily. Going forward this
827: needs to be changed, we need to use analytic function in the
828: cursor get_existing_ps and get the count from there itself
829: */

Line 835: from ar_payment_schedules_all

831: IF l_counter = 1 THEN
832:
833: select count(*)
834: into l_trx_sum_hist_rec.installments
835: from ar_payment_schedules_all
836: where customer_trx_id = p_customer_trx_id;
837:
838: END IF;
839: