SELECT A.INSTITUTION, A.STRM, A.SESSION_CODE, B.SUBJECT, B.CATALOG_NBR, B.CLASS_SECTION, B.SSR_COMPONENT, C.NAME, A.EMPLID, A.ACAD_CAREER, A.CLASS_NBR, B.DESCR, A.UNT_PRGRSS, A.CRSE_GRADE_OFF, A.CRSE_GRADE_INPUT,B.CRSE_ID,B.CRSE_OFFER_NBR,B.STRM,B.SESSION_CODE FROM PS_STDNT_ENRL A, PS_CLASS_TBL B, PS_PEOPLE_SRCH C WHERE C.EMPLID = A.EMPLID AND C.OPRCLASS = 'CUHCPPBAR01' AND ( A.INSTITUTION = B.INSTITUTION AND A.STRM = B.STRM AND A.CLASS_NBR = B.CLASS_NBR AND B.SESSION_CODE = A.SESSION_CODE AND A.INSTITUTION = :1 AND A.STRM = :2 AND B.ACAD_CAREER = :6 AND A.STDNT_ENRL_STATUS = 'E' ) ORDER BY 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12 |