2906: delete /*+ parallel(temp) */ from hz_purge_gt temp where
2907: temp.party_id in (select /*+ parallel(xx)*/ xx.ORG_PARTY_ID from IGW_PROP_PERSONS_TCA_V xx
2908: );
2909: end if;
2910: --IGW_PROP_PERSON_SUPPORT;LOCATION_PARTY_ID
2911: appid:=8404;
2912: if(regid_proc = true) then
2913: 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
2914:
2911: appid:=8404;
2912: if(regid_proc = true) then
2913: 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
2914:
2915: temp.party_id in (select /*+ parallel(xx)*/ xx.LOCATION_PARTY_ID from IGW_PROP_PERSON_SUPPORT xx
2916: );
2917: else
2918: delete /*+ parallel(temp) */ from hz_purge_gt temp where
2919: temp.party_id in (select /*+ parallel(xx)*/ xx.LOCATION_PARTY_ID from IGW_PROP_PERSON_SUPPORT xx
2915: temp.party_id in (select /*+ parallel(xx)*/ xx.LOCATION_PARTY_ID from IGW_PROP_PERSON_SUPPORT xx
2916: );
2917: else
2918: delete /*+ parallel(temp) */ from hz_purge_gt temp where
2919: temp.party_id in (select /*+ parallel(xx)*/ xx.LOCATION_PARTY_ID from IGW_PROP_PERSON_SUPPORT xx
2920: );
2921: end if;
2922: --IGW_PROP_PERSON_SUPPORT;PI_PARTY_ID
2923: appid:=8404;
2918: delete /*+ parallel(temp) */ from hz_purge_gt temp where
2919: temp.party_id in (select /*+ parallel(xx)*/ xx.LOCATION_PARTY_ID from IGW_PROP_PERSON_SUPPORT xx
2920: );
2921: end if;
2922: --IGW_PROP_PERSON_SUPPORT;PI_PARTY_ID
2923: appid:=8404;
2924: if(regid_proc = true) then
2925: 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
2926:
2923: appid:=8404;
2924: if(regid_proc = true) then
2925: 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
2926:
2927: temp.party_id in (select /*+ parallel(xx)*/ xx.PI_PARTY_ID from IGW_PROP_PERSON_SUPPORT xx
2928: );
2929: else
2930: delete /*+ parallel(temp) */ from hz_purge_gt temp where
2931: temp.party_id in (select /*+ parallel(xx)*/ xx.PI_PARTY_ID from IGW_PROP_PERSON_SUPPORT xx
2927: temp.party_id in (select /*+ parallel(xx)*/ xx.PI_PARTY_ID from IGW_PROP_PERSON_SUPPORT xx
2928: );
2929: else
2930: delete /*+ parallel(temp) */ from hz_purge_gt temp where
2931: temp.party_id in (select /*+ parallel(xx)*/ xx.PI_PARTY_ID from IGW_PROP_PERSON_SUPPORT xx
2932: );
2933: end if;
2934: --WSH_PARTY_SITES_V;PARTY_SITE_ID
2935: appid:=665;