Like this?
SELECT DISTINCT
(select distinct decode(b.action,'HIR','No Reason Given',b.descr)
from ps_actn_reason_tbl b
where (b.action_reason = job1.action_reason and
b.action = job1.action and
job1.action_reason <> ' ') or
(b.action_reason = 'TMP' and
b.action = 'HIR' and
job1.action_reason = ' ')), "JOB1"."CHANGE_PCT",
"JOB"."ACTION", "JOB"."AL_PAY_FREQUENCY", "JOB"."ANNUAL_RT", "JOB"."CHANGE_AMT", "JOB"."CHANGE_PCT", "JOB"."EFFDT", "JOB"."EMPLID", "JOB"."FLSA_STATUS", "JOB"."JOBCODE", "JOB"."LOCATION", "JOB"."HOME_DEPARTMENT", "JOB"."GRADE", "JOB"."STEP", "JOB"."RPTC_ALT_SHF_DIF", "JOB"."PAYGROUP", "PS_RPTC_EMP_ECG_VW"."RPTC_ECG_GRADE", "PS_EMPLOYMENT"."FLAG_1", "JOB1"."EFFDT", "PS_PERSONAL_DATA"."BIRTHDATE", "PS_PERSONAL_DATA"."NAME", "PS_PERSONAL_DATA"."ORIG_HIRE_DT", "PS_ACTN_REASON_TBL"."ACTION_REASON", "PS_ACTN_REASON_TBL"."DESCR", "PS_ACTN_REASON_TBL"."EFFDT", "PS_JOBCODE_TBL"."JOBCODE", "PS_JOBCODE_TBL"."DESCR", "PS_JOBCODE_TBL"."EFFDT", "XLATTABLE"."FIELDNAME", "XLATTABLE"."FIELDVALUE", "XLATTABLE"."EFFDT", "XLATTABLE"."EFF_STATUS", "XLATTABLE"."XLATSHORTNAME", "XLATTABLE"."LANGUAGE_CD"
FROM
"PS_JOB" "JOB", "PS_RPTC_EMP_ECG_VW", "PS_EMPLOYMENT", "PS_JOB" "JOB1", "PS_PERSONAL_DATA", "PS_ACTN_REASON_TBL", "PS_JOBCODE_TBL", "XLATTABLE"
WHERE
((("JOB"."EFFDT" = (SELECT MAX(JOB.EFFDT) FROM PS_JOB
WHERE JOB.EMPLID = JOB.EMPLID)) AND
("JOB"."COMPANY" = 'WAH') AND
("JOB"."EMPL_TYPE" = 'S') AND
("JOB"."EMPL_STATUS" = 'A') AND
("JOB"."EMPL_RCD_NBR" = 0) AND
("JOB"."EMPLID" = '0002356') AND
(("JOB1"."EFFDT" = "JOB"."EFFDT") OR
("JOB1"."EFFDT" = (SELECT MAX(A.EFFDT) FROM PS_JOB A WHERE A.EMPLID = JOB.EMPLID
AND A.EFFDT < JOB.EFFDT))) AND
("JOB"."REG_TEMP" = 'R') AND
(("XLATTABLE"."EFFDT" = (
SELECT MAX("INNERALIAS"."EFFDT")
FROM "XLATTABLE" INNERALIAS
WHERE "INNERALIAS"."FIELDNAME" = "XLATTABLE"."FIELDNAME"
AND "INNERALIAS"."FIELDVALUE" = "XLATTABLE"."FIELDVALUE"
AND "INNERALIAS"."EFF_STATUS" = "XLATTABLE"."EFF_STATUS"
AND "INNERALIAS"."LANGUAGE_CD" = "XLATTABLE"."LANGUAGE_CD"
AND "INNERALIAS"."EFFDT" <= SYSDATE))) AND
("XLATTABLE"."FIELDNAME" = 'AL_PAY_FREQUENCY') AND
("XLATTABLE"."EFF_STATUS" = 'A') AND
("XLATTABLE"."LANGUAGE_CD" = 'ENG') AND
(("PS_RPTC_EMP_ECG_VW"."EFFSEQ"= (
SELECT MAX("INNERALIAS"."EFFSEQ")
FROM "PS_RPTC_EMP_ECG_VW" INNERALIAS
WHERE "INNERALIAS"."EFFSEQ" = "PS_RPTC_EMP_ECG_VW"."EFFSEQ"
AND "INNERALIAS"."EMPL_RCD_NBR" = "PS_RPTC_EMP_ECG_VW"."EMPL_RCD_NBR"
AND "INNERALIAS"."EMPLID" = "PS_RPTC_EMP_ECG_VW"."EMPLID"
AND "INNERALIAS"."EFFDT" = "PS_RPTC_EMP_ECG_VW"."EFFDT")
AND
"PS_RPTC_EMP_ECG_VW"."EFFDT" = (
SELECT MAX("INNERALIAS"."EFFDT")
FROM "PS_RPTC_EMP_ECG_VW" INNERALIAS
WHERE "INNERALIAS"."EFFSEQ" = "PS_RPTC_EMP_ECG_VW"."EFFSEQ"
AND "INNERALIAS"."EMPL_RCD_NBR" = "PS_RPTC_EMP_ECG_VW"."EMPL_RCD_NBR"
AND "INNERALIAS"."EMPLID" = "PS_RPTC_EMP_ECG_VW"."EMPLID"
AND "INNERALIAS"."EFFDT" <= SYSDATE))) AND
(("PS_ACTN_REASON_TBL"."EFFDT" = (
SELECT MAX("INNERALIAS"."EFFDT")
FROM "PS_ACTN_REASON_TBL" INNERALIAS
WHERE "INNERALIAS"."ACTION_REASON" = "PS_ACTN_REASON_TBL"."ACTION_REASON"
AND "INNERALIAS"."DESCR" = "PS_ACTN_REASON_TBL"."DESCR"
AND "INNERALIAS"."EFFDT" <= SYSDATE))) AND
(("PS_JOBCODE_TBL"."EFFDT" = (
SELECT MAX("INNERALIAS"."EFFDT")
FROM "PS_JOBCODE_TBL" INNERALIAS
WHERE "INNERALIAS"."JOBCODE" = "PS_JOBCODE_TBL"."JOBCODE"
AND "INNERALIAS"."DESCR" = "PS_JOBCODE_TBL"."DESCR"
AND "INNERALIAS"."EFFDT" <= SYSDATE)))))
AND
("JOB"."EMPLID" = "PS_RPTC_EMP_ECG_VW"."EMPLID" ) AND ("JOB"."SAL_ADMIN_PLAN" = "PS_RPTC_EMP_ECG_VW"."SAL_ADMIN_PLAN" ) AND ("JOB"."GRADE" = "PS_RPTC_EMP_ECG_VW"."GRADE" ) AND ("JOB"."EMPL_RCD_NBR" = "PS_RPTC_EMP_ECG_VW"."EMPL_RCD_NBR" ) AND ("JOB"."EFFSEQ" = "PS_RPTC_EMP_ECG_VW"."EFFSEQ" ) AND ("JOB"."EFFDT" = "PS_RPTC_EMP_ECG_VW"."EFFDT" ) AND ("JOB"."EMPLID" = "PS_EMPLOYMENT"."EMPLID" ) AND ("JOB"."EMPLID" = "JOB1"."EMPLID" ) AND ("JOB1"."ACTION_REASON" = "PS_ACTN_REASON_TBL"."ACTION_REASON"(+) ) AND ("JOB"."EMPLID" = "PS_PERSONAL_DATA"."EMPLID" ) AND ("JOB"."JOBCODE" = "PS_JOBCODE_TBL"."JOBCODE" ) AND ("JOB"."AL_PAY_FREQUENCY" = "XLATTABLE"."FIELDVALUE" )
ORDER BY
"JOB"."PAYGROUP", "PS_PERSONAL_DATA"."NAME