DBA Data[Home] [Help]

APPS.GMD_RECIPE_GENERATE dependencies on GMD_RECIPES_B

Line 422: FROM gmd_recipes_b

418:
419:
420: CURSOR Cur_get_recipe_status (V_recipe_no VARCHAR2, V_recipe_version NUMBER)IS
421: SELECT recipe_status
422: FROM gmd_recipes_b
423: WHERE recipe_no = V_recipe_no
424: AND recipe_version = V_recipe_version;
425:
426: -- Kapil LCF-GMO ME : Bug#5458666

Line 526: UPDATE gmd_recipes_b

522: END IF;
523:
524: IF (l_default_recipe_status.entity_status <> 100) THEN
525: IF p_event_signed THEN
526: UPDATE gmd_recipes_b
527: SET recipe_status = l_default_recipe_status.entity_status
528: WHERE recipe_no = l_recipe_tbl.recipe_no
529: AND recipe_version = l_recipe_tbl.recipe_version;
530: ELSE -- IF p_event_signed