5032: delete /*+ parallel(temp) */ from hz_purge_gt temp where
5033: temp.party_id in (select /*+ parallel(xx)*/ xx.SHIP_TO_PARTY_ID from CS_INCIDENTS_ALL_B xx
5034: );
5035: end if;
5036: --CS_CHG_SUB_RESTRICTIONS;VALUE_OBJECT_ID
5037: appid:=170;
5038: if(regid_proc = true) then
5039: insert into hz_application_trans_gt(app_id,party_id) select 170, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 170 and appl.party_id=temp.party_id) and
5040:
5037: appid:=170;
5038: if(regid_proc = true) then
5039: insert into hz_application_trans_gt(app_id,party_id) select 170, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 170 and appl.party_id=temp.party_id) and
5040:
5041: temp.party_id in (select /*+ parallel(xx)*/ xx.VALUE_OBJECT_ID from CS_CHG_SUB_RESTRICTIONS xx
5042: );
5043: else
5044: delete /*+ parallel(temp) */ from hz_purge_gt temp where
5045: temp.party_id in (select /*+ parallel(xx)*/ xx.VALUE_OBJECT_ID from CS_CHG_SUB_RESTRICTIONS xx
5041: temp.party_id in (select /*+ parallel(xx)*/ xx.VALUE_OBJECT_ID from CS_CHG_SUB_RESTRICTIONS xx
5042: );
5043: else
5044: delete /*+ parallel(temp) */ from hz_purge_gt temp where
5045: temp.party_id in (select /*+ parallel(xx)*/ xx.VALUE_OBJECT_ID from CS_CHG_SUB_RESTRICTIONS xx
5046: );
5047: end if;
5048: --CS_INCIDENTS_ALL_B;BILL_TO_CONTACT_ID
5049: appid:=170;