APPS.AR_ARXSOC2_XMLP_PKG dependencies on DUAL

Line 174: from dual;

170: l_applied_count,
171: l_unapplied_count,
172: l_unidentified_count,
173: l_misc_count
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

Line 247: from dual;

243: l_applied_count,
244: l_unapplied_count,
245: l_unidentified_count,
246: l_misc_count
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