APPS.PER_HK_DATA_PUMP dependencies on HR_ORGANIZATION_UNITS
Line 17: from hr_organization_information hoi, hr_organization_units hou
13:
14: begin
15: select hou.organization_id
16: into l_legal_employer_id 17: from hr_organization_information hoi, hr_organization_units hou 18: where hoi.organization_id = hou.organization_id
19: and hou.name = p_legal_employer_name
20: and hou.business_group_id = p_business_group_id
21: and hoi.org_information_context = 'HK_LEGAL_EMPLOYER';