DBA Data[Home] [Help]

APPS.UMX_FGA_UTILS_PKG dependencies on WF_ALL_ROLES_VL

Line 51: wf_all_roles_vl wfr

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 (+)
55: and grantee_key = adminRole

Line 99: --wf_all_roles_vl wfr

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
103: --and INSTANCE_PK1_VALUE = wfr.name (+)