DBA Data[Home] [Help]

APPS.GMD_RECIPE_GENERATE dependencies on GMD_RECIPES_B

Line 484: FROM gmd_recipes_b

480:
481:
482: CURSOR Cur_get_recipe_status (V_recipe_no VARCHAR2, V_recipe_version NUMBER)IS
483: SELECT recipe_status
484: FROM gmd_recipes_b
485: WHERE recipe_no = V_recipe_no
486: AND recipe_version = V_recipe_version;
487:
488: -- Kapil LCF-GMO ME : Bug#5458666

Line 590: UPDATE gmd_recipes_b

586: END IF;
587:
588: IF (l_default_recipe_status.entity_status <> 100) THEN
589: IF p_event_signed THEN
590: UPDATE gmd_recipes_b
591: SET recipe_status = l_default_recipe_status.entity_status
592: WHERE recipe_no = l_recipe_tbl.recipe_no
593: AND recipe_version = l_recipe_tbl.recipe_version;
594: ELSE -- IF p_event_signed