PeopleSoft Wiki

SELECT A.EMPLID, A.CAL_RUN_ID, B.RSLT_SEG_NUM, B.PIN_NUM, B.ACM_TYPE, C.PIN_NM, 
C.DESCR, B.CALC_RSLT_VAL, B.CALC_VAL, A.RSLT_VER_NUM, A.RSLT_REV_NUM,C.PIN_NUM 
  FROM PS_GP_PYE_SEG_STAT A, PS_EMPLMT_SRCH_QRY A1, 
       PS_GP_RSLT_ACUM B, PS_EMPLMT_SRCH_QRY B1, PS_GP_PIN C 
  WHERE A.EMPLID = A1.EMPLID 
    AND A.EMPL_RCD = A1.EMPL_RCD 
    AND A1.OPRID = 'Kccc' 
    AND B.EMPLID = B1.EMPLID 
    AND B.EMPL_RCD = B1.EMPL_RCD 
    AND B1.OPRID = 'Kccc' 
    AND ( A.EMPLID = 'McccI' 
     AND A.EMPLID = B.EMPLID 
     AND A.CAL_RUN_ID = B.CAL_RUN_ID 
     AND A.EMPL_RCD = B.EMPL_RCD 
     AND A.CAL_ID = B.CAL_ID 
     AND A.ORIG_CAL_RUN_ID = B.ORIG_CAL_RUN_ID 
     AND A.RSLT_SEG_NUM = B.RSLT_SEG_NUM 
     AND B.PIN_NUM = C.PIN_NUM 
     AND C.PIN_NM = 'AUS GROSS' 
     AND A.RSLT_REV_NUM = (SELECT DISTINCT D.RSLT_REV_NUM 
  FROM PS_GP_PYE_SEG_STAT D, PS_EMPLMT_SRCH_QRY D1 
  WHERE D.EMPLID = D1.EMPLID 
    AND D.EMPL_RCD = D1.EMPL_RCD 
    AND D1.OPRID = 'KEccc'

AND ( A.RSLT_REV_NUM = SELECT MAX ( D.RSLT_REV_NUM) 
     AND A.EMPLID = D.EMPLID 
     AND A.EMPL_RCD = D.EMPL_RCD 
     AND A.GP_PAYGROUP = D.GP_PAYGROUP 
     AND A.CAL_ID = D.CAL_ID 
     AND A.ORIG_CAL_RUN_ID = D.ORIG_CAL_RUN_ID 
     AND A.RSLT_SEG_NUM = D.RSLT_SEG_NUM )) )