DBA Data[Home] [Help]

APPS.PER_RESPOWNER_UTIL_SS dependencies on FND_GRANTS

Line 58: FROM fnd_grants gnt, fnd_responsibility fr

54:
55: CURSOR owned_resps(p_object_id in number,
56: p_owner_name in varchar2) IS
57: SELECT GNT.INSTANCE_PK1_VALUE, GNT.INSTANCE_PK2_VALUE, GNT.INSTANCE_PK3_VALUE
58: FROM fnd_grants gnt, fnd_responsibility fr
59: WHERE GNT.object_id = p_object_id AND
60: (((GNT.grantee_type = 'USER' AND
61: GNT.grantee_key = ''||p_owner_name||'') OR (GNT.grantee_type = 'GROUP' AND
62: GNT.grantee_key in (select role_name from wf_user_roles wur where wur.user_name = fnd_global.user_name()