APPS.GMD_VERSION_CONTROL dependencies on FND_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;