DBA Data[Home] [Help]

APPS.AR_ARXSOC2_XMLP_PKG dependencies on AR_RECEIVABLE_APPLICATIONS

Line 178: from ar_receivable_applications

174: from dual;
175: if cr_status = 'APP' then
176: select sum(amount_applied)
177: into l_on_account_amount
178: from ar_receivable_applications
179: where cash_receipt_id = cash_receipt_id
180: and status = 'ACC';
181: if nvl(l_on_account_amount,0) <> 0 then
182: l_unapplied_count := l_unapplied_count + 1;

Line 251: from ar_receivable_applications

247: from dual;
248: if cr_status_BB = 'APP' then
249: select sum(amount_applied)
250: into l_on_account_amount
251: from ar_receivable_applications
252: where cash_receipt_id = cash_receipt_id_B
253: and status = 'ACC';
254: if nvl(l_on_account_amount,0) <> 0 then
255: l_unapplied_count := l_unapplied_count + 1;