query to extract Ex- Employee 's assignment details ( Job, Grade,location).

Hi Experts,

I am new in technical side, i want  to extract ex-employees grade on the basis of below query. Please advise what is missing in below query.

SELECT

A.EMPLOYEE_NUMBER                                           "EMP NO"

,A.FIRST_NAME||' '||A.LAST_NAME                                   NAME

,TO_CHAR(A.START_DATE, 'DD-MON-YYYY' )                          "JOINING DATE"

,TO_CHAR (B.NOTIFIED_TERMINATION_DATE, 'DD-MON-YYYY' )         "RESIGN DATE "

,TO_CHAR (B.ACTUAL_TERMINATION_DATE, 'DD-MON-YYYY'  )           "LAST WORKING DAY"

,TO_CHAR (B.LAST_STANDARD_PROCESS_DATE , 'DD-MON-YYYY')         LAST_PROCESS_DATE

,TO_CHAR(TO_DATE(B.ATTRIBUTE1, 'YYYY/MM/DD HH24:MI:SS'), 'DD-MON-YYYY')   RESIGN_DATE_2

,TO_CHAR(TO_DATE(B.ATTRIBUTE2, 'YYYY/MM/DD HH24:MI:SS'), 'DD-MON-YYYY')   REMARKS