APPS.GMD_SPEC_MATCH_GRP dependencies on FM_ROUT_DTL

Line 733: FROM fm_rout_dtl

729: EXCEPTION
730: WHEN OTHERS THEN
731: BEGIN
732: SELECT ROUTINGSTEP_NO INTO l_step_no
733: FROM fm_rout_dtl
734: WHERE routingstep_id = p_wip_spec_rec.step_id
735: AND routing_id = p_wip_spec_rec.routing_id;
736:
737: EXCEPTION WHEN OTHERS THEN

Line 744: FROM fm_rout_dtl

740: END;
741: ELSIF p_wip_spec_rec.routing_id IS NOT NULL THEN
742: BEGIN
743: SELECT ROUTINGSTEP_NO INTO l_step_no
744: FROM fm_rout_dtl
745: WHERE routingstep_id = p_wip_spec_rec.step_id
746: AND routing_id = p_wip_spec_rec.routing_id ;
747:
748: EXCEPTION