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