APPS.PER_AU_DATA_PUMP SQL Statements

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

Line: 16

  select hou.organization_id
  into l_legal_employer_id
  from hr_organization_information hoi, hr_organization_units hou
  where hoi.organization_id = hou.organization_id
  and hou.business_group_id = p_business_group_id
  and hoi.org_information_context = 'AU_LEGAL_EMPLOYER'
  and hoi.org_information3 = p_legal_employer_name;