APPS.HZ_PURGE_GEN dependencies on WSH_CARRIER_SITES

Line 264: (select 'Y' from WSH_CARRIER_SITES

260: or exists (select 'Y' from HZ_PARTY_SITES
261: xx where xx.PARTY_ID = temp.party_id
262: and (nvl(STATUS, 'A') in ('A','I'))
263: and exists
264: (select 'Y' from WSH_CARRIER_SITES
265: yy where yy.CARRIER_SITE_ID=xx.PARTY_SITE_ID
266: ));
267: else
268: delete from hz_purge_gt temp where

Line 278: (select 'Y' from WSH_CARRIER_SITES

274: or exists (select 'Y' from HZ_PARTY_SITES
275: xx where xx.PARTY_ID = temp.party_id
276: and (nvl(STATUS, 'A') in ('A','I'))
277: and exists
278: (select 'Y' from WSH_CARRIER_SITES
279: yy where yy.CARRIER_SITE_ID=xx.PARTY_SITE_ID
280: ));
281: end if;
282: