Need to build a Approver list for supervisor Job holding minimum Director level using AME
Hello Gurus,
I need to build a Approver List for Requisition for Supervisor who is minimum level Director.
I used the below one but I have hard coded the job id.
Is there any better approach to proceed please advise
SELECT 'person_id:'||person_id FROM(
select 1 level1,paa.supervisor_id person_id
from per_all_assignments_f paa, per_all_people_f pap
where
paa.supervisor_id=pap.person_id
and sysdate between pap.effective_start_date and pap.effective_end_date
and sysdate between paa.effective_start_date and paa.effective_end_date
and paa.supervisor_id in (select pas1.person_id from per_all_assignments_f pas1 where job_id in (68,78,72,1086))