APPS.ARP_COLL_IND dependencies on AR_ADJUSTMENTS

Line 679: FROM ar_adjustments a

675:
676: BEGIN
677: SELECT sum( nvl(a.acctd_amount,0))
678: INTO adj_for_tot_rec
679: FROM ar_adjustments a
680: WHERE a.payment_schedule_id = pay_sched_id
681: AND a.status = 'A'
682: AND a.gl_date <= pto_date;
683:

Line 707: FROM ar_adjustments_all a

703:
704: BEGIN
705: SELECT sum( nvl(a.acctd_amount,0))
706: INTO adj_for_tot_rec_gl
707: FROM ar_adjustments_all a
708: WHERE a.payment_schedule_id = pay_sched_id
709: AND a.status = 'A'
710: AND a.gl_date <= pto_date;
711:

Line 734: FROM ar_adjustments a

730:
731: BEGIN
732: SELECT sum( nvl(a.acctd_amount,0))
733: INTO adj_tot
734: FROM ar_adjustments a
735: WHERE a.payment_schedule_id = pay_sched_id
736: AND a.status = 'A'
737: AND a.gl_date > pto_date;
738:

Line 794: FROM ar_adjustments_all a

790:
791: BEGIN
792: SELECT sum( nvl(a.acctd_amount,0))
793: INTO adj_tot_gl
794: FROM ar_adjustments_all a
795: WHERE a.payment_schedule_id = pay_sched_id
796: AND a.status = 'A'
797: AND a.gl_date > pto_date;
798: