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