List of Functions Excluded from a given responsibility. How to fetch Function name from the given Responsibility or How Many Function Attached to the Respective Responsibility. How to find the Function Name or User Function Name from the given Responsibility

• List of Functions Excluded from a given responsibility.

•  How to fetch Function name from the given Responsibility or How Many Function Attached to the Respective Responsibility.

• How to find the Function Name or User Function Name from the given Responsibility.

SELECT frv.responsibility_name,
       fffv.user_function_name
  FROM fnd_resp_functions frf,
       fnd_form_functions_vl fffv,
       fnd_responsibility_vl frv
 WHERE frf.rule_type = 'F'
   AND frf.action_id = fffv.function_id
   AND frf.responsibility_id = frv.responsibility_id
   AND frv.responsibility_name = '&resp_name';