DBA Data[Home] [Help]

APPS.ARP_COLL_IND dependencies on AR_ADJUSTMENTS_ALL

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 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: