DBA Data[Home] [Help]

APPS.AR_ARXSOC_XMLP_PKG dependencies on DUAL

Line 220: DUAL;

216: ,1
217: ,0)
218: INTO L_ACTUAL_AMOUNT,L_UNIDENTIFIED_AMOUNT,L_MISC_AMOUNT,L_NSF_AMOUNT,L_APPLIED_COUNT,L_UNAPPLIED_COUNT,L_UNIDENTIFIED_COUNT,L_MISC_COUNT
219: FROM
220: DUAL;
221: IF CR_STATUS = 'APP' THEN
222: SELECT
223: SUM(AMOUNT_APPLIED)
224: INTO L_ON_ACCOUNT_AMOUNT

Line 310: DUAL;

306: ,1
307: ,0)
308: INTO L_ACTUAL_AMOUNT,L_UNIDENTIFIED_AMOUNT,L_MISC_AMOUNT,L_NSF_AMOUNT,L_APPLIED_COUNT,L_UNAPPLIED_COUNT,L_UNIDENTIFIED_COUNT,L_MISC_COUNT
309: FROM
310: DUAL;
311: IF CR_STATUS_BB = 'APP' THEN
312: SELECT
313: SUM(AMOUNT_APPLIED)
314: INTO L_ON_ACCOUNT_AMOUNT