Custom criteria based on Legal employer and Grade

Summary:

Hi Everyone,
We have a requirement to restrict employees based on legal employer and grade. For this, we created a custom criteria. However, after applying the custom criteria, the Pending Worker dashboard is not working. When we enable “View All”, the dashboard works as expected.
Below is the custom criteria used. Please advise if any changes are required.

EXISTS (
SELECT 1
FROM PER_ALL_ASSIGNMENTS_M A
WHERE A.PERSON_ID = &TABLE_ALIAS.PERSON_ID
AND A.PERSON_ID != HRC_SESSION_UTIL.GET_USER_PERSONID
AND A.PRIMARY_FLAG = 'Y'
AND A.ASSIGNMENT_TYPE IN ('E','C','N','P')
AND TRUNC(SYSDATE) BETWEEN A.EFFECTIVE_START_DATE