ERPstuff - Oracle EBS Community

I have tried to find a best solution but I've written a sample funcation and I wanted to share with you by : FUNCTION XX_GET_SUPERVISOR_LEVELS(P_PERSON_ID number) RETURN NUMBER IS c number := -1; super_id number ; p number := P_PERSON_ID; BEGIN while p is not null LOOP select paaf.SUPERVISOR_ID INTO...

plz zz zzzz ):

Is there funcation recive one parameter - persone id - and return number of supervisors for this one ?

Dear all [:)] , Plz , I want to ask about what is SQL statments for extract report from Application database : <span id='hl' style='background-color: yellow'><b>Number of Supervisor for each employee .</b></span id='hl'> Ex : A > B > C : A : 3 Supervisors D > E > F > G : D : 4 Supervisors