APPS.GMD_QC_MIGRATE_TO_1151J dependencies on GMD_RECIPES

Line 2355: FROM gmd_recipes r,

2351:
2352: -- Get the recipe id + no + version
2353: CURSOR c_recipe_id_no_vers (v_batch_id number) IS
2354: SELECT r.recipe_id, r.recipe_no, r.recipe_version
2355: FROM gmd_recipes r,
2356: gmd_recipe_validity_rules feff,
2357: gme_batch_header bh
2358: WHERE bh.batch_id = v_batch_id
2359: AND bh.recipe_validity_rule_id = feff.recipe_validity_rule_id

Line 2376: l_recipe_id gmd_recipes_b.recipe_id%TYPE;

2372:
2373: l_formula_no fm_form_mst_b.formula_no%TYPE;
2374: l_formula_vers fm_form_mst_b.formula_vers%TYPE;
2375:
2376: l_recipe_id gmd_recipes_b.recipe_id%TYPE;
2377: l_recipe_no gmd_recipes_b.recipe_no%TYPE;
2378: l_recipe_version gmd_recipes_b.recipe_version%TYPE;
2379:
2380: l_routing_no gmd_routings_b.routing_no%TYPE;

Line 2377: l_recipe_no gmd_recipes_b.recipe_no%TYPE;

2373: l_formula_no fm_form_mst_b.formula_no%TYPE;
2374: l_formula_vers fm_form_mst_b.formula_vers%TYPE;
2375:
2376: l_recipe_id gmd_recipes_b.recipe_id%TYPE;
2377: l_recipe_no gmd_recipes_b.recipe_no%TYPE;
2378: l_recipe_version gmd_recipes_b.recipe_version%TYPE;
2379:
2380: l_routing_no gmd_routings_b.routing_no%TYPE;
2381: l_routing_vers gmd_routings_b.routing_vers%TYPE;

Line 2378: l_recipe_version gmd_recipes_b.recipe_version%TYPE;

2374: l_formula_vers fm_form_mst_b.formula_vers%TYPE;
2375:
2376: l_recipe_id gmd_recipes_b.recipe_id%TYPE;
2377: l_recipe_no gmd_recipes_b.recipe_no%TYPE;
2378: l_recipe_version gmd_recipes_b.recipe_version%TYPE;
2379:
2380: l_routing_no gmd_routings_b.routing_no%TYPE;
2381: l_routing_vers gmd_routings_b.routing_vers%TYPE;
2382: