User_name and the responsibilities to which he assigned

Tables used
1)FND_USER--holds the information of a user.
2)FND_RESPONSIBILITY--holds the information of a responsibility
3)FND_USER_RESP_GROUPS_ALL--holds the information regarding   
                            resposibility assignments to the users.

SELECT FU.USER_ID,
       FU.USER_NAME,
       FR.RESPONSIBILITY_KEY 
  FROM FND_USER FU, 
       FND_RESPONSIBILITY FR,
       FND_USER_RESP_GROUPS_ALL FUR 
WHERE  FR.RESPONSIBILITY_ID=FUR.RESPONSIBILITY_ID 
  AND  FU.USER_ID=FUR.USER_ID
  AND  FU.USER_NAME=UPPER('Enter USER_NAME');