4088: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4089: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_ID from PON_PARTY_LINE_EXCLUSIONS xx
4090: );
4091: end if;
4092: --PON_PF_SUPPLIER_FORMULA;TRADING_PARTNER_ID
4093: appid:=396;
4094: if(regid_proc = true) then
4095: insert into hz_application_trans_gt(app_id,party_id) select 396, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 396 and appl.party_id=temp.party_id) and
4096:
4093: appid:=396;
4094: if(regid_proc = true) then
4095: insert into hz_application_trans_gt(app_id,party_id) select 396, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 396 and appl.party_id=temp.party_id) and
4096:
4097: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_ID from PON_PF_SUPPLIER_FORMULA xx
4098: );
4099: else
4100: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4101: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_ID from PON_PF_SUPPLIER_FORMULA xx
4097: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_ID from PON_PF_SUPPLIER_FORMULA xx
4098: );
4099: else
4100: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4101: temp.party_id in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_ID from PON_PF_SUPPLIER_FORMULA xx
4102: );
4103: end if;
4104: --PON_BID_HEADERS;SURROG_BID_CREATED_TP_ID
4105: appid:=396;