Count Employees By Year
Hi All,
Working in EBS Version 12.2.10
I have a requirement to count number of employees by year
below query for example
SELECT DISTINCT PAPF.EMPLOYEE_NUMBER, FULL_NAME, PAPF.START_DATE
,PPOS.DATE_START
FROM PER_ALL_PEOPLE_F PAPF
,PER_ALL_ASSIGNMENTS_F PAAF
,PER_PAY_BASES PPB
,PER_PERIODS_OF_SERVICE PPOS
WHERE PAPF.PERSON_ID = PAAF.PERSON_ID
AND PAAF.PAY_BASIS_ID = PPB.PAY_BASIS_ID
--AND PPB.NAME = :PER_P_BASIS
AND PAPF.PERSON_ID = PPOS.PERSON_ID
AND PPOS.ACTUAL_TERMINATION_DATE IS NULL
ORDER BY PAPF.EMPLOYEE_NUMBER
Please i need help to achieve