How does a role know which Areas of Responsibility to use
We've been using Areas or Responsibility since implementation of our Fusion platform using Custom Person Security Profiles with the following statement
EXISTS(
SELECT 1
FROM PER_ALL_ASSIGNMENTS_M ASG
,PER_PERIODS_OF_SERVICE PS
, PER_ASG_RESPONSIBILITIES RES
,PER_DEPARTMENTS DEPT
WHERE PS.PERIOD_OF_SERVICE_ID=ASG.PERIOD_OF_SERVICE_ID
AND ASG.PERSON_ID=&TABLE_ALIAS.PERSON_ID
AND SYSDATE < ASG.EFFECTIVE_END_DATE
AND DEPT.ORGANIZATION_ID = ASG.ORGANIZATION_ID
AND DEPT.NAME not like '19050%'
AND ASG.ASSIGNMENT_TYPE IN('E','C','N','P')
AND ASG.EFFECTIVE_LATEST_CHANGE='Y'
AND (
ASG.ASSIGNMENT_STATUS_TYPE IN ('ACTIVE','SUSPENDED')
2