DBA Data[Home] [Help]

APPS.GMD_STATUS_CODE dependencies on GMD_RECIPES_B

Line 172: SELECT g.recipe_status FROM gmd_recipe_validity_rules vr, gmd_recipes_b g

168: --KKILLAMS, Bug# 3283888: Validating the rule status aganist recipe status if recipe status is 'NEW'
169: --Set FALSE to "dependent_status_ok" variable if recipe status is NEW and validate rule status is FROZEN.
170: IF (p_entity_type =5) THEN
171: OPEN Recipe_Status_cur FOR
172: SELECT g.recipe_status FROM gmd_recipe_validity_rules vr, gmd_recipes_b g
173: WHERE vr.recipe_id = g.recipe_id
174: AND vr.recipe_validity_rule_id = p_Entity_id;
175: FETCH recipe_status_cur INTO l_cur_dependent_status;
176: CLOSE recipe_status_cur;