APPS.HR_ORG_UTILITY SQL Statements

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

Line: 18

     select 1
     from hr_organization_information org2,
          hr_org_info_types_by_class oitbc
     where org2.organization_id = p_organization_id
     and org2.org_information_context||'' = 'CLASS'
     and org2.org_information2 = 'Y'
     and org2.org_information1 = nvl(p_restricted_class,org2.org_information1)
     and org2.org_information1 = oitbc.org_classification
     and oitbc.org_information_type = 'Organization Name Alias';

Line: 29

     select count(distinct org_information_context)
     into l_cnt
     from  hr_organization_information
     where organization_id = p_organization_id
     and   org_information_context in ('Organization Name Alias', 'CLASS');