APPS.UMX_FGA_UTILS_PKG dependencies on FND_OBJECTS

Line 17: object_id in (select object_id from fnd_objects where obj_name='UMX_ACCESS_ROLE');

13: LAST_UPDATE_DATE = sysdate,
14: LAST_UPDATED_BY = 1000002,
15: LAST_UPDATE_LOGIN = 1000002
16: where grantee_key = adminRole and
17: object_id in (select object_id from fnd_objects where obj_name='UMX_ACCESS_ROLE');
18: end;
19:
20: /*******************************************************************************************************************************/
21: /*******************************************************************************************************************************/

Line 26: fnd_objects fo

22:
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'

Line 49: fnd_objects fo,

45: procedure copy_grants_to_roleSets(adminRole varchar2, roleSetId number) is
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

Line 97: fnd_objects fo

93: begin
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