Query for Resposibilities assigned to a User

select a.RESPONSIBILITY_NAME,b.START_DATE,b.END_DATE from FND_USER_RESP_GROUPS b,FND_RESPONSIBILITY_TL a
where b.USER_ID=(select USER_ID from fnd_user where USER_NAME='&1')
and a.RESPONSIBILITY_ID=b.RESPONSIBILITY_ID