APPS.GMD_RECIPE_HEADER_PVT dependencies on GMD_RECIPE_STEP_MATERIALS

Line 397: FROM gmd_recipe_step_materials a, fm_matl_dtl b

393:
394: -- Cursor and declaration as per as Bug 5138316 KSHUKLA
395: CURSOR Cur_get_formula(vRecipe_id NUMBER, vFormula_id NUMBER) IS
396: SELECT 1
397: FROM gmd_recipe_step_materials a, fm_matl_dtl b
398: WHERE a.recipe_id = vRecipe_id
399: AND a.formulaline_id = b.formulaline_id
400: AND b.formula_id <>vFormula_id ;
401:

Line 413: FROM gmd_recipe_step_materials a, fm_rout_dtl b

409: and formula_id = vFormula_id);
410:
411: CURSOR Cur_check_routing(vRecipe_id NUMBER, vRouting_id NUMBER) IS
412: SELECT 1
413: FROM gmd_recipe_step_materials a, fm_rout_dtl b
414: WHERE a.recipe_id = vRecipe_id
415: AND a.routingstep_id = b.routingstep_id
416: AND b.routing_id <> NVL(vRouting_id, 0);
417:

Line 652: delete from gmd_recipe_step_materials

648: IF l_deleteRoutDependent THEN
649: delete from gmd_recipe_routing_steps
650: WHERE recipe_id =p_recipe_header_rec.recipe_id;
651:
652: delete from gmd_recipe_step_materials
653: WHERE recipe_id =p_recipe_header_rec.recipe_id;
654:
655: END IF;
656: