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
  • No labels