Query to find responsibilities for particular user

The following query shows responsibilities for particular user as output. Here in this query we need to pass user-name as parameter.


select fu.user_name, fr.responsibility_name, furg.START_DATE, furg.END_DATEfrom fnd_user_resp_groups_direct furg, fnd_user fu, fnd_responsibility_tl frwhere fu.user_name = '&USER_NAME' and furg.user_id = fu.user_idand furg.responsibility_id = fr.responsibility_id;