You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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')

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!