Custom Criteria for Person Security Profile not working as expected

Hello everyone,

We are implementing a new Job Role for our client whereby the employee who will have the role will be able to record absences on behalf on a specific population.

The population is as follows:

- Employees with a specific grade (NC)

- Employees belonging to a specific legal entity.

We created a job role (more details to be attached in screenshot) then we added a person security profile to restrict access.

&TABLE_ALIAS.PERSON_ID IN (SELECT papf.person_id, ppf.person_number,paam.legal_entity_id

FROM per_all_people_f papf, per_all_assignments_m paam, per_grades_f pgf, per_grades_f_tl pgft, per_legal_employers ple , per_people_f ppf