APPS.GMD_SPREAD_FETCH_PKG dependencies on GMD_RECIPE_VALIDITY_RULES

Line 219: FROM gmd_recipes r, gmd_recipe_validity_rules v

215: l_labrec Cur_get_lab_lots%ROWTYPE;
216:
217: CURSOR Cur_get_formulaid (V_validity_rule_id NUMBER) IS
218: SELECT formula_id
219: FROM gmd_recipes r, gmd_recipe_validity_rules v
220: WHERE recipe_validity_rule_id = V_validity_rule_id
221: AND r.recipe_id = v.recipe_id;
222:
223: l_return_status VARCHAR2(1);

Line 535: FROM gmd_recipes r, gmd_recipe_validity_rules v

531: l_formulaline_id NUMBER DEFAULT 0;
532:
533: CURSOR Cur_get_formulaid (V_validity_rule_id NUMBER) IS
534: SELECT formula_id
535: FROM gmd_recipes r, gmd_recipe_validity_rules v
536: WHERE recipe_validity_rule_id = V_validity_rule_id
537: AND r.recipe_id = v.recipe_id;
538:
539: l_return_status VARCHAR2(1);

Line 1988: FROM gmd_recipes r, gmd_recipe_validity_rules v

1984: l_formulaline_id NUMBER DEFAULT 0;
1985:
1986: CURSOR Cur_get_formulaid (V_validity_rule_id NUMBER) IS
1987: SELECT formula_id
1988: FROM gmd_recipes r, gmd_recipe_validity_rules v
1989: WHERE recipe_validity_rule_id = V_validity_rule_id
1990: AND r.recipe_id = v.recipe_id;
1991:
1992: l_return_status VARCHAR2(1);