APPS.ENG_CHANGE_ROLES_PUB dependencies on FND_GRANTS

Line 139: FROM fnd_grants GRANTS,

135: menus.Menu_name role_name,
136: menus.user_menu_name role_display_name,
137: grants.grantee_key,
138: menus.menu_id menu_id
139: FROM fnd_grants GRANTS,
140: fnd_objects OBJECTS,
141: fnd_menus_vl MENUS
142: WHERE OBJECTS.object_id = GRANTS.object_id
143: AND OBJECTS.obj_name=cp_entity_name

Line 797: 'FROM fnd_grants grants, ' ||

793: 'granted_menu.user_menu_name role_name, ' ||
794: 'grants.grantee_type grantee_type, ' ||
795: 'hzsi.party_name grantee_name, ' ||
796: 'granted_menu_data.menu_id menu_id ' ||
797: 'FROM fnd_grants grants, ' ||
798: 'HZ_PARTIES hzsi, ' ||
799: 'HZ_RELATIONSHIPS hzr, ' ||
800: 'HZ_PARTIES hzc, ' ||
801: 'fnd_menus_tl granted_menu, ' ||

Line 865: 'FROM fnd_grants grants, ' ||

861: 'granted_menu.user_menu_name role_name, ' ||
862: 'grants.grantee_type grantee_type, ' ||
863: 'grantee_group.party_name grantee_name, ' ||
864: 'granted_menu_data.menu_id menu_id ' ||
865: 'FROM fnd_grants grants, ' ||
866: 'HZ_PARTIES grantee_group, ' ||
867: 'fnd_menus_tl granted_menu, ' ||
868: 'fnd_menus granted_menu_data, ' ||
869: 'ego_obj_role_mappings mapping, ' ||

Line 926: 'FROM fnd_grants grants, ' ||

922: 'granted_menu.user_menu_name role_name, ' ||
923: 'grants.grantee_type grantee_type, ' ||
924: 'grantee_company.party_name grantee_name, ' ||
925: 'granted_menu_data.menu_id menu_id ' ||
926: 'FROM fnd_grants grants, ' ||
927: 'hz_parties grantee_company, ' ||
928: 'fnd_menus_tl granted_menu, ' ||
929: 'fnd_menus granted_menu_data, ' ||
930: 'ego_obj_role_mappings mapping, ' ||

Line 990: 'FROM fnd_grants grants, ' ||

986: 'granted_menu.user_menu_name role_name, ' ||
987: 'grants.grantee_type grantee_type, ' ||
988: 'grantee_global.party_name grantee_name, ' ||
989: 'granted_menu_data.menu_id menu_id ' ||
990: 'FROM fnd_grants grants, ' ||
991: 'hz_parties grantee_global, ' ||
992: 'fnd_menus_tl granted_menu, ' ||
993: 'fnd_menus granted_menu_data, ' ||
994: 'ego_obj_role_mappings mapping, ' ||

Line 1120: FROM fnd_grants grants,

1116: SELECT DISTINCT
1117: sets.instance_set_id instance_set_id ,
1118: sets.instance_set_name instance_set_name,
1119: sets.predicate predicate
1120: FROM fnd_grants grants,
1121: fnd_object_instance_sets sets,
1122: fnd_objects obj
1123: WHERE obj.obj_name = p_obj_name
1124: AND grants.object_id = obj.object_id