APPS.FTE_FREIGHT_RATING_DLVY_GRP dependencies on FND_LOOKUP_VALUES_VL

Line 253: FROM fnd_lookup_values_vl

249:
250: CURSOR c_get_mode_of_transport(c_mode_of_transport_code VARCHAR2)
251: IS
252: SELECT meaning mode_of_transport
253: FROM fnd_lookup_values_vl
254: WHERE lookup_type = 'WSH_MODE_OF_TRANSPORT'
255: AND nvl(start_date_active, sysdate) <= sysdate
256: AND nvl(end_date_active, sysdate) >= sysdate
257: AND enabled_flag='Y'

Line 263: FROM fnd_lookup_values_vl

259:
260: CURSOR c_get_service_level(c_service_type_code VARCHAR2)
261: IS
262: SELECT meaning service_type
263: FROM fnd_lookup_values_vl
264: WHERE lookup_type = 'WSH_SERVICE_LEVELS'
265: AND nvl(start_date_active, sysdate) <= sysdate
266: AND nvl(end_date_active, sysdate) >= sysdate
267: AND enabled_flag='Y'

Line 4822: l_mode_of_transport2 fnd_lookup_values_vl.meaning%type;

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';
4826: l_del_org_manifest_enabled VARCHAR2(1) := 'N';

Line 4823: l_service_level2 fnd_lookup_values_vl.meaning%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';
4826: l_del_org_manifest_enabled VARCHAR2(1) := 'N';
4827: l_carrier_manifest_enabled VARCHAR2(1) := 'N';