APPS.HZ_PURGE_GEN dependencies on AMS_TCOP_CONTACT_SUMMARY

Line 2263: or exists (select 'Y' from AMS_TCOP_CONTACT_SUMMARY xx where xx.PARTY_ID = temp.party_id

2259:
2260: or exists (select 'Y' from AMS_ACT_RESOURCES xx where xx.RESOURCE_ID = temp.party_id
2261: )
2262:
2263: or exists (select 'Y' from AMS_TCOP_CONTACT_SUMMARY xx where xx.PARTY_ID = temp.party_id
2264: );
2265: else
2266: delete from hz_purge_gt temp where
2267:

Line 2314: or exists (select 'Y' from AMS_TCOP_CONTACT_SUMMARY xx where xx.PARTY_ID = temp.party_id

2310:
2311: or exists (select 'Y' from AMS_ACT_RESOURCES xx where xx.RESOURCE_ID = temp.party_id
2312: )
2313:
2314: or exists (select 'Y' from AMS_TCOP_CONTACT_SUMMARY xx where xx.PARTY_ID = temp.party_id
2315: );
2316: end if;
2317:
2318: