APPS.PQH_INST_TYPE_PKG SQL Statements

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

Line: 11

   select distinct 1
   from hr_organization_information org
   where org.organization_id = cp_org_id
   and not exists (select org1.org_information_context
   from hr_organization_information org1
   where org1.org_information_context = 'IPEDS_INSTITUTION_TYPE'
   and org1.organization_id = cp_org_id);

Line: 22

   select org.org_information1
   from hr_organization_information org
   where org.organization_id = cp_org_id
   and org.org_information_context = 'IPEDS_INSTITUTION_TYPE';