APPS.HZ_PURGE_GEN dependencies on AMS_TCOP_CONTACT_SUMMARY
Line 2129: or exists (select 'Y' from AMS_TCOP_CONTACT_SUMMARY xx where xx.PARTY_ID = temp.party_id
2125:
2126: or exists (select 'Y' from AMS_ACT_RESOURCES xx where xx.RESOURCE_ID = temp.party_id
2127: )
2128: 2129: or exists (select 'Y' from AMS_TCOP_CONTACT_SUMMARY xx where xx.PARTY_ID = temp.party_id 2130: );
2131: else
2132: delete from hz_purge_gt temp where
2133:
Line 2180: or exists (select 'Y' from AMS_TCOP_CONTACT_SUMMARY xx where xx.PARTY_ID = temp.party_id
2176:
2177: or exists (select 'Y' from AMS_ACT_RESOURCES xx where xx.RESOURCE_ID = temp.party_id
2178: )
2179: 2180: or exists (select 'Y' from AMS_TCOP_CONTACT_SUMMARY xx where xx.PARTY_ID = temp.party_id 2181: );
2182: end if;
2183:
2184: