APPS.PER_RI_CONFIG_MAIN SQL Statements

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

Line: 700

    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: 813

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

Line: 823

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

Line: 1337

    per_ri_config_utilities.update_configuration_status(p_configuration_code);