APPS.GME_UPDATE_STEP_QTY_PVT dependencies on DUAL

Line 65: SELECT p_material_step_id from dual;

61: GROUP BY d.batchstep_id
62: --Bug# 5606246 Start
63: --ORDER BY MAX (LEVEL) ASC;
64: UNION
65: SELECT p_material_step_id from dual;
66: --Bug#5606246 end
67: BEGIN
68: IF g_debug <= gme_debug.g_log_procedure THEN
69: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

Line 657: FROM DUAL

653: CURSOR cur_get_scale_type (
654: v_resources gme_batch_step_resources.resources%TYPE)
655: IS
656: SELECT 1
657: FROM DUAL
658: WHERE EXISTS (
659: SELECT 1
660: FROM gme_batch_step_resources
661: WHERE batchstep_id = p_step_id

Line 1894: FROM SYS.DUAL;

1890: /* Cursor Definitions */
1891: CURSOR cur_get_poc_trans_id
1892: IS
1893: SELECT gem5_poc_trans_id_s.NEXTVAL
1894: FROM SYS.DUAL;
1895:
1896: /* Collections for details */
1897: l_ins_resource_row gme_resource_txns_gtmp%ROWTYPE;
1898: l_usage_hrs gme_batch_step_resources.plan_rsrc_usage%TYPE;