SELECT DISTINCT C.LAST_NAME, C.FIRST_NAME, C.MIDDLE_NAME, B.EMPLID, D.SUBJECT, D.CATALOG_NBR, D.DESCR, D.CLASS_SECTION, D.SESSION_CODE, D.CRSE_GRADE_OFF,D.EMPLID,D.ACAD_CAREER,D.INSTITUTION,D.STRM,D.CLASS_NBR FROM PS_TERM_TBL A, PS_STDNT_GRPS_HIST B, PS_CU_BIO_VW C, PS_CLASS_TBL_SE_VW D WHERE A.INSTITUTION = :1 AND A.ACAD_CAREER = :2 AND A.STRM = :3 AND B.INSTITUTION = A.INSTITUTION AND B.EFFDT = (SELECT MAX(B_ED.EFFDT) FROM PS_STDNT_GRPS_HIST B_ED WHERE B.EMPLID = B_ED.EMPLID AND B.INSTITUTION = B_ED.INSTITUTION AND B.STDNT_GROUP = B_ED.STDNT_GROUP AND B_ED.EFFDT <= A.TERM_BEGIN_DT) AND B.EFF_STATUS = 'A' AND B.STDNT_GROUP = :4 AND B.EMPLID = C.EMPLID AND B.EMPLID = D.EMPLID AND B.INSTITUTION = D.INSTITUTION AND D.STDNT_ENRL_STATUS = 'E' AND D.STRM = A.STRM AND ( D.SUBJECT = :5 OR :5 IS NULL) AND ( D.CATALOG_NBR = :6 OR :6 IS NULL) ORDER BY 1, 2, 3, 5, 6, 8 |