APPS.GME_COMMON_PVT dependencies on GMD_RECIPES

Line 983: FROM gmd_recipes_b r, gmd_recipe_validity_rules v

979:
980: CURSOR cur_get_info_from_validity (v_validity_rule_id NUMBER)
981: IS
982: SELECT r.recipe_id, r.routing_id, r.formula_id
983: FROM gmd_recipes_b r, gmd_recipe_validity_rules v
984: WHERE v.recipe_validity_rule_id = v_validity_rule_id
985: AND v.recipe_id = r.recipe_id;
986:
987: /*Bug#5618961 cursor modified to select routing class uom instead of

Line 1006: FROM gmd_recipes

1002:
1003: CURSOR recipe_process_loss_cursor (v_recipe_id NUMBER)
1004: IS
1005: SELECT planned_process_loss
1006: FROM gmd_recipes
1007: WHERE recipe_id = v_recipe_id;
1008:
1009: /*Bug#5618961 cursor modified to select routing qty and uom */
1010: CURSOR routing_process_loss_cursor (v_routing_id NUMBER)