APPS.GME_FPL_PVT dependencies on GMD_RECIPE_VALIDITY_RULES

Line 39: FROM gme_batch_header b, gmd_recipe_validity_rules a

35: CURSOR cur_get_info (v_batch_id NUMBER)
36: IS
37: SELECT b.recipe_validity_rule_id, a.recipe_id, b.organization_id
38: ,b.routing_id, b.formula_id
39: FROM gme_batch_header b, gmd_recipe_validity_rules a
40: WHERE b.batch_id = v_batch_id
41: AND b.recipe_validity_rule_id = a.recipe_validity_rule_id;
42:
43: CURSOR cur_get_info_from_validity (v_validity_rule_id NUMBER)

Line 46: FROM gmd_recipes_b r, gmd_recipe_validity_rules v

42:
43: CURSOR cur_get_info_from_validity (v_validity_rule_id NUMBER)
44: IS
45: SELECT r.recipe_id, r.routing_id, r.formula_id
46: FROM gmd_recipes_b r, gmd_recipe_validity_rules v
47: WHERE v.recipe_validity_rule_id = v_validity_rule_id
48: AND v.recipe_id = r.recipe_id;
49:
50: CURSOR validity_process_loss_cursor (v_recipe_validity_rule_id NUMBER)

Line 53: FROM gmd_recipe_validity_rules

49:
50: CURSOR validity_process_loss_cursor (v_recipe_validity_rule_id NUMBER)
51: IS
52: SELECT fixed_process_loss, fixed_process_loss_uom
53: FROM gmd_recipe_validity_rules
54: WHERE recipe_validity_rule_id = NVL (v_recipe_validity_rule_id, -1);
55:
56: CURSOR orgn_process_loss_cursor (v_recipe_id NUMBER, v_org_id NUMBER)
57: IS