APPS.GMD_ROUTING_STEPS_PUB dependencies on FM_ROUT_HDR

Line 957: from fm_rout_hdr

953: if UPPER(p_update_table(a).p_col_to_update) = 'OPRN_ID' THEN
954:
955: select effective_start_date,effective_end_date
956: into l_rout_start_date,l_rout_end_date
957: from fm_rout_hdr
958: where routing_id =l_routing_id;
959:
960: IF GMDRTVAL_PUB.check_oprn(poprn_id =>p_update_table(a).p_value
961: ,prouting_start_date => l_rout_start_date