/**************************************************************************
*PURPOSE: To list out Responsibilities assigned to a Request Group *
*PARAMETERS: Responsibility Name (or) Request Group Name *
*AUTHOR: Shailender Thallam *
**************************************************************************/
SELECT responsibility_name ,
request_group_name ,
frg.description
FROM fnd_request_groups frg,
fnd_responsibility_vl frv
WHERE frv.request_group_id = frg.request_group_id
--AND request_group_name LIKE 'US SHRMS Reports % Processes'
AND responsibility_name LIKE 'Benefits Administrator'
ORDER BY responsibility_name;