APPS.GMD_SPREAD_FETCH_PKG dependencies on GMD_RECIPES

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 534: FROM gmd_recipes r, gmd_recipe_validity_rules v

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