Script to check Responsibilities assigned to particular user or users assigned for particular responsibility or all users and their responsibilities

Script to check Responsibilities assigned to particular user

or users assigned for particular responsibility

or all users and their responsibilities in oracle

  SELECT fu.user_id,

         fu.user_name,

         fur.responsibility_id,

         fr.responsibility_name

    FROM APPS.fnd_user fu,

         apps.fnd_user_resp_groups fur,

         apps.fnd_responsibility_vl fr

   WHERE     fu.user_id = fur.user_id

         AND fr.application_id = fur.responsibility_application_id

         AND fr.responsibility_id = fur.responsibility_id

         AND TRUNC (SYSDATE) BETWEEN TRUNC (fr.start_date) AND TRUNC (NVL ( (fr.end_date - 1), SYSDATE))

         AND TRUNC (SYSDATE) BETWEEN TRUNC (fur.start_date)AND TRUNC (NVL ( (fur.end_date - 1), SYSDATE))

         AND user_name LIKE UPPER ( :p_user_name) --- for all user or for perticular user

        -- AND fur.responsibility_application_id = 275 -- to check users for perticular responsibility

ORDER BY user_name