2882: delete /*+ parallel(temp) */ from hz_purge_gt temp where
2883: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from IGW_PERSON_DEGREES xx
2884: );
2885: end if;
2886: --IGW_PERSON_BIOSKETCH;PARTY_ID
2887: appid:=8404;
2888: if(regid_proc = true) then
2889: insert into hz_application_trans_gt(app_id,party_id) select 8404, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 8404 and appl.party_id=temp.party_id) and
2890:
2887: appid:=8404;
2888: if(regid_proc = true) then
2889: insert into hz_application_trans_gt(app_id,party_id) select 8404, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 8404 and appl.party_id=temp.party_id) and
2890:
2891: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from IGW_PERSON_BIOSKETCH xx
2892: );
2893: else
2894: delete /*+ parallel(temp) */ from hz_purge_gt temp where
2895: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from IGW_PERSON_BIOSKETCH xx
2891: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from IGW_PERSON_BIOSKETCH xx
2892: );
2893: else
2894: delete /*+ parallel(temp) */ from hz_purge_gt temp where
2895: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from IGW_PERSON_BIOSKETCH xx
2896: );
2897: end if;
2898: --IGW_PROP_PERSONS_TCA_V;ORG_PARTY_ID
2899: appid:=8404;