Script to get responsibilities for a user

This script will display all the responsibilities for a given Username.

SELECT fu.user_name, frt.responsibility_name, furgd.start_date,

       furgd.end_date

  FROM fnd_user fu,

       fnd_user_resp_groups_direct furgd,

       fnd_responsibility_tl frt

WHERE fu.user_id = furgd.user_id

   AND furgd.responsibility_id = frt.responsibility_id

   AND UPPER (fu.user_name) = UPPER ('ERPSCHOOLS')