DBA Data[Home] [Help]

APPS.PER_NZ_DATA_PUMP dependencies on HR_ORGANIZATION_UNITS

Line 21: from hr_organization_information hoi, hr_organization_units hou

17: begin
18:
19: select hoi.organization_id
20: into l_registered_employer_id
21: from hr_organization_information hoi, hr_organization_units hou
22: where hoi.organization_id = hou.organization_id
23: and hou.business_group_id = p_business_group_id
24: and hoi.org_information_context = 'NZ_IRD_EMPLOYER'
25: and hoi.org_information1 = p_employer_ird_number;