Function Assigned to Responsibilities Query

SELECT fff.function_name, frv.responsibility_name, frv.description

  FROM fnd_responsibility_vl frv, fnd_form_functions fff

 WHERE     1 = 1

       AND fff.function_name = 'PA_AF_CREATE_AGREEMENT'

       AND frv.menu_id NOT IN (SELECT frf.action_id

                                 FROM fnd_resp_functions frf

                                WHERE     frf.action_id = frv.menu_id

                                      AND frf.rule_type = 'M')

       AND frv.menu_id IN (    SELECT me.menu_id

                                 FROM fnd_menu_entries me

                           START WITH me.function_id = fff.function_id

                           CONNECT BY PRIOR me.menu_id = me.sub_menu_id)

       AND fff.function_id NOT IN (SELECT frf.action_id

                                     FROM fnd_resp_functions frf

                                    WHERE     frf.action_id = fff.function_id

                                          AND frf.rule_type = 'F')

       AND frv.responsibility_name LIKE 'XXXX US%';