APPS.HZ_PURGE_GEN dependencies on IBE_SH_QUOTE_ACCESS

Line 3074: --IBE_SH_QUOTE_ACCESS;PARTY_ID

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;
3076: if(regid_proc = true) then
3077: 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
3078:

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

3075: appid:=671;
3076: if(regid_proc = true) then
3077: 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
3078:
3079: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from IBE_SH_QUOTE_ACCESS xx
3080: );
3081: else
3082: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3083: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from IBE_SH_QUOTE_ACCESS xx

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

3079: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from IBE_SH_QUOTE_ACCESS xx
3080: );
3081: else
3082: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3083: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from IBE_SH_QUOTE_ACCESS xx
3084: );
3085: end if;
3086: --IBE_ACTIVE_QUOTES_ALL;PARTY_ID
3087: appid:=671;