APPS.PER_SG_DATA_PUMP SQL Statements

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

Line: 17

  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 = 'SG_LEGAL_ENTITY'
  and hoi.org_information1 = p_legal_employer_name;