This content has been marked as final. Show 2 replies
Issue is resolved now by modifying the query as follows:
select 'person_id:'||papf.person_id from per_all_assignments_f paaf, per_all_people_f papf, per_jobs pej where
paaf.person_id = papf.person_id
and sysdate between paaf.effective_start_date and paaf.effective_end_date
and paaf.job_id = pej.job_id
and pej.name = 'IT.Group IT Operations Manager.Staff'