Person Security Profile with Custom Security Criteria - how to provide access to future dated record — Cloud Customer Connect
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

Person Security Profile with Custom Security Criteria - how to provide access to future dated record

edited Dec 15, 2017 12:04PM in Human Capital Management 3 comments

Summary

Person Security Profile with Custom Security Criteria - how to provide access to future dated records?

Content

Dear experts,

There is a SQL predicate below that is works fine for the current date but we need to pick future dated records?

I am not very familiar how can we modify the statement?

SELECT 1 
FROM per_all_assignments_m asg , per_periods_of_service ps 
WHERE asg.person_id = &table_alias.person_id 
AND asg.assignment_type IN ('E','C','P') 
AND asg.effective_latest_change = 'Y' 
AND SYSDATE BETWEEN LEAST(SYSDATE,asg.effective_start_date) AND asg.effective_end_date 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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