APPS.HZ_PURGE_GEN dependencies on HZ_EMAIL_DOMAINS

Line 3062: --HZ_EMAIL_DOMAINS;PARTY_ID

3058: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3059: to_char(temp.party_id) in (select /*+ parallel(xx)*/ xx.PK1_VALUE from FND_ATTACHED_DOCUMENTS xx
3060: where (entity_name = 'HZ_PARTIES'));
3061: end if;
3062: --HZ_EMAIL_DOMAINS;PARTY_ID
3063: appid:=222;
3064: if(regid_proc = true) then
3065: insert into hz_application_trans_gt(app_id,party_id) select 222, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 222 and appl.party_id=temp.party_id) and
3066:

Line 3067: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from HZ_EMAIL_DOMAINS xx

3063: appid:=222;
3064: if(regid_proc = true) then
3065: insert into hz_application_trans_gt(app_id,party_id) select 222, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 222 and appl.party_id=temp.party_id) and
3066:
3067: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from HZ_EMAIL_DOMAINS xx
3068: );
3069: else
3070: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3071: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from HZ_EMAIL_DOMAINS xx

Line 3071: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from HZ_EMAIL_DOMAINS xx

3067: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from HZ_EMAIL_DOMAINS xx
3068: );
3069: else
3070: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3071: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from HZ_EMAIL_DOMAINS xx
3072: );
3073: end if;
3074: --IBE_SH_QUOTE_ACCESS;PARTY_ID
3075: appid:=671;