APPS.GMD_NPD_MIGRATE dependencies on DUAL

Line 94: FROM sys.dual

90: AND migrated_ind = 1;
91:
92: CURSOR Cur_check_existence (V_organization_id NUMBER) IS
93: SELECT 1
94: FROM sys.dual
95: WHERE EXISTS (SELECT 1
96: FROM gmd_parameters_hdr
97: WHERE organization_id = V_organization_id);
98:

Line 101: FROM dual;

97: WHERE organization_id = V_organization_id);
98:
99: CURSOR Cur_get_new_parameter_id IS
100: SELECT GMD_Parameter_Id_S.nextval
101: FROM dual;
102:
103: /* --------EXCEPTIONS ------------- */
104: ORG_NOT_MIGRATED EXCEPTION;
105:

Line 325: FROM sys.dual

321:
322: CURSOR Cur_check_parameter_exists (V_parameter_id NUMBER,
323: V_parameter VARCHAR2) IS
324: SELECT 1
325: FROM sys.dual
326: WHERE EXISTS (SELECT 1
327: FROM gmd_parameters_dtl
328: WHERE parameter_id = V_parameter_id
329: AND parameter_name = V_parameter);

Line 333: FROM dual;

329: AND parameter_name = V_parameter);
330:
331: CURSOR Cur_get_new_parameter_id IS
332: SELECT GMD_Parameter_Id_S.nextval
333: FROM dual;
334:
335: CURSOR Cur_get_new_parameter_line_id IS
336: SELECT GMD_Parameter_Line_Id_S.nextval
337: FROM dual;

Line 337: FROM dual;

333: FROM dual;
334:
335: CURSOR Cur_get_new_parameter_line_id IS
336: SELECT GMD_Parameter_Line_Id_S.nextval
337: FROM dual;
338:
339: BEGIN
340:
341: X_failure_count := 0;