How to access terminated employee records with a person security profile restricted with person type
Summary:
How to access terminated employee records with a person security profile restricted with person type
Unable to see terminated employees with the below person security profile
Content (please ensure you mask any confidential information):
Version (include the version you are using, if applicable):
25A
Code Snippet (add any code snippets that support your topic, if applicable):
Custom Criteria:
NOT EXISTS
(SELECT 1
FROM
PER_ALL_ASSIGNMENTS_M ASG,
PER_GRADES_F_VL PG
WHERE ASG.GRADE_ID = PG.GRADE_ID(+)
AND ASG.ASSIGNMENT_TYPE IN ('E','N','P')
AND ASG.EFFECTIVE_LATEST_CHANGE = 'Y'
AND TRUNC(SYSDATE) BETWEEN PG.EFFECTIVE_START_DATE(+) AND PG.EFFECTIVE_END_DATE(+)