APPS.FTE_LANE_SEARCH dependencies on WSH_CARRIER_VEHICLE_TYPES
Line 257: from wsh_carrier_vehicle_types
253: l_available BOOLEAN;
254:
255: cursor c_vehicle_available IS
256: select 1 257: from wsh_carrier_vehicle_types 258: where carrier_id = p_carrier_id
259: and vehicle_type_id = p_vehicle_id
260: and assigned_flag = 'Y'
261: and not exists