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;