Query SQL:
SELECT A.INSTITUTION, A.SUBJECT, TO_CHAR(A.EFFDT,'YYYY-MM-DD'), A.EFF_STATUS, A.DESCR, A.DESCRSHORT, A.ACAD_ORG, A.SPLIT_OWNER, A.EXT_SUBJECT_AREA, A.CIP_CODE, A.HEGIS_CODE, A.DESCRFORMAL, A.USE_BLIND_GRADING, A.STUDY_FIELD, TO_CHAR(SYSDATE,'YYYY-MM-DD')
FROM PS_SUBJECT_TBL A
WHERE A.EFFDT =
(SELECT MAX(A_ED.EFFDT) FROM PS_SUBJECT_TBL A_ED
WHERE A.INSTITUTION = A_ED.INSTITUTION
AND A.SUBJECT = A_ED.SUBJECT
AND A_ED.EFFDT <= SYSDATE)
AND A.INSTITUTION = :1