APPS.WSH_DATA_PROTECTION SQL Statements

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

Line: 60

  SELECT status_code, planned_flag
  FROM   wsh_new_deliveries
  WHERE  delivery_id = x_delivery_id;

Line: 65

  SELECT delivery_assignment_id
  FROM   wsh_delivery_assignments_v
  WHERE  delivery_id = x_delivery_id
  AND    rownum = 1;

Line: 71

  SELECT delivery_leg_id
  FROM   wsh_delivery_legs
  WHERE  delivery_id = x_delivery_id
  AND    rownum = 1;

Line: 77

  SELECT status_code, planned_flag
  FROM   wsh_trips
  WHERE  trip_id = x_entity_id;

Line: 82

  SELECT status_code
  FROM   wsh_trip_stops
  WHERE  stop_id = x_stop_id;

Line: 87

  SELECT delivery_id, pick_up_stop_id, drop_off_stop_id
  FROM   wsh_delivery_legs
  WHERE  delivery_leg_id = x_leg_id;

Line: 92

  SELECT delivery_id
  FROM   wsh_delivery_legs
  WHERE  pick_up_stop_id = x_stop_id
  AND    rownum = 1;

Line: 98

  SELECT delivery_id
  FROM   wsh_delivery_legs
  WHERE  drop_off_stop_id = x_stop_id
  AND    rownum = 1;

Line: 170

   x_disabled_list.delete;