APPS.GMD_STATUS_CODE dependencies on GME_BATCH_HEADER

Line 207: from gme_batch_header

203: AND (r.recipe_status BETWEEN 700 AND 799
204: OR r.recipe_Status BETWEEN 400 AND 499
205: OR r.recipe_Status BETWEEN 900 AND 999)
206: AND EXISTS (select 1
207: from gme_batch_header
208: Where batch_status IN (1,2,3,-3)
209: AND recipe_validity_rule_id = v.recipe_validity_rule_id);
210:
211: CURSOR Cur_Check_routing_recipe(l_routing_id NUMBER) IS

Line 249: FROM gme_batch_header

245: OR recipe_status between 900 and 999);
246:
247: CURSOR Cur_check_valrle_batch(l_validity_rule_id NUMBER) IS
248: SELECT count(*)
249: FROM gme_batch_header
250: WHERE recipe_validity_rule_id = l_validity_rule_id
251: AND batch_status IN (1,2,3,-3);
252:
253: l_count NUMBER;