APPS.HZ_PURGE_GEN dependencies on WSH_CARRIER_SITES

Line 247: (select 'Y' from WSH_CARRIER_SITES

243: or exists (select 'Y' from HZ_PARTY_SITES
244: xx where xx.PARTY_ID = temp.party_id
245: and (nvl(STATUS, 'A') in ('A','I'))
246: and exists
247: (select 'Y' from WSH_CARRIER_SITES
248: yy where yy.CARRIER_SITE_ID=xx.PARTY_SITE_ID
249: ));
250: else
251: delete from hz_purge_gt temp where

Line 261: (select 'Y' from WSH_CARRIER_SITES

257: or exists (select 'Y' from HZ_PARTY_SITES
258: xx where xx.PARTY_ID = temp.party_id
259: and (nvl(STATUS, 'A') in ('A','I'))
260: and exists
261: (select 'Y' from WSH_CARRIER_SITES
262: yy where yy.CARRIER_SITE_ID=xx.PARTY_SITE_ID
263: ));
264: end if;
265: