APPS.FTE_UTIL_PKG dependencies on HZ_PARTIES

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;

Line 168: l_carrier_name HZ_PARTIES.PARTY_NAME%TYPE;

164: -- 1. p_carrier_name: carrier name
165: -----------------------------------------------------------------------------
166: FUNCTION GET_CARRIER_NAME(p_carrier_id IN NUMBER) RETURN VARCHAR2 IS
167:
168: l_carrier_name HZ_PARTIES.PARTY_NAME%TYPE;
169: l_module_name CONSTANT VARCHAR2(100) := 'FTE.PLSQL.' || G_PKG_NAME || '.GET_CARRIER_NAME';
170:
171: BEGIN
172:

Line 175: FROM HZ_PARTIES hz

171: BEGIN
172:
173: SELECT hz.PARTY_name
174: INTO l_carrier_name
175: FROM HZ_PARTIES hz
176: WHERE hz.party_id = p_carrier_id;
177:
178: RETURN l_carrier_name;
179: