DBA Data[Home] [Help]

APPS.IRC_GRANTS_UTIL dependencies on FND_GRANTS

Line 22: and not exists (select /*+ NO_UNNEST */1 from fnd_grants where grantee_type='USER' and grantee_key=fu.user_name

18: where furg.responsibility_id = p_resp_id
19: and furg.user_id=fu.user_id
20: and fu.user_id > 1000
21: and trunc(sysdate) between nvl(fu.start_date,trunc(sysdate)) and nvl(fu.end_date,trunc(sysdate))
22: and not exists (select /*+ NO_UNNEST */1 from fnd_grants where grantee_type='USER' and grantee_key=fu.user_name
23: and ctx_resp_id=furg.responsibility_id and menu_id=p_menu_id);
24:
25: cursor get_menu_id is
26: select menu_id from fnd_menus where menu_name=upper(p_permission_set);