Query To Find List of Users For Given Responsibility

   SELECT DISTINCT frt.responsibility_name "Responsibility Name",

                                fu.user_name "User Name"

           FROM apps.fnd_user fu,

                apps.fnd_user_resp_groups_direct fugd,

                apps.fnd_responsibility_tl frt

          WHERE fugd.responsibility_id = frt.responsibility_id

            AND fu.user_id = fugd.user_id

            AND NVL (fugd.end_date, SYSDATE + 1) > SYSDATE

            AND NVL (fu.end_date, SYSDATE + 1) > SYSDATE

            AND frt.LANGUAGE = 'US'

            AND frt.responsibility_name IN ('<Responsibility Name>')

       ORDER BY 1, 2;