FND W3H_Object_RolesResp

Description
Categories: Application, BI Publisher
Application: Application Object Library
Source:
Short Name: W3H_Object_RolesResp
DB package:
select * from (	 
select fg.grantee_key  AS RoleName, fg.name AS GrantName, fnd_message.get_STRING('FND','W3H_YES_ACCESSIBILITY')  AS  Accessibility,
(select user_name from fnd_user where user_id=fg.created_by) AS GrantCreatedBy,
fg.creation_date AS GrantCreationDate,
(select user_name from fnd_user where user_id=fg.last_updated_by) AS GrantUpdatedBy,
fg.last_update_date AS GrantUpdateDate
from fnd_objects fo,fnd_grants fg
where fo.object_id=fg.object_id
and fg.start_date <= sysdate 
and (sysdate <= fg.end_date or fg.end_date is null)
and fo.obj_name= :PARAM1
and fg.grantee_type='GROUP'
union all
select fg.grantee_key AS RoleName,fg.name "Grant Name", fnd_message.get_STRING('FND','W3H_NO_ACCESSIBILITY') AS  Accessibility,
(select user_name from fnd_user where user_id=fg.created_by) AS GrantCreatedBy,
fg.creation_date  AS GrantCreationDate,
(select user_name from fnd_user where user_id=fg.last_updated_by) AS GrantUpdatedBy,
fg.last_update_date AS GrantUpdateDate
from fnd_objects fo,fnd_grants fg
where fo.object_id=fg.object_id
and (sysdate < fg.start_date  or sysdate > fg.end_date)
and fo.obj_name= :PARAM1 and fg.grantee_type='GROUP'
) &PARAM2