VIEW: APPS.FA_EMPLOYEES

Source

View Text - Preformatted

SELECT P.Person_Id Employee_ID, P.Employee_Number, P.Full_Name Name, S.Actual_Termination_Date FROM PER_PERIODS_OF_SERVICE S,PER_PEOPLE_X P where P.Person_ID = S.Person_ID and s.Period_Of_Service_id = (SELECT MAX(b2.Period_Of_Service_id) FROM PER_PERIODS_OF_SERVICE B2 WHERE B2.Person_ID = P.Person_ID )

View Text - HTML Formatted

SELECT P.PERSON_ID EMPLOYEE_ID
, P.EMPLOYEE_NUMBER
, P.FULL_NAME NAME
, S.ACTUAL_TERMINATION_DATE
FROM PER_PERIODS_OF_SERVICE S
, PER_PEOPLE_X P
WHERE P.PERSON_ID = S.PERSON_ID
AND S.PERIOD_OF_SERVICE_ID = (SELECT MAX(B2.PERIOD_OF_SERVICE_ID)
FROM PER_PERIODS_OF_SERVICE B2
WHERE B2.PERSON_ID = P.PERSON_ID )