Query SQL:
SELECT A.ACAD_GROUP, A.ACAD_ORG, A.ACAD_CAREER, A.SUBJECT, A.CATALOG_NBR, A.DESCR, A.SESSION_CODE, A.CLASS_SECTION, A.CLASS_NBR, A.SSR_COMPONENT, A.CLASS_STAT, A.ENRL_TOT, count ( B.EMPLID),A.CRSE_ID,A.CRSE_OFFER_NBR,A.STRM
FROM PS_CLASS_TBL A, PS_CLASS_TBL_SE_VW B
WHERE ( A.INSTITUTION = :1
AND A.STRM = :2
AND A.CRSE_ID = B.CRSE_ID
AND A.CRSE_OFFER_NBR = B.CRSE_OFFER_NBR
AND A.STRM = B.STRM
AND A.SESSION_CODE = B.SESSION_CODE
AND A.CLASS_SECTION = B.CLASS_SECTION
AND B.ACAD_CAREER = A.ACAD_CAREER
AND B.INSTITUTION = A.INSTITUTION
AND B.CLASS_NBR = A.CLASS_NBR
AND B.STDNT_ENRL_STATUS = 'E'
AND EXISTS (SELECT 'X'
FROM PS_ACAD_PROG C, PS_ADM_APPL_DATA D, PS_ADM_APPL_SCTY D1
WHERE D.EMPLID = D1.EMPLID
AND D.ACAD_CAREER = D1.ACAD_CAREER
AND D.ADM_APPL_NBR = D1.ADM_APPL_NBR
AND D1.OPRCLASS = 'CUHCPPBAR01'
AND D1.OPRID = '11002650'
AND ( C.EFFDT =
(SELECT MAX(C_ED.EFFDT) FROM PS_ACAD_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_ED.EFFDT <= SYSDATE)
AND C.EFFSEQ =
(SELECT MAX(C_ES.EFFSEQ) FROM PS_ACAD_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.EFFDT = C_ES.EFFDT)
AND C.EMPLID = B.EMPLID
AND C.ACAD_CAREER = B.ACAD_CAREER
AND C.INSTITUTION = B.INSTITUTION
AND C.ADMIT_TERM BETWEEN :3 AND :4
AND C.EMPLID = D.EMPLID
AND C.ACAD_CAREER = D.ACAD_CAREER
AND D.ADM_APPL_NBR = C.ADM_APPL_NBR
AND C.INSTITUTION = D.INSTITUTION
AND ( D.ADMIT_TYPE = :6
OR :6 IS NULL) ))
AND ( A.ACAD_CAREER = :5
OR :5 IS NULL) )
GROUP BY A.ACAD_GROUP, A.ACAD_ORG, A.ACAD_CAREER, A.SUBJECT, A.CATALOG_NBR, A.DESCR, A.SESSION_CODE, A.CLASS_SECTION, A.CLASS_NBR, A.SSR_COMPONENT, A.CLASS_STAT, A.ENRL_TOT,A.CRSE_ID,A.CRSE_OFFER_NBR,A.STRM
ORDER BY 1, 2, 3, 4, 5