APPS.ARP_BALANCE_CHECK dependencies on AR_RECEIVABLE_APPLICATIONS

Line 208: from ar_receivable_applications

204: decode(amount_applied_from,NULL,
205: 'N',
206: 'Y') cc_flag,
207: gl_date
208: from ar_receivable_applications
209: where cash_receipt_id = p_cr_id
210: and nvl(confirmed_flag,'Y') = 'Y'
211: and nvl(postable,'Y') = 'Y'
212: and posting_control_id = -3) src,

Line 468: from ar_receivable_applications

464: sum(nvl(acctd_amount_dr,0)), sum(nvl(acctd_amount_cr,0))
465: into l_amt_dr, l_amt_cr, l_acctd_amt_dr, l_acctd_amt_cr
466: from (select receivable_application_id src_id,
467: 'RA' src_tab
468: from ar_receivable_applications
469: where receivable_application_id = p_receivable_application_id
470: and nvl(postable,'Y') = 'Y'
471: and posting_control_id = -3) src,
472: ar_distributions ard

Line 576: from ar_receivable_applications

572: 'RA' src_tab,
573: decode(amount_applied_from,NULL,
574: 'N',
575: 'Y') cc_flag
576: from ar_receivable_applications
577: where ( receivable_application_id = p_receivable_application_id1
578: or receivable_application_id = p_receivable_application_id2)
579: and nvl(postable,'Y') = 'Y'
580: and posting_control_id = -3) src,