APPS.PER_US_ETHNIC SQL Statements

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

Line: 22

    Description : Package that updates ethnic code 9 to ethnic
                  code 3 for 2007.

    Change List
    -----------
     Date        Name      Vers    Bug No    Description
     ----        ----      ------  -------   -----------
     29-OCT-06   ssouresr  115.0             Created
*/

procedure ethnic_code_upd (errbuf     out nocopy varchar2,
                           retcode    out nocopy number)
is
  ln_business_group_id       NUMBER;

Line: 43

  select hoi.organization_id, hou.name
  from   hr_organization_units hou,
         hr_organization_information hoi,
         hr_organization_information hoi1
  where hoi.org_information_context = 'Business Group Information'
  and hoi.org_information9 = 'US'
  and hou.organization_id = hoi.organization_id
  and hou.organization_id = hoi1.organization_id
  and hoi1.org_information_context = 'CLASS'
  and hoi1.org_information1 = 'HR_BG'
  and hoi1.org_information2 = 'Y';

Line: 64

      UPDATE per_all_people_f
      SET per_information1 = '3'
      WHERE per_information1 = '9'
      AND   business_group_id = ln_business_group_id;

Line: 76

       hr_utility.trace('Error during update process: ' || v_errortext || ' ' || v_errorcode);