4976: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4977: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from AMS_TCOP_CONTACTS xx
4978: );
4979: end if;
4980: --AMS_TCOP_PRVW_CONTACTS;PARTY_ID
4981: appid:=530;
4982: if(regid_proc = true) then
4983: insert into hz_application_trans_gt(app_id,party_id) select 530, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 530 and appl.party_id=temp.party_id) and
4984:
4981: appid:=530;
4982: if(regid_proc = true) then
4983: insert into hz_application_trans_gt(app_id,party_id) select 530, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 530 and appl.party_id=temp.party_id) and
4984:
4985: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from AMS_TCOP_PRVW_CONTACTS xx
4986: );
4987: else
4988: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4989: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from AMS_TCOP_PRVW_CONTACTS xx
4985: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from AMS_TCOP_PRVW_CONTACTS xx
4986: );
4987: else
4988: delete /*+ parallel(temp) */ from hz_purge_gt temp where
4989: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from AMS_TCOP_PRVW_CONTACTS xx
4990: );
4991: end if;
4992: --AMS_TCOP_PRVW_FTG_DTLS;PARTY_ID
4993: appid:=530;