DBA Data[Home] [Help]

APPS.PER_RESPOWNER_UTIL_SS dependencies on WF_USER_ROLES

Line 62: GNT.grantee_key in (select role_name from wf_user_roles wur where wur.user_name = fnd_global.user_name()

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()
63: and wur.user_orig_system = 'PER' and
64: wur.user_orig_system_id = fnd_global.employee_id() and
65: (start_date is NULL or start_date <= SYSDATE) and
66: (expiration_date is NULL or expiration_date >= SYSDATE))))) AND