Search found 3 matches
- Tue Jun 17, 2008 3:28 am
- Forum: HCM (Human Capital Management)
- Topic: [ Number of Supervisor for each employee ]
- Replies: 2
- Views: 716
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...
- Sun Jun 15, 2008 3:05 am
- Forum: HCM (Human Capital Management)
- Topic: [ Number of Supervisor for each employee ]
- Replies: 2
- Views: 716
- Sat Jun 14, 2008 7:11 am
- Forum: HCM (Human Capital Management)
- Topic: [ Number of Supervisor for each employee ]
- Replies: 2
- Views: 716
[ Number of Supervisor for each employee ]
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