SELECT RESPONSIBILITY_ID, RESPONSIBILITY_NAME FROM FND_RESPONSIBILITY_VL WHERE APPLICATION_ID = 271 AND SYSDATE BETWEEN START_DATE AND NVL(END_DATE, SYSDATE)
View Text - HTML Formatted
SELECT RESPONSIBILITY_ID , RESPONSIBILITY_NAME FROM FND_RESPONSIBILITY_VL WHERE APPLICATION_ID = 271 AND SYSDATE BETWEEN START_DATE AND NVL(END_DATE , SYSDATE)