5000: delete /*+ parallel(temp) */ from hz_purge_gt temp where
5001: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from AMS_TCOP_PRVW_FTG_DTLS xx
5002: );
5003: end if;
5004: --CSC_CUST_PLANS;PARTY_ID
5005: appid:=511;
5006: if(regid_proc = true) then
5007: insert into hz_application_trans_gt(app_id,party_id) select 511, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 511 and appl.party_id=temp.party_id) and
5008:
5005: appid:=511;
5006: if(regid_proc = true) then
5007: insert into hz_application_trans_gt(app_id,party_id) select 511, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 511 and appl.party_id=temp.party_id) and
5008:
5009: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from CSC_CUST_PLANS xx
5010: );
5011: else
5012: delete /*+ parallel(temp) */ from hz_purge_gt temp where
5013: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from CSC_CUST_PLANS xx
5009: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from CSC_CUST_PLANS xx
5010: );
5011: else
5012: delete /*+ parallel(temp) */ from hz_purge_gt temp where
5013: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from CSC_CUST_PLANS xx
5014: );
5015: end if;
5016: --FTE_LOCATION_PARAMETERS;FACILITY_CONTACT_ID
5017: appid:=716;