Procurement - EBS (MOSC)

MOSC Banner

Need to build a Approver list for supervisor Job holding minimum Director level using AME

edited Jul 25, 2019 5:05AM in Procurement - EBS (MOSC) 1 commentAnswered

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))

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center