#=======================================================================
# Writer
: Lokanadham Thandlam
#=======================================================================
----------RESPONSIBILITY---->MENU
SELECT DISTINCT e.application_name,
a.responsibility_name,
a.LANGUAGE,
b.responsibility_key,
c.user_menu_name
FROM apps.fnd_responsibility_tl a,
apps.fnd_responsibility b,
apps.fnd_menus_tl c,
apps.fnd_menus d,
apps.fnd_application_tl e,
apps.fnd_application f
WHERE a.responsibility_id(+) = b.responsibility_id
AND b.menu_id = c.menu_id
AND b.menu_id = d.menu_id
AND a.responsibility_id = NVL (:resp_id, a.responsibility_id)
AND a.responsibility_name = NVL (:resp_name, a.responsibility_name)
AND e.application_id = f.application_id
AND f.application_id = b.application_id
AND a.LANGUAGE = 'US'
ORDER BY e.application_name, a.responsibility_name