DBA Data[Home] [Help]

APPS.GMD_QC_MIGRATE_TO_1151J dependencies on GMD_RECIPE_VALIDITY_RULES

Line 2356: gmd_recipe_validity_rules feff,

2352: -- Get the recipe id + no + version
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;

Line 3817: FROM gmd_recipe_validity_rules feff,

3813:
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: