DBA Data[Home] [Help]

APPS.GME_CREATE_STEP_PVT dependencies on GMD_RECIPE_VALIDITY_RULES

Line 135: FROM gmd_recipe_validity_rules

131:
132: CURSOR cur_recipe_id (v_recipe_validity_rule_id NUMBER)
133: IS
134: SELECT recipe_id
135: FROM gmd_recipe_validity_rules
136: WHERE recipe_validity_rule_id = v_recipe_validity_rule_id;
137:
138: CURSOR cur_step_dates (
139: v_batch_id gme_batch_header.batch_id%TYPE

Line 2007: FROM gmd_recipe_validity_rules

2003: CURSOR cur_recipe_validity_rule (
2004: p_recipe_validity_rule_id gme_batch_header.recipe_validity_rule_id%TYPE)
2005: IS
2006: SELECT inventory_item_id
2007: FROM gmd_recipe_validity_rules
2008: WHERE recipe_validity_rule_id = p_recipe_validity_rule_id;
2009:
2010: load_steps_failed EXCEPTION;
2011: no_activities EXCEPTION;