Query to find Functions, Menus for the responsibility

A) To find the Responsibility that has the function name like below:

Query:

 

SELECT DISTINCT responsibility_name

  FROM apps.fnd_user u,

       apps.fnd_user_resp_groups_direct ur,

       apps.fnd_responsibility_tl r

WHERE     u.user_id = ur.user_id

       AND r.responsibility_id = ur.responsibility_id

       AND r.application_id = ur.responsibility_application_id

       AND NVL (u.end_Date, SYSDATE) >= SYSDATE

       AND NVL (ur.end_Date, SYSDATE) >= SYSDATE

       AND responsibility_name IN

              (SELECT fr.RESPONSIBILITY_NAME

                 FROM apps.fnd_responsibility_vl fr,

                      apps.fnd_menus fm,

                      apps.fnd_compiled_menu_functions fmf,

                      apps.fnd_form_functions_vl ff

                WHERE     fr.menu_id = fm.menu_id

                      AND ff.function_id = fmf.function_id

                      AND fmf.menu_id = fm.menu_id

                      AND ff.user_function_name = 'Concurrent Managers'

                      AND NVL (fr.end_date, TRUNC (SYSDATE)) >= TRUNC (SYSDATE))

B) To find the Functions associated to one responsibility:

select ff.user_function_name from apps.fnd_responsibility_vl fr,

apps.fnd_menus fm,

apps.fnd_compiled_menu_functions fmf,

apps.fnd_form_functions_vl ff

where fr.menu_id = fm.menu_id

AND ff.function_id = fmf.function_id

AND fmf.menu_id = fm.menu_id

AND fr.responsibility_name='HCC CRM Administrator'

AND NVL (fr.end_date, TRUNC (SYSDATE)) >= TRUNC (SYSDATE);