APPS.FTE_TRACKING_WRAPPER dependencies on WSH_CARRIERS

Line 985: FROM hz_parties h, wsh_carriers w

981: -- inner exception handling
982: BEGIN
983: --select party_id into l_carrier_id from hz_parties where party_name = l_carrier_name;
984: SELECT h.party_id INTO l_carrier_id
985: FROM hz_parties h, wsh_carriers w
986: WHERE h.party_id = w.carrier_id
987: AND party_name = l_carrier_name;
988: EXCEPTION
989: WHEN NO_DATA_FOUND THEN