APPS.FTE_UTIL_PKG dependencies on WSH_CARRIERS

Line 143: FROM HZ_PARTIES hz, WSH_CARRIERS ca

139: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.GET_CARRIER_ID';
140:
141: BEGIN
142: SELECT hz.PARTY_ID INTO l_carrier_id
143: FROM HZ_PARTIES hz, WSH_CARRIERS ca
144: WHERE hz.party_name = p_carrier_name
145: AND hz.party_id = ca.carrier_id;
146:
147: RETURN l_carrier_id;