DBA Data[Home] [Help]

APPS.AP_UTILITIES_PKG dependencies on DUAL

Line 383: from sys.dual;

379: select decode(P_Min_unit,
380: null, round(P_Amount, P_Precision),
381: round(P_Amount/P_Min_unit) * P_Min_unit)
382: into l_rounded_amount
383: from sys.dual;
384: --
385: return(l_rounded_amount);
386: --
387: end AP_Round_Precision;

Line 2684: FROM DUAL

2680: WHEN NO_DATA_FOUND THEN
2681: /* Link is available and No Batch Name then We don't
2682: want such rows */
2683: SELECT '-999' into ret_val
2684: FROM DUAL
2685: WHERE NOT EXISTS (SELECT 'this link id exists in IR'
2686: FROM gl_import_references IR
2687: WHERE IR.gl_sl_link_id=P_gl_sl_link_id
2688: AND IR.gl_sl_link_table = 'APECL');