APPS.HR_ORGANIZATION_INTERNAL SQL Statements

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

Line: 44

  select hou1.org_information_id,hou1.org_information_context,hou1.object_version_number
    	 ,ho1.object_version_number
  from
       hr_all_organization_units ho1,
       hr_organization_information hou1
  where ho1.organization_id=l_organization_id
  and hou1.organization_id=ho1.organization_id
  and hou1.org_information_context='Exp Organization Defaults';

Line: 55

  select 'Y'
  from hr_all_organization_units
  where organization_id=l_organization_id
  and nvl(internal_external_flag,'X')=nvl(l_internal_external_flag,'X');

Line: 62

  select object_version_number
  from  hr_all_organization_units
  where organization_id=l_organization_id
  and
  (name <> l_organization_name
   or date_from <> l_date_from
   or nvl(date_to,to_date('31/12/4712','dd/mm/rrrr')) <>
  		nvl(l_date_to,to_date('31/12/4712','dd/mm/rrrr')));

Line: 74

select 'Y' from HR_OPERATING_UNITS
where trunc(sysdate) between trunc(date_from) and nvl(trunc(date_to), trunc(sysdate))
and organization_id = p_operating_unit;

Line: 80

select 'Y' from hr_all_organization_units
where  business_group_id =  l_business_group_id
and name = l_organization_name ;

Line: 103

     if ( is_valid_name %found ) THEN  -- Organization exists, update needed
       select organization_id into l_organization_id
       from hr_all_organization_units
       where  business_group_id =  l_business_group_id
       and name = l_organization_name ;

Line: 165

               hr_organization_api.update_org_information(
              p_effective_date       =>sysdate
             ,p_org_information_id   =>l_org_information_id
             ,p_org_info_type_code   =>l_org_info_type_code
             ,p_org_information1     =>l_operating_unit_id
             ,p_object_version_number=>l_object_version_number_inf
             );

Line: 201

      hr_organization_api.update_organization(
       p_effective_date          =>sysdate
      ,p_name			=>l_organization_name
      ,p_organization_id        =>l_organization_id
      ,p_internal_external_flag =>l_internal_external_flag
      ,p_date_from              =>l_date_from
      ,p_date_to                =>l_date_to
      ,p_object_version_number  =>l_object_version_number_org
      ,p_duplicate_org_warning  =>l_duplicate_org_warning
   );