APPS.PQP_VRE_SHD SQL Statements

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

Line: 48

    SELECT
       vehicle_repository_id
      ,effective_start_date
      ,effective_end_date
      ,registration_number
      ,vehicle_type
      ,vehicle_id_number
      ,business_group_id
      ,make
      ,model
      ,initial_registration
      ,last_registration_renew_date
      ,engine_capacity_in_cc
      ,fuel_type
      ,currency_code
      ,list_price
      ,accessory_value_at_startdate
      ,accessory_value_added_later
      ,market_value_classic_car
      ,fiscal_ratings
      ,fiscal_ratings_uom
      ,vehicle_provider
      ,vehicle_ownership
      ,shared_vehicle
      ,vehicle_status
      ,vehicle_inactivity_reason
      ,asset_number
      ,lease_contract_number
      ,lease_contract_expiry_date
      ,taxation_method
      ,fleet_info
      ,fleet_transfer_date
      ,object_version_number
      ,color
      ,seating_capacity
      ,weight
      ,weight_uom
      ,model_year
      ,insurance_number
      ,insurance_expiry_date
      ,comments
      ,vre_attribute_category
      ,vre_attribute1
      ,vre_attribute2
      ,vre_attribute3
      ,vre_attribute4
      ,vre_attribute5
      ,vre_attribute6
      ,vre_attribute7
      ,vre_attribute8
      ,vre_attribute9
      ,vre_attribute10
      ,vre_attribute11
      ,vre_attribute12
      ,vre_attribute13
      ,vre_attribute14
      ,vre_attribute15
      ,vre_attribute16
      ,vre_attribute17
      ,vre_attribute18
      ,vre_attribute19
      ,vre_attribute20
      ,vre_information_category
      ,vre_information1
      ,vre_information2
      ,vre_information3
      ,vre_information4
      ,vre_information5
      ,vre_information6
      ,vre_information7
      ,vre_information8
      ,vre_information9
      ,vre_information10
      ,vre_information11
      ,vre_information12
      ,vre_information13
      ,vre_information14
      ,vre_information15
      ,vre_information16
      ,vre_information17
      ,vre_information18
      ,vre_information19
      ,vre_information20
   FROM    pqp_vehicle_repository_f
   WHERE   vehicle_repository_id = p_vehicle_repository_id
   AND     p_effective_date
   BETWEEN effective_start_date and effective_end_date;

Line: 191

  ,p_update                 OUT NOCOPY BOOLEAN
  ,p_update_override        OUT NOCOPY BOOLEAN
  ,p_update_change_insert   OUT NOCOPY BOOLEAN
  ) IS
--
  l_proc        varchar2(72) := g_package||'find_dt_upd_modes';

Line: 209

    ,p_update                => p_update
    ,p_update_override       => p_update_override
    ,p_update_change_insert  => p_update_change_insert
    );

Line: 224

  ,p_delete                OUT NOCOPY BOOLEAN
  ,p_future_change         OUT NOCOPY BOOLEAN
  ,p_delete_next_change    OUT NOCOPY BOOLEAN
  ) IS
  --
  l_proc                varchar2(72)    := g_package||'find_dt_del_modes';

Line: 243

   ,p_delete                        => p_delete
   ,p_future_change                 => p_future_change
   ,p_delete_next_change            => p_delete_next_change
   );

Line: 285

  UPDATE  pqp_vehicle_repository_f t
     SET  t.effective_end_date    = p_new_effective_end_date,
          t.object_version_number = l_object_version_number
   WHERE  t.vehicle_repository_id = p_base_key_value
     AND  p_effective_date
 BETWEEN  t.effective_start_date and t.effective_end_date;

Line: 319

   SELECT
       vehicle_repository_id
      ,effective_start_date
      ,effective_end_date
      ,registration_number
      ,vehicle_type
      ,vehicle_id_number
      ,business_group_id
      ,make
      ,model
      ,initial_registration
      ,last_registration_renew_date
      ,engine_capacity_in_cc
      ,fuel_type
      ,currency_code
      ,list_price
      ,accessory_value_at_startdate
      ,accessory_value_added_later
      ,market_value_classic_car
      ,fiscal_ratings
      ,fiscal_ratings_uom
      ,vehicle_provider
      ,vehicle_ownership
      ,shared_vehicle
      ,vehicle_status
      ,vehicle_inactivity_reason
      ,asset_number
      ,lease_contract_number
      ,lease_contract_expiry_date
      ,taxation_method
      ,fleet_info
      ,fleet_transfer_date
      ,object_version_number
      ,color
      ,seating_capacity
      ,weight
      ,weight_uom
      ,model_year
      ,insurance_number
      ,insurance_expiry_date
      ,comments
      ,vre_attribute_category
      ,vre_attribute1
      ,vre_attribute2
      ,vre_attribute3
      ,vre_attribute4
      ,vre_attribute5
      ,vre_attribute6
      ,vre_attribute7
      ,vre_attribute8
      ,vre_attribute9
      ,vre_attribute10
      ,vre_attribute11
      ,vre_attribute12
      ,vre_attribute13
      ,vre_attribute14
      ,vre_attribute15
      ,vre_attribute16
      ,vre_attribute17
      ,vre_attribute18
      ,vre_attribute19
      ,vre_attribute20
      ,vre_information_category
      ,vre_information1
      ,vre_information2
      ,vre_information3
      ,vre_information4
      ,vre_information5
      ,vre_information6
      ,vre_information7
      ,vre_information8
      ,vre_information9
      ,vre_information10
      ,vre_information11
      ,vre_information12
      ,vre_information13
      ,vre_information14
      ,vre_information15
      ,vre_information16
      ,vre_information17
      ,vre_information18
      ,vre_information19
      ,vre_information20
    FROM    pqp_vehicle_repository_f
    WHERE   vehicle_repository_id = p_vehicle_repository_id
    AND     p_effective_date
    BETWEEN effective_start_date and effective_end_date
    FOR UPDATE NOWAIT;

Line: 437

  IF (p_datetrack_mode <> hr_api.g_insert) THEN
    --
    -- We must select and lock the current row.
    --
    OPEN  C_Sel1;