SELECT CLASS_CATEGORY , CLASS_CODE , DESCRIPTION FROM PA_CLASS_CODES WHERE TRUNC(SYSDATE) BETWEEN START_DATE_ACTIVE AND NVL(END_DATE_ACTIVE,TRUNC(SYSDATE))
View Text - HTML Formatted
SELECT CLASS_CATEGORY , CLASS_CODE , DESCRIPTION FROM PA_CLASS_CODES WHERE TRUNC(SYSDATE) BETWEEN START_DATE_ACTIVE AND NVL(END_DATE_ACTIVE , TRUNC(SYSDATE))