APPS.ARP_COLL_IND dependencies on AR_RECEIVABLE_APPLICATIONS_ALL

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;