Query SQL:
SELECT B.ACAD_GROUP, B.ACAD_ORG, B.ACAD_CAREER, B.SUBJECT, B.CATALOG_NBR, A.COURSE_TITLE_LONG, A.UNITS_ACAD_PROG, A.DESCRLONG, C.DESCR254A,A.CRSE_ID,TO_CHAR(A.EFFDT,'YYYY-MM-DD'),C.RQRMNT_GROUP,TO_CHAR(C.EFFDT,'YYYY-MM-DD')
FROM PS_CRSE_CATALOG A, PS_CRSE_OFFER B, PS_RQ_GRP_TBL C
WHERE A.EFFDT =
(SELECT MAX(A_ED.EFFDT) FROM PS_CRSE_CATALOG A_ED
WHERE A.CRSE_ID = A_ED.CRSE_ID
AND A_ED.EFFDT <= SYSDATE)
AND A.CRSE_ID = B.CRSE_ID
AND A.EFFDT = B.EFFDT
AND B.INSTITUTION = :1
AND A.EFF_STATUS = 'A'
AND B.RQRMNT_GROUP = C.RQRMNT_GROUP (+)
AND ( B.ACAD_GROUP = :2
OR :2 IS NULL)
AND ( B.ACAD_ORG = :3
OR :3 IS NULL)
ORDER BY 1, 2, 3, 4, 5