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

628: CURSOR cur_get_scale_type (
629: v_resources gme_batch_step_resources.resources%TYPE)
630: IS
631: SELECT 1
632: FROM DUAL
633: WHERE EXISTS (
634: SELECT 1
635: FROM gme_batch_step_resources
636: WHERE batchstep_id = p_step_id

Line 1791: FROM SYS.DUAL;

1787: /* Cursor Definitions */
1788: CURSOR cur_get_poc_trans_id
1789: IS
1790: SELECT gem5_poc_trans_id_s.NEXTVAL
1791: FROM SYS.DUAL;
1792:
1793: /* Collections for details */
1794: l_ins_resource_row gme_resource_txns_gtmp%ROWTYPE;
1795: l_usage_hrs gme_batch_step_resources.plan_rsrc_usage%TYPE;