|
SELECT DISTINCT F.OPRID , C.EMPLID , A.INSTITUTION , A.STRM ,D.LANGUAGE_CD , D.DESCR FROM PS_CLASS_TBL A , PS_CLASS_MTG_PAT B , PS_CLASS_INSTR C , PS_CRSE_CATLG_LNG D , PS_CLASS_ASSOC E , PSOPRDEFN F , PS_GRADE_RSTR_TYPE G WHERE 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 A.CRSE_ID = D.CRSE_ID AND C.CRSE_ID = B.CRSE_ID AND C.CRSE_OFFER_NBR = B.CRSE_OFFER_NBR AND C.STRM = B.STRM AND C.SESSION_CODE = B.SESSION_CODE AND C.CLASS_SECTION = B.CLASS_SECTION AND C.CLASS_MTG_NBR = B.CLASS_MTG_NBR AND A.STRM = G.STRM AND A.CLASS_NBR = G.CLASS_NBR AND G.GRD_RSTR_TYPE_SEQ > 0 AND C.EMPLID = F.EMPLID AND D.EFFDT = ( SELECT MAX(D1.EFFDT) FROM PS_CRSE_CATLG_LNG D1 WHERE D1.CRSE_ID = D.CRSE_ID AND D1.EFFDT <= %CurrentDateIn) AND A.CRSE_ID = E.CRSE_ID AND A.CRSE_OFFER_NBR = E.CRSE_OFFER_NBR AND A.STRM = E.STRM AND A.SESSION_CODE = E.SESSION_CODE AND A.ASSOCIATED_CLASS = E.ASSOCIATED_CLASS AND A.SSR_COMPONENT = E.SSR_COMPONENT AND C.GRADE_RSTR_ACCESS IN ('A', 'G', 'P')
|
OPRID