APPS.ARP_COLL_IND dependencies on AR_RECEIVABLE_APPLICATIONS

Line 650: FROM ar_receivable_applications ra

646: SELECT sum( nvl(ra.acctd_amount_applied_to,0) +
647: nvl(ra.acctd_earned_discount_taken,0) +
648: nvl(ra.acctd_unearned_discount_taken,0))
649: INTO apps_tot
650: FROM ar_receivable_applications ra
651: WHERE ra.applied_payment_schedule_id = pay_sched_id
652: AND ra.status = 'APP'
653: AND nvl(ra.confirmed_flag,'Y') = 'Y'
654: AND ra.gl_date > pto_date;

Line 765: FROM ar_receivable_applications_all ra

761: SELECT sum( nvl(ra.acctd_amount_applied_to,0) +
762: nvl(ra.acctd_earned_discount_taken,0) +
763: nvl(ra.acctd_unearned_discount_taken,0))
764: INTO apps_tot_gl
765: FROM ar_receivable_applications_all ra
766: WHERE ra.applied_payment_schedule_id = pay_sched_id
767: AND ra.status = 'APP'
768: AND nvl(ra.confirmed_flag,'Y') = 'Y'
769: AND ra.gl_date > pto_date;