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

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