DBA Data[Home] [Help]

APPS.GME_CREATE_STEP_PVT dependencies on GMD_RECIPE_VALIDITY_RULES

Line 139: FROM gmd_recipe_validity_rules

135:
136: CURSOR cur_recipe_id (v_recipe_validity_rule_id NUMBER)
137: IS
138: SELECT recipe_id
139: FROM gmd_recipe_validity_rules
140: WHERE recipe_validity_rule_id = v_recipe_validity_rule_id;
141:
142: CURSOR cur_step_dates (
143: v_batch_id gme_batch_header.batch_id%TYPE

Line 2132: FROM gmd_recipe_validity_rules

2128: CURSOR cur_recipe_validity_rule (
2129: p_recipe_validity_rule_id gme_batch_header.recipe_validity_rule_id%TYPE)
2130: IS
2131: SELECT inventory_item_id
2132: FROM gmd_recipe_validity_rules
2133: WHERE recipe_validity_rule_id = p_recipe_validity_rule_id;
2134:
2135: load_steps_failed EXCEPTION;
2136: no_activities EXCEPTION;