APPS.HZ_PURGE_GEN dependencies on IBE_ACTIVE_QUOTES_ALL

Line 3082: --IBE_ACTIVE_QUOTES_ALL;PARTY_ID

3078: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3079: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from IBE_SH_QUOTE_ACCESS xx
3080: );
3081: end if;
3082: --IBE_ACTIVE_QUOTES_ALL;PARTY_ID
3083: appid:=671;
3084: if(regid_proc = true) then
3085: insert into hz_application_trans_gt(app_id,party_id) select 671, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 671 and appl.party_id=temp.party_id) and
3086:

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

3083: appid:=671;
3084: if(regid_proc = true) then
3085: insert into hz_application_trans_gt(app_id,party_id) select 671, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 671 and appl.party_id=temp.party_id) and
3086:
3087: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from IBE_ACTIVE_QUOTES_ALL xx
3088: );
3089: else
3090: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3091: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from IBE_ACTIVE_QUOTES_ALL xx

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

3087: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from IBE_ACTIVE_QUOTES_ALL xx
3088: );
3089: else
3090: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3091: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from IBE_ACTIVE_QUOTES_ALL xx
3092: );
3093: end if;
3094: --OZF_CLAIMS_HISTORY_ALL;BROKER_ID
3095: appid:=682;