DBA Data[Home] [Help]

APPS.UMX_FGA_UTILS_PKG dependencies on FND_MENUS

Line 27: --,fnd_menus fm

23: procedure convert_All_Grants_to_roleSets is
24: cursor adminRoles is select distinct grantee_key
25: from fnd_grants fg,
26: fnd_objects fo
27: --,fnd_menus fm
28: where --fg.menu_id = fm.menu_id and
29: fg.object_id = fo.object_id
30: --and fm.menu_name = 'UMX_OBJ_ADMIN_ROLE_PERMS'
31: and fo.obj_name = 'UMX_ACCESS_ROLE'

Line 50: fnd_menus fm,

46: begin
47: insert into UMX_LSA_ROLE_SET_ROLES (role_set_id, role_name) select roleSetId, INSTANCE_PK1_VALUE
48: from fnd_grants fg,
49: fnd_objects fo,
50: fnd_menus fm,
51: wf_all_roles_vl wfr
52: where fg.menu_id = fm.menu_id
53: and fg.object_id = fo.object_id
54: and INSTANCE_PK1_VALUE = wfr.name (+)

Line 98: --fnd_menus fm,

94: --For all roles
95: select count(*) into cnt
96: from fnd_grants fg,
97: fnd_objects fo
98: --fnd_menus fm,
99: --wf_all_roles_vl wfr
100: where
101: --fg.menu_id = fm.menu_id and
102: fg.object_id = fo.object_id