Query SQL:
SELECT A.SUBJECT, A.CATALOG_NBR, A.DESCR, A.CLASS_SECTION, A.SESSION_CODE, A.ENRL_TOT, A.EMPLID, B.ACAD_PROG, B.ADMIT_TERM, B.ADM_APPL_NBR, C.ADMIT_TYPE, C.ACAD_CAREER, C.STDNT_CAR_NBR, C.ADM_APPL_NBR, C.INSTITUTION, A.STDNT_ENRL_STATUS,A.ACAD_CAREER,A.INSTITUTION,A.STRM,A.CLASS_NBR
FROM PS_CLASS_TBL_SE_VW A, PS_ACAD_PROG B, (SELECT TC.ADMIT_TYPE, TC.ACAD_CAREER, TC.STDNT_CAR_NBR, TC.ADM_APPL_NBR, TC.INSTITUTION, TC.EMPLID
FROM PS_ADM_APPL_DATA TC,PS_ADM_APPL_SCTY C1 WHERE TC.EMPLID = C1.EMPLID AND TC.ACAD_CAREER = C1.ACAD_CAREER AND TC.ADM_APPL_NBR = C1.ADM_APPL_NBR AND C1.OPRCLASS = 'CUHCPPBAR01' AND C1.OPRID = '11002650' ) C
WHERE ( A.INSTITUTION = :1
AND A.STRM = :2
AND A.SUBJECT = :3
AND A.CATALOG_NBR = :4
AND A.CLASS_SECTION = :5
AND A.EMPLID = B.EMPLID
AND A.ACAD_CAREER = B.ACAD_CAREER
AND A.INSTITUTION = B.INSTITUTION
AND B.EFFDT =
(SELECT MAX(B_ED.EFFDT) FROM PS_ACAD_PROG B_ED
WHERE B.EMPLID = B_ED.EMPLID
AND B.ACAD_CAREER = B_ED.ACAD_CAREER
AND B.STDNT_CAR_NBR = B_ED.STDNT_CAR_NBR
AND B_ED.EFFDT <= SYSDATE)
AND B.EFFSEQ =
(SELECT MAX(B_ES.EFFSEQ) FROM PS_ACAD_PROG B_ES
WHERE B.EMPLID = B_ES.EMPLID
AND B.ACAD_CAREER = B_ES.ACAD_CAREER
AND B.STDNT_CAR_NBR = B_ES.STDNT_CAR_NBR
AND B.EFFDT = B_ES.EFFDT)
AND B.EMPLID = C.EMPLID (+)
AND B.ACAD_CAREER = C.ACAD_CAREER (+)
AND B.ADM_APPL_NBR = C.ADM_APPL_NBR (+)
AND B.INSTITUTION = C.INSTITUTION (+) )