DBA Data[Home] [Help]

APPS.PER_SG_DATA_PUMP dependencies on HR_ORGANIZATION_INFORMATION

Line 19: from hr_organization_information hoi, hr_organization_units hou

15: begin
16:
17: select hou.organization_id
18: into l_legal_employer_id
19: from hr_organization_information hoi, hr_organization_units hou
20: where hoi.organization_id = hou.organization_id
21: and hou.business_group_id = p_business_group_id
22: and hoi.org_information_context = 'SG_LEGAL_ENTITY'
23: and hoi.org_information1 = p_legal_employer_name;