APPS.HZ_PURGE_GEN dependencies on IEX_CASE_CONTACTS

Line 496: (select 'Y' from IEX_CASE_CONTACTS

492: or exists (select 'Y' from HZ_PARTY_SITES
493: xx where xx.PARTY_ID = temp.party_id
494: and (nvl(STATUS, 'A') in ('A','I'))
495: and exists
496: (select 'Y' from IEX_CASE_CONTACTS
497: yy where yy.ADDRESS_ID=xx.PARTY_SITE_ID
498: ));
499: else
500: delete from hz_purge_gt temp where

Line 510: (select 'Y' from IEX_CASE_CONTACTS

506: or exists (select 'Y' from HZ_PARTY_SITES
507: xx where xx.PARTY_ID = temp.party_id
508: and (nvl(STATUS, 'A') in ('A','I'))
509: and exists
510: (select 'Y' from IEX_CASE_CONTACTS
511: yy where yy.ADDRESS_ID=xx.PARTY_SITE_ID
512: ));
513: end if;
514: