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 207: FROM ar_payment_schedules ps,

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

Line 578: /* This second select on the ar_payment_schedules

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

Line 587: from ar_payment_schedules_all

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

Line 726: FROM ar_payment_schedules ps,

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

Line 827: /* This second select on the ar_payment_schedules

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

Line 837: from ar_payment_schedules_all

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