APPS.HR_DELETE dependencies on HR_ALL_ORGANIZATION_UNITS

Line 2253: FROM hr_all_organization_units ou

2249: -- Delete statement modified to improve performance.
2250:
2251: DELETE FROM per_organization_list ol
2252: WHERE ol.organization_id IN ( SELECT ou.organization_id
2253: FROM hr_all_organization_units ou
2254: WHERE ou.business_group_id = p_business_group_id);
2255: --
2256: hr_utility.set_location('hr_delete.delete_security_list_for_bg',7);
2257: DELETE FROM per_security_profiles psp

Line 2264: FROM hr_all_organization_units ou

2260: --
2261: hr_utility.set_location('hr_delete.delete_security_list_for_bg',8);
2262: DELETE FROM per_security_organizations pso
2263: WHERE pso.organization_id IN ( SELECT ou.organization_id
2264: FROM hr_all_organization_units ou
2265: WHERE ou.business_group_id = p_business_group_id);
2266: --
2267: hr_utility.set_location('hr_delete.delete_security_list_for_bg',9);
2268: DELETE FROM per_security_users psu