SELECT C.LAST_NAME, C.FIRST_NAME, C.MIDDLE_NAME, A.EMPLID, D.ACAD_CAREER, C.PHONE, C.EMAIL_ADDR, D.SUBJECT, D.CATALOG_NBR, D.SESSION_CODE, D.CLASS_SECTION, D.DESCR, D.UNT_TAKEN, E.INSTITUTION, E.SUBJECT, E.CATALOG_NBR, E.SESSION_CODE, E.CLASS_SECTION, E.DESCR, E.UNT_TAKEN,D.EMPLID,D.INSTITUTION,D.STRM,D.CLASS_NBR,E.EMPLID,E.ACAD_CAREER,E.STRM,E.CLASS_NBR FROM PS_STDNT_GRPS_HIST A, PS_TERM_TBL B, PS_CU_BIO_VW C, PS_CLASS_TBL_SE_VW D, PS_CLASS_TBL_SE_VW E WHERE A.EFFDT = (SELECT MAX(A_ED.EFFDT) FROM PS_STDNT_GRPS_HIST A_ED WHERE A.EMPLID = A_ED.EMPLID AND A.INSTITUTION = A_ED.INSTITUTION AND A.STDNT_GROUP = A_ED.STDNT_GROUP AND A_ED.EFFDT <= B.TERM_BEGIN_DT) AND A.INSTITUTION = B.INSTITUTION AND A.INSTITUTION = :1 AND A.STDNT_GROUP = :2 AND B.STRM = :3 AND A.EFF_STATUS = 'A' AND A.EMPLID = C.EMPLID AND A.EMPLID = D.EMPLID AND A.INSTITUTION = D.INSTITUTION AND D.ACAD_CAREER = B.ACAD_CAREER AND D.STRM = B.STRM AND D.STDNT_ENRL_STATUS = 'E' AND D.EMPLID = E.EMPLID AND D.INSTITUTION <> E.INSTITUTION AND D.STRM = E.STRM AND E.STDNT_ENRL_STATUS = 'E' ORDER BY 1, 2, 3 |