SELECT DISTINCT A.STRM , A.CLASS_NBR , C.OPRID , D.LANGUAGE_CD , D.DESCR FROM PS_CLASS_TBL A , PS_CLASS_INSTR B , PSOPRDEFN C , PS_CRSE_CATLG_LNG D WHERE A.CRSE_ID = D.CRSE_ID AND D.EFFDT = ( SELECT MAX(D1.EFFDT) FROM PS_CRSE_CATALOG D1 WHERE D1.CRSE_ID = D.CRSE_ID AND D1.EFF_STATUS = 'A' AND D1.EFFDT <= %CurrentDateIn) 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.GRADE_RSTR_ACCESS IN ('A','G','P') AND B.EMPLID = C.EMPLID
|