APPS.FTE_TL_LOADER dependencies on HZ_PARTIES

Line 175: HZ_PARTIES hz

171: l_volume_uom
172: FROM
173: WSH_CARRIER_SERVICES cs,
174: WSH_CARRIERS ca,
175: HZ_PARTIES hz
176: WHERE
177: cs.carrier_id(+) = ca.carrier_id AND
178: cs.service_level(+) = p_service_level AND
179: cs.mode_of_transport = l_mode_of_trans AND

Line 4905: HZ_PARTIES hz,

4901: BEGIN
4902: SELECT
4903: 'MOD_' || hz.party_id || '_' || l_service_level INTO l_name
4904: FROM
4905: HZ_PARTIES hz,
4906: WSH_CARRIERS ca
4907: WHERE
4908: hz.party_name = l_carrier_name AND
4909: hz.party_id = ca.carrier_id;