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 2679: FROM DUAL

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