APPS.GMD_QC_MIGRATE_TO_1151J dependencies on GMD_ROUTINGS_B

Line 2364: FROM gmd_routings_b

2360: AND feff.recipe_id = r.recipe_id;
2361:
2362: CURSOR c_routing_no_vers (v_routing_id number) IS
2363: SELECT routing_no, routing_vers
2364: FROM gmd_routings_b
2365: WHERE routing_id = v_routing_id;
2366:
2367: -- Get the formula name and version
2368: CURSOR c_formula_num_vers (v_formula_id number) IS

Line 2380: l_routing_no gmd_routings_b.routing_no%TYPE;

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:
2383: -- Get the operation name and version
2384: CURSOR c_oprn_num_vers (v_oprn_id number) IS

Line 2381: l_routing_vers gmd_routings_b.routing_vers%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:
2383: -- Get the operation name and version
2384: CURSOR c_oprn_num_vers (v_oprn_id number) IS
2385: SELECT oprn_no, oprn_vers