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

Custom criteria (SQL) does not return the desired records.

in Human Capital Management 2 comments

Hi,

 We are using the below Custom Criteria (SQL) to fetch only the Contractors, restricting access for a custom role, but we are able see former employees, where those employees are now Contractors. Can you please advise.

EXISTS (SELECT 1 FROM PER_ALL_ASSIGNMENTS_M ASG,PER_PERIODS_OF_SERVICE PS

WHERE ASG.ASSIGNMENT_TYPE ='C'

AND ASG.SYSTEM_PERSON_TYPE='CWK'

AND ASG.EFFECTIVE_LATEST_CHANGE='Y'

AND TRUNC(SYSDATE) < ASG.EFFECTIVE_END_DATE 

AND PS.PERIOD_OF_SERVICE_ID=ASG.PERIOD_OF_SERVICE_ID 

AND (ASG.ASSIGNMENT_STATUS_TYPE IN ('ACTIVE','SUSPENDED') OR (ASG.ASSIGNMENT_STATUS_TYPE IN ('INACTIVE')))

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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