DBA Data[Home] [Help]

APPS.IRC_GRANTS_UTIL dependencies on FND_MENUS

Line 26: select menu_id from fnd_menus where menu_name=upper(p_permission_set);

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);
27:
28: cursor get_responsibility_id is
29: select responsibility_id, application_id
30: from fnd_responsibility where responsibility_key=upper(p_resp_key);