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
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