SELECT TL.RESPONSIBILITY_NAME , TL.RESPONSIBILITY_ID FROM FND_RESPONSIBILITY RESP , FND_RESPONSIBILITY_TL TL , FND_APPLICATION APPL WHERE APPL.APPLICATION_SHORT_NAME = 'MSC' AND APPL.APPLICATION_ID = RESP.APPLICATION_ID AND RESP.RESPONSIBILITY_ID = TL.RESPONSIBILITY_ID AND SYSDATE BETWEEN RESP.START_DATE AND NVL(RESP.END_DATE , SYSDATE) AND TL.LANGUAGE = USERENV('LANG')