SELECT PROJECT_STATUS_CODE , PROJECT_STATUS_NAME FROM PA_PROJECT_STATUSES WHERE TRUNC(SYSDATE) BETWEEN START_DATE_ACTIVE AND NVL(END_DATE_ACTIVE,TRUNC(SYSDATE)) AND STATUS_TYPE = 'PROJECT'
View Text - HTML Formatted
SELECT PROJECT_STATUS_CODE , PROJECT_STATUS_NAME FROM PA_PROJECT_STATUSES WHERE TRUNC(SYSDATE) BETWEEN START_DATE_ACTIVE AND NVL(END_DATE_ACTIVE , TRUNC(SYSDATE)) AND STATUS_TYPE = 'PROJECT'