SELECT DISTINCT A.EMPLID
  FROM PS_ADM_APPL_PROG A
  WHERE ( A.EFFDT =
        (SELECT MAX(A_ED.EFFDT) FROM PS_ADM_APPL_PROG A_ED
        WHERE A.EMPLID = A_ED.EMPLID
          AND A.ACAD_CAREER = A_ED.ACAD_CAREER
          AND A.STDNT_CAR_NBR = A_ED.STDNT_CAR_NBR
          AND A.ADM_APPL_NBR = A_ED.ADM_APPL_NBR
          AND A.APPL_PROG_NBR = A_ED.APPL_PROG_NBR
          AND A_ED.EFFDT <= SYSDATE)
    AND A.EFFSEQ =
        (SELECT MAX(A_ES.EFFSEQ) FROM PS_ADM_APPL_PROG A_ES
        WHERE A.EMPLID = A_ES.EMPLID
          AND A.ACAD_CAREER = A_ES.ACAD_CAREER
          AND A.STDNT_CAR_NBR = A_ES.STDNT_CAR_NBR
          AND A.ADM_APPL_NBR = A_ES.ADM_APPL_NBR
          AND A.APPL_PROG_NBR = A_ES.APPL_PROG_NBR
          AND A.EFFDT = A_ES.EFFDT)
     AND A.ADMIT_TERM = ?
     AND A.ACAD_CAREER = 'U'
     AND A.PROG_ACTION IN ('MATR','DEIN', 'PLNC', 'PRGC')
     AND NOT EXISTS (SELECT 'X'
  FROM PS_UU_ORT_REGISTER B
  WHERE B.EFFDT =
        (SELECT MAX(B_ED.EFFDT) FROM PS_UU_ORT_REGISTER B_ED
        WHERE B.EMPLID = B_ED.EMPLID
          AND B.CAMPUS_EVENT_NBR = B_ED.CAMPUS_EVENT_NBR
          AND B.EVENT_MTG_NBR = B_ED.EVENT_MTG_NBR
          AND B_ED.EFFDT <= SYSDATE)
    AND B.EFFSEQ =
        (SELECT MAX(B_ES.EFFSEQ) FROM PS_UU_ORT_REGISTER B_ES
        WHERE B.EMPLID = B_ES.EMPLID
          AND B.CAMPUS_EVENT_NBR = B_ES.CAMPUS_EVENT_NBR
          AND B.EVENT_MTG_NBR = B_ES.EVENT_MTG_NBR
          AND B.EFFDT = B_ES.EFFDT)
     AND B.EMPLID = A.EMPLID)
     AND NOT EXISTS (SELECT 'X'
  FROM PS_ADM_APPL_PROG C
  WHERE C.EFFDT =
        (SELECT MAX(C_ED.EFFDT) FROM PS_ADM_APPL_PROG C_ED
        WHERE C.EMPLID = C_ED.EMPLID
          AND C.ACAD_CAREER = C_ED.ACAD_CAREER
          AND C.STDNT_CAR_NBR = C_ED.STDNT_CAR_NBR
          AND C.ADM_APPL_NBR = C_ED.ADM_APPL_NBR
          AND C.APPL_PROG_NBR = C_ED.APPL_PROG_NBR
          AND C_ED.EFFDT <= SYSDATE)
    AND C.EFFSEQ =
        (SELECT MAX(C_ES.EFFSEQ) FROM PS_ADM_APPL_PROG C_ES
        WHERE C.EMPLID = C_ES.EMPLID
          AND C.ACAD_CAREER = C_ES.ACAD_CAREER
          AND C.STDNT_CAR_NBR = C_ES.STDNT_CAR_NBR
          AND C.ADM_APPL_NBR = C_ES.ADM_APPL_NBR
          AND C.APPL_PROG_NBR = C_ES.APPL_PROG_NBR
          AND C.EFFDT = C_ES.EFFDT)
     AND C.EMPLID = A.EMPLID
     AND C.ADMIT_TERM <> A.ADMIT_TERM)
     AND NOT EXISTS (SELECT 'X'
  FROM PS_SRVC_IND_DATA D
  WHERE D.EMPLID = A.EMPLID
     AND D.SRVC_IND_CD = 'HRI'
     AND D.SRVC_IND_REASON = 'EMPL'))
  AND ROWNUM < 100