APPS.ENG_CHANGE_ROLES_PUB dependencies on FND_OBJECTS

Line 140: fnd_objects OBJECTS,

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
144: AND GRANTS.instance_type='INSTANCE'

Line 707: 'fnd_objects obj, ' ||

703: 'fnd_menus_tl granted_menu, ' ||
704: 'fnd_menus profile_menu_data, ' ||
705: 'fnd_menus granted_menu_data, ' ||
706: 'ego_obj_role_mappings mapping, ' ||
707: 'fnd_objects obj, ' ||
708: 'FND_PROFILE_OPTIONS profile, ' ||
709: 'FND_PROFILE_OPTION_VALUES profile_value, ' ||
710: 'EGO_INTERNAL_COMPANY_V internal_company ' ||
711: 'WHERE profile.profile_option_id = profile_value.profile_option_id ' ||

Line 750: 'fnd_objects obj, ' ||

746: 'FROM hz_parties grantee_global, ' ||
747: 'fnd_menus_tl granted_menu, ' ||
748: 'fnd_menus profile_menu_data, ' ||
749: 'fnd_menus granted_menu_data, ' ||
750: 'fnd_objects obj, ' ||
751: 'FND_PROFILE_OPTIONS profile, ' ||
752: 'FND_PROFILE_OPTION_VALUES profile_value, ' ||
753: 'EGO_INTERNAL_COMPANY_V internal_company ' ||
754: 'WHERE profile.profile_option_id = profile_value.profile_option_id ' ||

Line 804: 'fnd_objects obj,' ||

800: 'HZ_PARTIES hzc, ' ||
801: 'fnd_menus_tl granted_menu, ' ||
802: 'fnd_menus granted_menu_data, ' ||
803: 'ego_obj_role_mappings mapping, ' ||
804: 'fnd_objects obj,' ||
805: 'eng_engineering_changes changes,' ||
806: 'eng_change_subjects subjects,' ||
807: 'eng_revised_items rev_items ' ||
808: 'WHERE grants.grantee_type = ''USER'' ' ||

Line 870: 'fnd_objects obj , ' ||

866: 'HZ_PARTIES grantee_group, ' ||
867: 'fnd_menus_tl granted_menu, ' ||
868: 'fnd_menus granted_menu_data, ' ||
869: 'ego_obj_role_mappings mapping, ' ||
870: 'fnd_objects obj , ' ||
871: 'eng_engineering_changes changes, ' ||
872: 'eng_change_subjects subjects, ' ||
873: 'eng_revised_ITEMS REV_ITEMS ' ||
874: 'WHERE grants.grantee_type = ''GROUP'' ' ||

Line 931: 'fnd_objects obj, ' ||

927: 'hz_parties grantee_company, ' ||
928: 'fnd_menus_tl granted_menu, ' ||
929: 'fnd_menus granted_menu_data, ' ||
930: 'ego_obj_role_mappings mapping, ' ||
931: 'fnd_objects obj, ' ||
932: 'eng_engineering_changes changes, ' ||
933: 'eng_change_subjects subjects, ' ||
934: 'eng_revised_items rev_items ' ||
935: 'WHERE grants.grantee_type = ''COMPANY'' ' ||

Line 995: 'fnd_objects obj, ' ||

991: 'hz_parties grantee_global, ' ||
992: 'fnd_menus_tl granted_menu, ' ||
993: 'fnd_menus granted_menu_data, ' ||
994: 'ego_obj_role_mappings mapping, ' ||
995: 'fnd_objects obj, ' ||
996: 'eng_engineering_changes changes, ' ||
997: 'eng_change_subjects subjects, ' ||
998: 'eng_revised_items rev_items ' ||
999: 'WHERE grants.grantee_type = ''GLOBAL'' ' ||

Line 1122: fnd_objects obj

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
1125: AND grants.instance_type='SET'
1126: AND grants.parameter1 is null

Line 1140: FROM fnd_objects

1136: PK2_COLUMN_NAME,
1137: PK3_COLUMN_NAME,
1138: PK4_COLUMN_NAME,
1139: PK5_COLUMN_NAME
1140: FROM fnd_objects
1141: WHERE OBJ_NAME = p_obj_name;
1142:
1143: obj_meta_data_rec obj_meta_data%ROWTYPE;
1144: i NUMBER := 1;