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'

Query to fetch last FINALIZED calendar for entitlement,take, balance in absence peoplesoft

SELECT V.EMPLID ,V.CAL_ID ,C.CAL_RUN_ID, C.RUN_FINALIZED_TS ,PIN_PARENT_NUM ,PIN_NUM ,PIN_NM ,ACM_FROM_DT ,ACM_THRU_DT,ROUND((CALC_RSLT_VAL+USER_ADJ_VAL) ,2)  

FROM PS_GP_RSLT_ACUM_VW V , PS_JOB J,PS_GP_CAL_RUN CWHERE 
(V.PIN_NM LIKE '%ENT_ENT' OR V.PIN_NM LIKE '%ENT_BAL' OR V.PIN_NM LIKE '%ENT_TKE')
 AND V.EMPLID=J.EMPLID AND J.HR_STATUS='A' AND J.EMPL_RCD=0
 AND   J.EFFDT = 

( SELECT MAX(EFFDT) FROM PS_JOB J1 WHERE J1.EMPLID=J.EMPLID AND J1.EMPL_RCD=0 AND J1.EFFDT<=TO_DATE(('31-DEC-2012'),'DD-MON-YYYY')

  )
AND  J.EFFSEQ=

( SELECT MAX(EFFSEQ) FROM PS_JOB J2 WHERE J2.EMPLID=J.EMPLID AND J2.EMPL_RCD=J2.EMPL_RCD AND J2.EFFDT=J.EFFDT

)
AND V.CAL_RUN_ID=C.CAL_RUN_ID AND C.RUN_FINALIZED_IND='Y'  AND  V.CAL_ID LIKE 'ABS%' AND V.ACM_FROM_DT>=TO_DATE(('01-JAN-2012'),'DD-MON-YYYY') AND  V.ACM_THRU_DT<=TO_DATE(('31-DEC-2012'),'DD-MON-YYYY')

AND V.CAL_ID=

(SELECT MAX(CAL_ID) CAL_ID  FROM SYSADM.PS_GP_CAL_RUN AA,PS_GP_RSLT_ACUM_VW BB          
WHERE AA.CAL_RUN_ID=BB.CAL_RUN_ID AND C.RUN_FINALIZED_IND=AA.RUN_FINALIZED_IND  AND CAL_ID LIKE 'ABS%' AND BB.ACM_FROM_DT>=V.ACM_FROM_DT AND  BB.ACM_THRU_DT<=V.ACM_THRU_DT
AND V.EMPLID=BB.EMPLID AND V.EMPL_RCD=BB.EMPL_RCD AND V.GP_PAYGROUP=BB.GP_PAYGROUP )

AND C.RUN_FINALIZED_TS=

(SELECT  MAX(RUN_FINALIZED_TS) RUN_FINALIZED_TS  FROM SYSADM.PS_GP_CAL_RUN AA,PS_GP_RSLT_ACUM_VW BB          
WHERE V.CAL_ID=BB.CAL_ID AND AA.CAL_RUN_ID=BB.CAL_RUN_ID  AND C.RUN_FINALIZED_IND=AA.RUN_FINALIZED_IND  AND CAL_ID LIKE 'ABS%' AND BB.ACM_FROM_DT>=V.ACM_FROM_DT AND  BB.ACM_THRU_DT<=V.ACM_THRU_DT
AND V.EMPLID=BB.EMPLID AND V.EMPL_RCD=BB.EMPL_RCD AND V.GP_PAYGROUP=BB.GP_PAYGROUP )

AND V.EMPLID='000149'

Usage of "warning" message function in application engine

warning("Hello");
output:

for example:

&varSample="Hello"; /* variable declaration */
warning(&varSample); /* passing the variable in warning function */

output:
Hello