APPS.HZ_PURGE_GEN dependencies on IBE_MSITE_PRTY_ACCSS

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

375: (select 'Y' from IBE_ORD_ONECLICK_ALL
376: yy where yy.SHIP_TO_PTY_SITE_ID=xx.PARTY_SITE_ID
377: ))
378:
379: or exists (select 'Y' from IBE_MSITE_PRTY_ACCSS xx where xx.PARTY_ID = temp.party_id
380: );
381: else
382: delete from hz_purge_gt temp where
383:

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

403: (select 'Y' from IBE_ORD_ONECLICK_ALL
404: yy where yy.SHIP_TO_PTY_SITE_ID=xx.PARTY_SITE_ID
405: ))
406:
407: or exists (select 'Y' from IBE_MSITE_PRTY_ACCSS xx where xx.PARTY_ID = temp.party_id
408: );
409: end if;
410:
411: