APPS.PER_RI_CONFIG_IMPORT_PKG SQL Statements

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

Line: 15

   Select object_version_number
     From per_ri_configurations
    Where configuration_code = p_configuration_code;

Line: 21

  Select config_information2
  From per_ri_config_information
  Where configuration_code <> p_configuration_code
  And  config_information_category='CONFIG ENTERPRISE'
  And config_information2 = p_enterprise_shortname;

Line: 125

   Select object_version_number
        ,config_information_id
     From per_ri_config_information
    Where configuration_code = p_configuration_code
      and config_information_category = p_config_information_category
      and config_sequence = p_config_sequence;

Line: 135

   select location_id
   from per_ri_config_locations
   where location_code = p_location_code
   and configuration_code = p_configuration_code;

Line: 323

    Select object_version_number , location_id
      From per_ri_config_locations
     Where configuration_code    = p_configuration_code
       and configuration_context = p_configuration_context
       and location_code         = p_location_code;