Oracle SQL Query to list all the responsibilities attached to a user in oracle apps

Please find below the Query to  list all the responsibilities attached to a user

SELECT FND_USER.USER_NAME,
       FND_USER.EMAIL_ADDRESS,
       FND_RESP_TL.RESPONSIBILITY_NAME, 
       FND_USER_RESP_GRP.START_DATE, 
       FND_USER_RESP_GRP.END_DATE       
FROM
        FND_USER FND_USER, 
        FND_USER_RESP_GROUPS_DIRECT FND_USER_RESP_GRP,
        FND_RESPONSIBILITY_TL FND_RESP_TL
WHERE FND_USER.USER_NAME = :USER_NAME
AND FND_USER_RESP_GRP.USER_ID = FND_USER.USER_ID
AND FND_USER_RESP_GRP.RESPONSIBILITY_ID = FND_RESP_TL.RESPONSIBILITY_ID
AND FND_RESP_TL.LANGUAGE = 'US'

SQL to get the User Name 
SELECT FND_USER.USER_NAME, FND_USER.* FROM FND_USER FND_USER
--WHERE USER_NAME = :user_name