Query SQL:
SELECT A.ACAD_ORG, A.SUBJECT, A.CATALOG_NBR, A.DESCR, A.CLASS_SECTION, A.CLASS_NBR, A.ENRL_TOT, TO_CHAR(A.START_DT,'YYYY-MM-DD'), TO_CHAR(A.END_DT,'YYYY-MM-DD'), C.INSTR_ROLE, C.EMPLID, C.LAST_NAME, C.FIRST_NAME, D.EMAIL_ADDR, TO_CHAR(SYSDATE,'YYYY-MM-DD'),A.CRSE_ID,A.CRSE_OFFER_NBR,A.STRM,A.SESSION_CODE
FROM PS_CLASS_TBL A, PS_GRADE_RSTR_TYPE B, PS_CLASS_INSTR_VW5 C, (SELECT TD.EMAIL_ADDR, TD.EMPLID, TD.PREF_EMAIL_FLAG
FROM PS_EMAIL_ADDRESSES TD,PS_PERALL_SEC_QRY D1 WHERE TD.EMPLID = D1.EMPLID AND D1.OPRID = '11002650' ) D
WHERE ( A.INSTITUTION = :1
AND A.STRM = :2
AND A.STRM = B.STRM
AND B.CLASS_NBR = A.CLASS_NBR
AND B.GRADING_STATUS <> 'POST'
AND ( A.ACAD_ORG = :3
OR :3 IS NULL)
AND A.CRSE_ID = C.CRSE_ID
AND A.CRSE_OFFER_NBR = C.CRSE_OFFER_NBR
AND A.STRM = C.STRM
AND A.SESSION_CODE = C.SESSION_CODE
AND A.CLASS_SECTION = C.CLASS_SECTION
AND C.EMPLID = D.EMPLID (+)
AND 'Y' = D.PREF_EMAIL_FLAG (+)
AND C.INSTR_ROLE = 'PI' )
ORDER BY 1, 2, 3, 5