SELECT ORGANIZATION_ID , BUSINESS_GROUP_ID , NAME FROM PA_ORGANIZATIONS_PROJECT_V WHERE TRUNC(SYSDATE) BETWEEN DATE_FROM AND NVL(DATE_TO,TRUNC(SYSDATE)) AND ACTIVE_FLAG = 'Y'
View Text - HTML Formatted
SELECT ORGANIZATION_ID , BUSINESS_GROUP_ID , NAME FROM PA_ORGANIZATIONS_PROJECT_V WHERE TRUNC(SYSDATE) BETWEEN DATE_FROM AND NVL(DATE_TO , TRUNC(SYSDATE)) AND ACTIVE_FLAG = 'Y'