APPS.GMD_SPEC_MATCH_GRP dependencies on FM_FORM_MST_B

Line 542: l_formula_no FM_FORM_MST_B.formula_no%TYPE;

538: l_check_for_given_grade VARCHAR2(1) := 'N';
539: l_check_for_null_grade VARCHAR2(1) := 'N';
540: l_check_for_default_grade VARCHAR2(1) := 'N';
541: l_recipe_no GMD_RECIPES_B.recipe_no%TYPE;
542: l_formula_no FM_FORM_MST_B.formula_no%TYPE;
543: l_routing_no GMD_ROUTINGS_B.routing_no%TYPE;
544: l_oprn_no GMD_OPERATIONS_B.oprn_no%TYPE;
545: l_recipe_version GMD_RECIPES_B.recipe_version%TYPE;
546: l_formula_vers FM_FORM_MST_B.formula_vers%TYPE;

Line 546: l_formula_vers FM_FORM_MST_B.formula_vers%TYPE;

542: l_formula_no FM_FORM_MST_B.formula_no%TYPE;
543: l_routing_no GMD_ROUTINGS_B.routing_no%TYPE;
544: l_oprn_no GMD_OPERATIONS_B.oprn_no%TYPE;
545: l_recipe_version GMD_RECIPES_B.recipe_version%TYPE;
546: l_formula_vers FM_FORM_MST_B.formula_vers%TYPE;
547: l_routing_vers GMD_ROUTINGS_B.routing_vers%TYPE;
548: l_oprn_vers GMD_OPERATIONS_B.oprn_vers%TYPE;
549: l_step_no NUMBER(10);
550:

Line 677: FROM fm_form_mst_b

673:
674: IF p_wip_spec_rec.formula_id IS NOT NULL AND p_wip_spec_rec.formula_no IS NULL AND p_wip_spec_rec.formula_vers IS NULL THEN
675: BEGIN
676: SELECT formula_no,formula_vers INTO l_formula_no,l_formula_vers
677: FROM fm_form_mst_b
678: WHERE formula_id = p_wip_spec_rec.formula_id;
679:
680: EXCEPTION
681: WHEN OTHERS THEN