Skip to Content
0
Former Member
Mar 31, 2008 at 11:02 AM

prob in HR 0PA_C01

10 Views

Hi,

I have to create one query for HR based on 0PA_C01 in which i have to give the seniority list of employees , like we are having employee groups E1 E2 E3 E4....

In each group dere are some no of employyees den i have to check the Last date of promotion which one is highest is more senior but if two employees have same date of promotion under the same employee group den it has to check previous date of promotion and so on.... if all the date of promotions are same den it will check the date of joining which one is older wud b more senior . Anyone has any idea about this query how to proceed...

HELP WUD B APPRECIATED