Responsibility Attached to a USER

select b.RESPONSIBILITY_NAME,c.START_DATE,c.END_DATE
from
FND_USER_RESP_GROUPS_ALL a,
FND_RESPONSIBILITY_TL b,
fnd_user c
where
a.user_id=c.user_id and
a.responsibility_id=b.responsibility_id
and c.USER_NAME=:P_USER_NAME--PARAMETER SUPPLY USER NAME