APPS.GMD_SEARCH_REPLACE_VERS dependencies on FND_DUAL

Line 48: FROM FND_DUAL;

44: X_row NUMBER := 0;
45:
46: CURSOR Cur_routing_id IS
47: SELECT gem5_routing_id_s.NEXTVAL
48: FROM FND_DUAL;
49: CURSOR Cur_get_hdr IS
50: SELECT *
51: FROM fm_rout_hdr
52: WHERE routing_id = p_routing_id;

Line 301: FROM FND_DUAL;

297: p_resource IN VARCHAR2,
298: x_oprn_id OUT NOCOPY NUMBER) IS
299: CURSOR Cur_gen_oprn_id IS
300: SELECT GEM5_OPRN_ID_S.NEXTVAL
301: FROM FND_DUAL;
302: CURSOR Cur_gen_oprnline_id IS
303: SELECT GEM5_OPRNLINE_ID_S.NEXTVAL
304: FROM FND_DUAL;
305:

Line 304: FROM FND_DUAL;

300: SELECT GEM5_OPRN_ID_S.NEXTVAL
301: FROM FND_DUAL;
302: CURSOR Cur_gen_oprnline_id IS
303: SELECT GEM5_OPRNLINE_ID_S.NEXTVAL
304: FROM FND_DUAL;
305:
306: CURSOR Cur_get_hdr IS
307: SELECT *
308: FROM gmd_operations_vl

Line 662: FROM FND_DUAL;

658: FROM gmd_recipes
659: WHERE recipe_no = X_hdr_rec.recipe_no;
660: CURSOR Cur_recipe_id IS
661: SELECT gmd_recipe_id_s.NEXTVAL
662: FROM FND_DUAL;
663:
664: X_return_status VARCHAR2(1);
665: X_message_count NUMBER;
666: X_message_list VARCHAR2(2000);

Line 1067: FROM FND_DUAL;

1063: X_row NUMBER := 0;
1064: l_rowid VARCHAR2(18);
1065: CURSOR Cur_formula_id IS
1066: SELECT gem5_formula_id_s.NEXTVAL
1067: FROM FND_DUAL;
1068: CURSOR Cur_get_hdr IS
1069: SELECT *
1070: FROM fm_form_mst
1071: WHERE formula_id = p_formula_id;