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