APPS.GMD_LAB_MIGRATION dependencies on DUAL

Line 63: select gem5_formula_id_s.nextval from sys.dual;

59:
60: /*Cursor to create sequence of the formula_id*/
61:
62: CURSOR fm_formula_id is
63: select gem5_formula_id_s.nextval from sys.dual;
64:
65: /*Cursor to get all formula details for a given formula_id */
66:
67: CURSOR lab_detail (Vformula_id IN NUMBER) is

Line 75: select gem5_formulaline_id_s.nextval from sys.dual;

71: /*Cursor to create sequence of the formulaline_id */
72:
73: CURSOR fm_formulaline_id is
74:
75: select gem5_formulaline_id_s.nextval from sys.dual;
76:
77: /* local parameters*/
78: Xformula_id number;
79: Xformulaline_id number;

Line 135: FROM sys.dual;

131:
132:
133: select fnd_profile.value_specific('GEMMS_DEFAULT_ORGN',lab_rec.created_by)
134: INTO l_orgn_code
135: FROM sys.dual;
136:
137: /* Step 3 : To insert data ino the fm_form_mst_b and fm_form_mst_vl
138: table */
139: /* changed x_formula_vers to lab_rec.formula_vers */

Line 320: FROM DUAL;

316: 'FM_FORM_MST AND MF_MATL_DTL',
317: lab_rec.formula_id,
318: Xformula_id,
319: error_msg
320: FROM DUAL;
321:
322:
323: END;
324:

Line 367: FROM sys.dual;

363:
364:
365: select fnd_profile.value_specific('GEMMS_DEFAULT_ORGN',lab_rec.created_by)
366: INTO l_orgn_code
367: FROM sys.dual;
368:
369: /* Step 3 : To insert data ino the fm_form_mst_b and fm_form_mst_vl
370: table */
371: INSERT INTO GMD_LAB_FORMULA_ASSOC(old_formula_id,old_formula_no,old_formula_vers,

Line 566: FROM DUAL;

562: 'FM_FORM_MST AND MF_MATL_DTL',
563: lab_rec.formula_id,
564: Xformula_id,
565: error_msg
566: FROM DUAL;
567:
568:
569: END;
570: