APPS.PER_RI_CONFIG_FND_HR_ENTITY SQL Statements

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

Line: 25

    select job_segment_name,
           job_segment_type,
           industry_attribute,
           CONFIG_SEQUENCE
      from per_ri_config_job_kf_seg_v
     where configuration_code = cp_configuration_code
       and industry_attribute = per_ri_config_main.g_global_fed_job_non_fed_att
       order by CONFIG_SEQUENCE;

Line: 368

   select position_segment_name,
          position_segment_type,
          industry_attribute,
          CONFIG_SEQUENCE
      from per_ri_config_pos_kf_seg_v
     where configuration_code = cp_configuration_code
       and industry_attribute = per_ri_config_main.g_global_fed_pos_non_fed_att
       order by CONFIG_SEQUENCE;

Line: 378

   select count(*)
      from per_ri_config_pos_kf_seg_v
     where configuration_code = cp_configuration_code
       and industry_attribute = per_ri_config_main.g_global_fed_pos_non_fed_att;

Line: 1008

    select grade_segment_name,
           grade_segment_type,
           industry_attribute,
           CONFIG_SEQUENCE
      from per_ri_config_grade_kf_seg_v
     where configuration_code = cp_configuration_code
       and industry_attribute = per_ri_config_main.g_global_fed_grd_non_fed_att
       order by CONFIG_SEQUENCE;

Line: 1299

    select distinct per_ri_config_utilities.return_config_entity_name(rv.regional_variance_name),
           rv.regional_variance_name,  rv.REG_VARIANCE_COUNTRY_CODE
      from per_ri_config_jp_rv_v rv,
           per_ri_config_job_rv_seg_v seg
     where rv.configuration_code = cp_configuration_code
       and rv.configuration_code = seg.configuration_code
       and rv.regional_variance_name = seg.regional_variance_name
       and seg.global_structure_indicator = 'N';

Line: 1310

    select distinct segment_type
                   ,segment_name
                   ,CONFIG_SEQUENCE
      from per_ri_config_job_rv_seg_v
     where configuration_code        = cp_configuration_code
       and regional_variance_name    = cp_jobs_rv_name
       order by CONFIG_SEQUENCE;

Line: 1340

  l_country_selected          varchar2(10);

Line: 1349

    select legislation_code into l_country_selected from per_business_groups
      where business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID');

Line: 1366

        AND l_rv_country_code = l_country_selected THEN
         hr_utility.set_location('skip the creation of the flexfield structure', 90);

Line: 1510

    select distinct per_ri_config_utilities.return_config_entity_name(regional_variance_name),
           regional_variance_name, REG_VARIANCE_COUNTRY_CODE
      from per_ri_config_jp_rv_v
     where configuration_code = cp_configuration_code
       and exists (select configuration_code
                     from per_ri_config_pos_rv_seg_v
                    where configuration_code   = cp_configuration_code);

Line: 1520

    select distinct segment_type
                   ,segment_name
                   ,CONFIG_SEQUENCE
      from per_ri_config_pos_rv_seg_v
     where configuration_code        = cp_configuration_code
       and regional_variance_name    = cp_positions_rv_name
       order by CONFIG_SEQUENCE;

Line: 1550

  l_country_selected          varchar2(10);

Line: 1558

    select legislation_code into l_country_selected from per_business_groups
      where business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID');

Line: 1575

        AND l_rv_country_code = l_country_selected THEN
         hr_utility.set_location('skip the creation of the flexfield structure', 90);

Line: 1719

    select distinct per_ri_config_utilities.return_config_entity_name(regional_variance_name),
           regional_variance_name, REG_VARIANCE_COUNTRY_CODE
      from per_ri_config_grd_rv_v
     where configuration_code = cp_configuration_code;

Line: 1726

    select distinct segment_type
                   ,segment_name
                   ,CONFIG_SEQUENCE
      from per_ri_config_grd_rv_seg_v
     where configuration_code        = cp_configuration_code
       and regional_variance_name    = cp_grade_rv_name
       order by CONFIG_SEQUENCE;

Line: 1756

  l_country_selected          varchar2(10);

Line: 1764

    select legislation_code into l_country_selected from per_business_groups
      where business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID');

Line: 1782

        AND l_rv_country_code = l_country_selected THEN
         hr_utility.set_location('skip the creation of the flexfield structure', 90);

Line: 3778

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

Line: 3790

    select country_code
      from per_ri_config_country_v
     where configuration_code = cp_configuration_code
       and country_code in (select distinct territory_code
                                     from per_ri_config_responsibility);

Line: 3798

    select product_name
      from per_ri_config_prod_selection_v
     where configuration_code = cp_configuration_code;

Line: 3804

    select distinct resp.responsibility_key,
           apps.application_short_name
      from fnd_application  apps,
           fnd_responsibility  resp,
           per_ri_config_responsibility con,
           per_ri_config_country_v      cont
     where apps.application_id = resp.application_id
       and con.responsibility_key = resp.responsibility_key
       and resp.responsibility_key = con.responsibility_key
       and resp.responsibility_key = con.responsibility_key
       and con.territory_code             = cp_territory_code
       and con.responsibility_application = cp_responsibility_application
       and con.territory_code = cont.country_code
       and cont.country_code in (select distinct territory_code
                                     from per_ri_config_responsibility);

Line: 3821

    select country_code
     from  per_ri_config_country_v con
    where con.configuration_code = cp_configuration_code
      and con.country_code not in (select distinct territory_code
                                     from per_ri_config_responsibility)
      and per_ri_config_utilities.business_group_decision
                                   (cp_configuration_code
                                   ,country_code)  <> 'INT' ;

Line: 4191

    select product_name
      from per_ri_config_prod_selection_v
     where configuration_code = cp_configuration_code;

Line: 4246

    for rec in ( select application_id
                    from   fnd_application
                    where hr_general.chk_application_id(application_id) = 'TRUE'
                    Order by Application_short_name)
      loop

        if fnd_profile.save ('ENABLE_SECURITY_GROUPS'
                          ,'Y'
                          ,'APPL'
                          ,rec.application_id ) then

          l_log_message := 'Setting the Enable Security Groups Profile to the application '
                           || rec.application_id;

Line: 4293

    select product_name
      from per_ri_config_prod_selection_v
     where configuration_code = cp_configuration_code;

Line: 4298

    select apps.application_short_name
      from fnd_responsibility resp,
           fnd_application    apps
     where apps.application_id = resp.application_id
       and resp.responsibility_key = cp_responsibility_key;

Line: 4395

    select apps.application_short_name,resp.responsibility_id
      from fnd_responsibility resp,
           fnd_application    apps
     where apps.application_id = resp.application_id
       and resp.responsibility_key = cp_responsibility_key;

Line: 4402

    select business_group_id
      from per_business_groups
     where name = cp_business_group_name;

Line: 4407

    select security_profile_id
      from per_security_profiles
     where security_profile_name = cp_business_group_name;

Line: 4412

    select product_name
      from per_ri_config_prod_selection_v
     where configuration_code = cp_configuration_code;