Security Profile- Custom Criteria help needed

Content

Hello,

we have to use the custom criteria ('person security profile') in order to restrict the user from seeing employees who have grade >= 70. The code I have is preventing from the user to see future hire dates. I tried to change its still not working. if someone can assist writing the code better in order to fix the issue with future hire dates?

very appreciate!

The code:

&TABLE_ALIAS.PERSON_ID IN(
 SELECT  DISTINCT ASG.PERSON_ID FROM FUSION.PER_ALL_ASSIGNMENTS_M ASG
   WHERE (ASG.ASSIGNMENT_TYPE = 'E' OR ASG.ASSIGNMENT_TYPE = 'C')
  AND TRUNC(SYSDATE) BETWEEN ASG.EFFECTIVE_START_DATE AND ASG.EFFECTIVE_END_DATE