APPS.PER_HK_DATA_PUMP SQL Statements

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

Line: 15

  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.name = p_legal_employer_name
  and hou.business_group_id = p_business_group_id
  and hoi.org_information_context = 'HK_LEGAL_EMPLOYER';