APPS.HZ_PURGE_GEN dependencies on IBE_MSITE_PRTY_ACCSS

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

358: (select 'Y' from IBE_ORD_ONECLICK_ALL
359: yy where yy.SHIP_TO_PTY_SITE_ID=xx.PARTY_SITE_ID
360: ))
361:
362: or exists (select 'Y' from IBE_MSITE_PRTY_ACCSS xx where xx.PARTY_ID = temp.party_id
363: );
364: else
365: delete from hz_purge_gt temp where
366:

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

386: (select 'Y' from IBE_ORD_ONECLICK_ALL
387: yy where yy.SHIP_TO_PTY_SITE_ID=xx.PARTY_SITE_ID
388: ))
389:
390: or exists (select 'Y' from IBE_MSITE_PRTY_ACCSS xx where xx.PARTY_ID = temp.party_id
391: );
392: end if;
393:
394: