Query to fetch absence events in peoplesoft

SELECT EMPLID,EMPL_RCD,BGN_DT Absence_begin,END_DT Absence_end,AB.pin_take_num,

(SELECT PIN_NM FROM PS_GP_PIN_DESCR_VW where pin_num=AB.pin_take_num) ABS_ELEMENT,

(SELECT DESCR FROM PS_GP_PIN_DESCR_VW where pin_num=AB.pin_take_num) Leave_Descr,

DURATION_ABS,(select XLATLONGNAME from psxlatitem Where fieldname='ABS_ENTRY_SRC' AND FIELDVALUE=AB.ABS_ENTRY_SRC) ENTRY_SOURCE,(select XLATLONGNAME from psxlatitem Where fieldname='WF_STATUS' AND FIELDVALUE=AB.WF_STATUS) WORKFLOW_STATUS

 ,CAL_RUN_ID,DECODE(CAL_RUN_ID,' ','NOT PROCESSED',decode((SELECT  RUN_FINALIZED_TS FROM PS_GP_CAL_RUN WHERE  CAL_RUN_ID=ab.CAL_RUN_ID),'','PROCESSED','FINALIZED')) STATUS, TRANSACTION_NBR

FROM PS_GP_ABS_EVENT AB 

 WHERE BGN_DT>=TO_DATE(('01-JAN-2012'),'DD-MON-YYYY') AND END_DT<=TO_DATE(('31-DEC-2012'),'DD-MON-YYYY') AND EMPLID='000008'