Technology Stack - EBS (MOSC)

MOSC Banner

Count Employees By Year

edited Jan 24, 2022 2:33PM in Technology Stack - EBS (MOSC) 2 commentsAnswered

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

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