APPS.GMD_PROCESS_INSTR_UTILS dependencies on GMD_RECIPES

Line 9: FROM gmd_recipes_b r

5:
6: /* Cursor to get the routing_id attached with the recipe */
7: CURSOR Get_recipe_details (v_recipe_id NUMBER) IS
8: SELECT r.routing_id, r.formula_id
9: FROM gmd_recipes_b r
10: WHERE r.recipe_id = v_recipe_id;
11:
12: /* Cursor to fetch formula item details */
13: CURSOR Get_formula_details (v_formula_id NUMBER) IS

Line 1276: FROM gmd_recipes

1272: p_to_recipe_id IN VARCHAR2,
1273: p_return_status OUT NOCOPY VARCHAR2) AS
1274: CURSOR Cur_get_rcp_hdr(cp_recipe_id NUMBER) IS
1275: SELECT formula_id, routing_id ,recipe_id
1276: FROM gmd_recipes
1277: WHERE recipe_id = cp_recipe_id;
1278:
1279: rec_from_recipe Cur_get_rcp_hdr%ROWTYPE;
1280: rec_to_recipe Cur_get_rcp_hdr%ROWTYPE;