APPS.PER_RI_CONFIG_MAIN SQL Statements

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

Line: 55

    select distinct configuration_code,
           per_ri_config_utilities.business_group_decision(configuration_code,country_code)
      from per_ri_config_country_v
     where configuration_code = cp_configuration_code;

Line: 201

    select enterprise_id into l_enterprise_id from per_ent_security_groups
     where business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID');

Line: 754

    select unique_key_id from hr_pump_batch_line_user_keys
      where batch_line_id in (select batch_line_id from hr_pump_batch_lines
        where batch_id = c_batch_id and api_module_id = (select api_module_id
         from hr_api_modules where module_name = 'CREATE_BUSINESS_GROUP'));

Line: 760

    select distinct configuration_code,
           per_ri_config_utilities.business_group_decision(configuration_code,country_code)
      from per_ri_config_country_v
     where configuration_code = cp_configuration_code;

Line: 876

    select enterprise_id into l_enterprise_id from per_ent_security_groups
     where business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID');

Line: 886

     select 'C::'||enterprise_label into l_label from per_ent_security_groups
     where security_group_id = fnd_global.security_group_id;

Line: 1467

    per_ri_config_utilities.update_configuration_status(p_configuration_code);