APPS.HZ_PURGE_GEN dependencies on HZ_CUST_ACCOUNTS

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

289:
290: exists (select 'Y' from HZ_ORGANIZATION_PROFILES xx where xx.DISPLAYED_DUNS_PARTY_ID = temp.party_id
291: and (nvl(STATUS, 'A') in ('A','I')))
292:
293: or exists (select 'Y' from HZ_CUST_ACCOUNTS xx where xx.PARTY_ID = temp.party_id
294: and (nvl(STATUS, 'A') in ('A','I')))
295:
296: or exists (select 'Y' from HZ_PARTY_SITES
297: xx where xx.PARTY_ID = temp.party_id

Line 304: or exists (select 'Y' from HZ_CUST_ACCOUNTS xx where xx.SELLING_PARTY_ID = temp.party_id

300: (select 'Y' from HZ_CUST_ACCT_SITES_ALL
301: yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID
302: and nvl(STATUS, 'A') in ('A','I')))
303:
304: or exists (select 'Y' from HZ_CUST_ACCOUNTS xx where xx.SELLING_PARTY_ID = temp.party_id
305: and (nvl(STATUS, 'A') in ('A','I')))
306:
307: or exists (select 'Y' from HZ_CUSTOMER_PROFILES xx where xx.PARTY_ID = temp.party_id
308: and (nvl(STATUS, 'A') in ('A','I')))

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

320:
321: exists (select 'Y' from HZ_ORGANIZATION_PROFILES xx where xx.DISPLAYED_DUNS_PARTY_ID = temp.party_id
322: and (nvl(STATUS, 'A') in ('A','I')))
323:
324: or exists (select 'Y' from HZ_CUST_ACCOUNTS xx where xx.PARTY_ID = temp.party_id
325: and (nvl(STATUS, 'A') in ('A','I')))
326:
327: or exists (select 'Y' from HZ_PARTY_SITES
328: xx where xx.PARTY_ID = temp.party_id

Line 335: or exists (select 'Y' from HZ_CUST_ACCOUNTS xx where xx.SELLING_PARTY_ID = temp.party_id

331: (select 'Y' from HZ_CUST_ACCT_SITES_ALL
332: yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID
333: and nvl(STATUS, 'A') in ('A','I')))
334:
335: or exists (select 'Y' from HZ_CUST_ACCOUNTS xx where xx.SELLING_PARTY_ID = temp.party_id
336: and (nvl(STATUS, 'A') in ('A','I')))
337:
338: or exists (select 'Y' from HZ_CUSTOMER_PROFILES xx where xx.PARTY_ID = temp.party_id
339: and (nvl(STATUS, 'A') in ('A','I')))