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 2269: WHERE psu.security_profile_id IN (SELECT sp.security_profile_id
2270: FROM per_security_profiles sp
2271: WHERE sp.business_group_id = p_business_group_id);
2272: --