<!-- subject: TRANcatalog_nbr: A812CFSELECT DISTINCT a.SUBJECT, a.CATALOG_NBR, a.ACAD_PLAN, a.OUCEF_CEF_CODE, a.MODULE_FROM_ENG, a.MODULE_FROM_CHI, a.QR_PROG_CHI, a.QR_PROG_ENG, a.QR_REG_NO, a.QR_LEVEL, a.QR_REG_EFFDT, a.QR_REG_EXP_DT, a.OUCEF_EFF_TERM, a.CEF_CODE_EFFDT, a.ENRTY_REQUIREMENT, a.COURSE_OUTLINE, a.STUDY_MODE, a.TITLE_ENG, a.TITLE_CHI, a.QR_PROG_ENG_CEF, a.QR_PROG_CHI_CEF, p.DESCR from PS_OU_CEF_CODE_V_S90PRD a JOIN PS_TERM_TBL@S90PRD p ON a.OUCEF_EFF_TERM = p.STRM where a.SUBJECT = 'TRAN' and a.CATALOG_NBR = 'A812CF' and TO_CHAR(SYSDATE, 'YYYYMMDD') <= a.CEF_CODE_EFFDT and a.CEF_CODE_EFFDT = (select MIN(v.CEF_CODE_EFFDT) from PS_OU_CEF_CODE_V_S90PRD v where v.SUBJECT = 'TRAN' and v.CATALOG_NBR = 'A812CF' and v.ACAD_PLAN = a.ACAD_PLAN and v.OUCEF_CEF_CODE = a.OUCEF_CEF_CODE and TO_CHAR(SYSDATE, 'YYYYMMDD') <= v.CEF_CODE_EFFDT) and OU_HIDDEN 'Y'ncode: TRAN A812CF --->