APPS.GMD_VERSION_CONTROL dependencies on DUAL

Line 185: FROM FND_DUAL;

181: -- Bug #2673008 (JKB) Added l_text_code above.
182:
183: CURSOR Cur_routing_id IS
184: SELECT gem5_routing_id_s.NEXTVAL
185: FROM FND_DUAL;
186: CURSOR Cur_get_hdr IS
187: SELECT *
188: FROM fm_rout_hdr
189: WHERE routing_id = p_routing_id;

Line 400: FROM FND_DUAL;

396: --============================================================================================ */
397: PROCEDURE create_operation(p_oprn_id IN NUMBER, x_oprn_id OUT NOCOPY NUMBER) IS
398: CURSOR Cur_gen_oprn_id IS
399: SELECT GEM5_OPRN_ID_S.NEXTVAL
400: FROM FND_DUAL;
401: CURSOR Cur_gen_oprnline_id IS
402: SELECT GEM5_OPRNLINE_ID_S.NEXTVAL
403: FROM FND_DUAL;
404:

Line 403: FROM FND_DUAL;

399: SELECT GEM5_OPRN_ID_S.NEXTVAL
400: FROM FND_DUAL;
401: CURSOR Cur_gen_oprnline_id IS
402: SELECT GEM5_OPRNLINE_ID_S.NEXTVAL
403: FROM FND_DUAL;
404:
405: CURSOR Cur_get_hdr IS
406: SELECT *
407: FROM gmd_operations_vl

Line 858: FROM FND_DUAL;

854: FROM gmd_recipes
855: WHERE recipe_no = X_hdr_rec.recipe_no;
856: CURSOR Cur_recipe_id IS
857: SELECT gmd_recipe_id_s.NEXTVAL
858: FROM FND_DUAL;
859:
860: CURSOR Cur_get_old_recipe_det (V_recipe_id NUMBER) IS
861: SELECT formula_id, routing_id
862: FROM gmd_recipes_b

Line 1355: FROM FND_DUAL;

1351:
1352: -- Bug #2673008 (JKB) Added l_text_code above.
1353: CURSOR Cur_formula_id IS
1354: SELECT gem5_formula_id_s.NEXTVAL
1355: FROM FND_DUAL;
1356: CURSOR Cur_get_hdr IS
1357: SELECT *
1358: FROM fm_form_mst
1359: WHERE formula_id = p_formula_id;

Line 1667: FROM DUAL;

1663: l_formula_substitution_id gmd_formula_substitution.formula_substitution_id%type;
1664:
1665: CURSOR cur_hdr_s IS
1666: SELECT gmd_item_substitution_hdr_s.nextval
1667: FROM DUAL;
1668: CURSOR cur_dtl_s IS
1669: SELECT gmd_item_substitution_dtl_s.nextval
1670: FROM DUAL;
1671: CURSOR cur_frsb_s IS

Line 1670: FROM DUAL;

1666: SELECT gmd_item_substitution_hdr_s.nextval
1667: FROM DUAL;
1668: CURSOR cur_dtl_s IS
1669: SELECT gmd_item_substitution_dtl_s.nextval
1670: FROM DUAL;
1671: CURSOR cur_frsb_s IS
1672: SELECT gmd_formula_substitution_s.nextval
1673: FROM DUAL;
1674:

Line 1673: FROM DUAL;

1669: SELECT gmd_item_substitution_dtl_s.nextval
1670: FROM DUAL;
1671: CURSOR cur_frsb_s IS
1672: SELECT gmd_formula_substitution_s.nextval
1673: FROM DUAL;
1674:
1675: CURSOR Cur_get_hdr IS
1676: SELECT *
1677: FROM GMD_ITEM_SUBSTITUTION_HDR_VL