DBA Data[Home] [Help]

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';