DBA Data[Home] [Help]

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;