APPS.FTE_LANE_SEARCH SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 45

  SELECT postal_code  FROM wsh_locations
  WHERE wsh_location_id = p_loc_id;

Line: 256

    select 1
    from  wsh_carrier_vehicle_types
    where carrier_id = p_carrier_id
    and   vehicle_type_id = p_vehicle_id
    and   assigned_flag = 'Y'
    and not exists
           (select 1 from fte_lane_vehicles
            where quantity = 0
            and   origin_id = p_origin_id
            and   destination_id = p_dest_id
            and   carrier_id = p_carrier_id
            and   nvl(effective_start_date, nvl(p_date, sysdate)) <= nvl(p_date, sysdate)
            and   nvl(effective_end_date, nvl(p_date, sysdate)) >= nvl(p_date, sysdate)
            UNION
            select 1 from fte_lane_group_components c, fte_lane_vehicles l
            where  l.quantity = 0
            and    c.lane_group_id = l.lane_group_id
            and    c.origin_id = p_origin_id
            and    c.destination_id = p_dest_id
            and    l.carrier_id = p_carrier_id
            and    nvl(effective_start_date, nvl(p_date, sysdate)) <= nvl(p_date, sysdate)
            and    nvl(effective_end_date, nvl(p_date, sysdate)) >= nvl(p_date, sysdate));

Line: 1862

          SELECT shipping_control INTO l_shipping_control
          FROM wsh_new_deliveries
          WHERE delivery_id = p_search_criteria.delivery_id;

Line: 1967

                        l_lanes_tab.DELETE(k);