APPS.PER_RI_CONFIG_FND_DEF_ENTITY SQL Statements

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

Line: 22

  select user_id
  from   fnd_user
  where  user_name = cp_user_name;

Line: 138

    if (per_ri_config_utilities.check_selected_product
                               (p_configuration_code    => p_configuration_code
                               ,p_product_name          => 'PER')) then
      --ENABLE_SECURITY_GROUPS
    if NOT (p_technical_summary_mode) then
      per_ri_config_utilities.set_profile_option_value
                           (p_level                => 10002
                           ,p_level_value          => 'PER'
                           ,p_level_value_app      => 'PER'
			   ,p_profile_name         => 'ENABLE_SECURITY_GROUPS'
                           ,p_profile_option_value => 'Y');

Line: 165

   if (per_ri_config_utilities.check_selected_product
                               (p_configuration_code    => p_configuration_code
                               ,p_product_name          => 'PAY')) then
     --ENABLE_SECURITY_GROUPS
    if NOT (p_technical_summary_mode) then
     per_ri_config_utilities.set_profile_option_value
                          (p_level                => 10002
                          ,p_level_value          => 'PAY'
                          ,p_level_value_app      => 'PAY'
                          ,p_profile_name         => 'ENABLE_SECURITY_GROUPS'
                          ,p_profile_option_value => 'Y');

Line: 192

    if (per_ri_config_utilities.check_selected_product
                               (p_configuration_code    => p_configuration_code
                               ,p_product_name          => 'BEN')) then
      --ENABLE_SECURITY_GROUPS
    if NOT (p_technical_summary_mode) then
      per_ri_config_utilities.set_profile_option_value
                           (p_level                => 10002
                           ,p_level_value          => 'BEN'
                           ,p_level_value_app      => 'BEN'
                           ,p_profile_name         => 'ENABLE_SECURITY_GROUPS'
                           ,p_profile_option_value => 'Y');

Line: 311

    if (per_ri_config_utilities.check_selected_product
                               (p_configuration_code    => p_configuration_code
                               ,p_product_name          => 'SSHR')) then
      --HR_SELF_SERVICE_HR_LICENSED
    if NOT (p_technical_summary_mode) then
      per_ri_config_utilities.set_profile_option_value
                           (p_level                => 10001
                           ,p_level_value          => 0
                           ,p_level_value_app      => 'PER'
                           ,p_profile_name         => 'HR_SELF_SERVICE_HR_LICENSED'
                           ,p_profile_option_value => 'Y');

Line: 372

    select product_name
      from per_ri_config_prod_selection_v
     where configuration_code = cp_configuration_code;