SELECT AT.NAME NAME , AT.DESCRIPTION DESCRIPTION , AT.TERM_ID TERM_ID FROM AP_TERMS AT WHERE SYSDATE BETWEEN NVL(AT.START_DATE_ACTIVE, SYSDATE - 1) AND NVL(AT.END_DATE_ACTIVE, SYSDATE + 1)
View Text - HTML Formatted
SELECT AT.NAME NAME , AT.DESCRIPTION DESCRIPTION , AT.TERM_ID TERM_ID FROM AP_TERMS AT WHERE SYSDATE BETWEEN NVL(AT.START_DATE_ACTIVE , SYSDATE - 1) AND NVL(AT.END_DATE_ACTIVE , SYSDATE + 1)