APPS.FTE_FREIGHT_RATING_DLVY_GRP dependencies on HZ_PARTIES

Line 245: FROM hz_parties hz, wsh_carriers wc

241:
242: CURSOR c_get_carrier_name(c_carrier_id NUMBER)
243: IS
244: SELECT hz.party_name carrier_name
245: FROM hz_parties hz, wsh_carriers wc
246: WHERE hz.party_id = wc.carrier_id
247: AND nvl(wc.generic_flag,'N') = 'N'
248: AND wc.carrier_id = c_carrier_id;
249:

Line 4821: l_carrier_name hz_parties.party_name%type;

4817: l_carrier_id NUMBER;
4818: l_mode_of_transport wsh_carrier_services.mode_of_transport%type;
4819: l_service_level wsh_carrier_services.service_level%type;
4820:
4821: l_carrier_name hz_parties.party_name%type;
4822: l_mode_of_transport2 fnd_lookup_values_vl.meaning%type;
4823: l_service_level2 fnd_lookup_values_vl.meaning%type;
4824:
4825: l_del_has_trip VARCHAR2(1) := 'N';