SELECT U.USER_ID , S.RESPONSIBILITY_ID , S.ORGANIZATION_ID , S.ORG_LEVEL_SHORT_NAME FROM FND_USER_RESPONSIBILITY U , BIS_SECURED_ORGS1_V S , FND_RESPONSIBILITY R WHERE U.START_DATE <= SYSDATE AND (NVL(U.END_DATE , SYSDATE) >= SYSDATE) AND U.RESPONSIBILITY_ID = S.RESPONSIBILITY_ID AND U.RESPONSIBILITY_ID = R.RESPONSIBILITY_ID AND R.VERSION = 'W'