Security Profile - Custom Criteria

Summary

SQL not working correctly

Content

I have the following script for some employees to only see certain people in reporting.... The issue I am having is if someone was in a prior role, left the company in that role and is now in a new role, they show.  For example. we have an employee who is now in HR.  She was an intern in a different BU, and left the company then rejoined.  When I add the script which is for HR folks to not see anyone in HR, she still shows.  Any idea what I need to do to the SQL to correct that?