DBA Data[Home] [Help]

APPS.GMD_QC_MIGRATE_TO_1151J dependencies on GME_BATCH_HEADER

Line 2357: gme_batch_header bh

2353: CURSOR c_recipe_id_no_vers (v_batch_id number) IS
2354: SELECT r.recipe_id, r.recipe_no, r.recipe_version
2355: FROM gmd_recipes r,
2356: gmd_recipe_validity_rules feff,
2357: gme_batch_header bh
2358: WHERE bh.batch_id = v_batch_id
2359: AND bh.recipe_validity_rule_id = feff.recipe_validity_rule_id
2360: AND feff.recipe_id = r.recipe_id;
2361:

Line 3818: gme_batch_header bh

3814: /* Get recipe_id based on batch_id */
3815: CURSOR c_recipe_id (v_batch_id number) IS
3816: SELECT feff.recipe_id
3817: FROM gmd_recipe_validity_rules feff,
3818: gme_batch_header bh
3819: WHERE bh.batch_id = v_batch_id
3820: AND bh.recipe_validity_rule_id = feff.recipe_validity_rule_id;
3821:
3822: /* Get the next spec validity rule id */