APPS.ENG_CHANGE_ROLES_PUB dependencies on ENG_CHANGE_SUBJECTS

Line 183: SELECT pk1_value, pk2_value FROM eng_change_subjects where change_id = p_pk1_value;

179: AND grantee_orig_system in ('HZ_PARTY','HZ_GROUP') --,'HZ_COMPANY', 'HZ_GLOBAL')
180: AND parties.party_id=DECODE(grants.grantee_key,'GLOBAL',-1000, SUBSTR(grants.grantee_key, INSTR(grants.grantee_key,':',1,1)+1));
181:
182: CURSOR change_subjects_cur is
183: SELECT pk1_value, pk2_value FROM eng_change_subjects where change_id = p_pk1_value;
184:
185: CURSOR change_rev_items_cur is
186: SELECT revised_item_id, organization_id FROM eng_revised_items WHERE change_id = p_pk1_value; -- p_pk1_value = change_id
187:

Line 730: 'FROM eng_change_subjects_v ' ||

726: '( ' ||
727: 'SELECT ' ||
728: 'pk1_value, ' ||
729: 'pk2_value ' ||
730: 'FROM eng_change_subjects_v ' ||
731: 'WHERE ' ||
732: '( ' ||
733: ' OBJECT_NAME=''EGO_ITEM'' ' ||
734: ' OR OBJECT_NAME=''EGO_ITEM_REVISION'' ' ||

Line 806: 'eng_change_subjects subjects,' ||

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'' ' ||
809: 'AND grants.object_id = obj.object_id ' ||
810: 'AND mapping.parent_object_id = grants.object_id ' ||

Line 872: 'eng_change_subjects subjects, ' ||

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'' ' ||
875: 'AND grants.object_id = obj.object_id ' ||
876: 'AND mapping.parent_object_id = grants.object_id ' ||

Line 933: 'eng_change_subjects subjects, ' ||

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'' ' ||
936: 'AND grants.object_id = obj.object_id ' ||
937: 'AND grantee_company.party_type = ''ORGANIZATION'' ' ||

Line 997: 'eng_change_subjects subjects, ' ||

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'' ' ||
1000: 'AND grants.object_id = obj.object_id ' ||
1001: 'AND mapping.parent_object_id = grants.object_id ' ||