eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_PURGE_GEN SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 16


select party_id from hz_purge_gt;

Line: 27


delete from hz_application_trans_gt;

Line: 34


insert into hz_application_trans_gt(app_id,party_id) select 8404, temp.party_id from hz_purge_gt temp where 


 exists (select 'Y' from IGW_PROP_PERSONS_TCA_V xx where xx.PERSON_PARTY_ID =  temp.party_id 
 );

Line: 40


delete from hz_purge_gt temp where 


 exists (select 'Y' from IGW_PROP_PERSONS_TCA_V xx where xx.PERSON_PARTY_ID =  temp.party_id 
 );

Line: 51


insert into hz_application_trans_gt(app_id,party_id) select 691, temp.party_id from hz_purge_gt temp where 


 exists (select 'Y' from PV_PARTNER_PROFILES xx where xx.PARTNER_ID =  temp.party_id 
 )

 or exists (select 'Y' from PV_ENTY_ATTR_VALUES xx where xx.ENTITY_ID =  temp.party_id 
 )

 or exists (select 'Y' from PV_LEAD_ASSIGNMENTS xx where xx.PARTNER_ID =  temp.party_id 
 )

 or exists (select 'Y' from PV_ASSIGNMENT_LOGS xx where xx.PARTNER_ID =  temp.party_id 
 )

 or exists (select 'Y' from PV_SEARCH_ATTR_VALUES xx where xx.PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from PV_GE_PTNR_RESPS xx where xx.PARTNER_ID =  temp.party_id 
 )

 or exists (select 'Y' from PV_LEAD_PSS_LINES xx where xx.PARTNER_ID =  temp.party_id 
 )

 or exists (select 'Y' from PV_GE_PARTY_NOTIFICATIONS xx where xx.PARTNER_ID =  temp.party_id 
 )

 or exists (select 'Y' from PV_PG_ENRL_REQUESTS xx where xx.PARTNER_ID =  temp.party_id 
 )

 or exists (select 'Y' from PV_PG_MEMBERSHIPS xx where xx.PARTNER_ID =  temp.party_id 
 )

 or exists (select 'Y' from PV_PARTNER_PROFILES xx where xx.PARTNER_PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from PV_REFERRALS_B xx where xx.PARTNER_ID =  temp.party_id 
 )

 or exists (select 'Y' from PV_REFERRALS_B xx where xx.CUSTOMER_PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from PV_REFERRALS_B
 yy where yy.CUSTOMER_PARTY_SITE_ID=xx.PARTY_SITE_ID
))

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists 
 (select 'Y' from HZ_ORG_CONTACTS
 yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID 
 and nvl(STATUS, 'A') in ('A','I')
 and exists 
 (select 'Y' from PV_REFERRALS_B zz where zz.CUSTOMER_ORG_CONTACT_ID = yy.ORG_CONTACT_ID )))
 or exists (select 'Y' from HZ_RELATIONSHIPS
 xx where xx.OBJECT_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES'  AND object_table_name = 'HZ_PARTIES'
AND directional_flag = 'F')
 and exists 
 (select 'Y' from HZ_ORG_CONTACTS
 yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID 
 and nvl(STATUS, 'A') in ('A','I')
 and exists 
 (select 'Y' from PV_REFERRALS_B zz where zz.CUSTOMER_ORG_CONTACT_ID = yy.ORG_CONTACT_ID )))
 or exists (select 'Y' from HZ_RELATIONSHIPS
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES'  AND object_table_name = 'HZ_PARTIES'
AND directional_flag = 'F')
 and exists 
 (select 'Y' from HZ_ORG_CONTACTS
 yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID 
 and nvl(STATUS, 'A') in ('A','I')
 and exists 
 (select 'Y' from PV_REFERRALS_B zz where zz.CUSTOMER_ORG_CONTACT_ID = yy.ORG_CONTACT_ID )))
 or exists (select 'Y' from HZ_RELATIONSHIPS
 xx where xx.SUBJECT_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES'  AND object_table_name = 'HZ_PARTIES'
AND directional_flag = 'F')
 and exists 
 (select 'Y' from HZ_ORG_CONTACTS
 yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID 
 and nvl(STATUS, 'A') in ('A','I')
 and exists 
 (select 'Y' from PV_REFERRALS_B zz where zz.CUSTOMER_ORG_CONTACT_ID = yy.ORG_CONTACT_ID )))

 or exists (select 'Y' from PV_REFERRALS_B xx where xx.CUSTOMER_CONTACT_PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from PV_LEAD_ASSIGNMENTS xx where xx.RELATED_PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from PV_PARTNER_ACCESSES xx where xx.PARTNER_ID =  temp.party_id 
 );

Line: 150


delete from hz_purge_gt temp where 


 exists (select 'Y' from PV_PARTNER_PROFILES xx where xx.PARTNER_ID =  temp.party_id 
 )

 or exists (select 'Y' from PV_ENTY_ATTR_VALUES xx where xx.ENTITY_ID =  temp.party_id 
 )

 or exists (select 'Y' from PV_LEAD_ASSIGNMENTS xx where xx.PARTNER_ID =  temp.party_id 
 )

 or exists (select 'Y' from PV_ASSIGNMENT_LOGS xx where xx.PARTNER_ID =  temp.party_id 
 )

 or exists (select 'Y' from PV_SEARCH_ATTR_VALUES xx where xx.PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from PV_GE_PTNR_RESPS xx where xx.PARTNER_ID =  temp.party_id 
 )

 or exists (select 'Y' from PV_LEAD_PSS_LINES xx where xx.PARTNER_ID =  temp.party_id 
 )

 or exists (select 'Y' from PV_GE_PARTY_NOTIFICATIONS xx where xx.PARTNER_ID =  temp.party_id 
 )

 or exists (select 'Y' from PV_PG_ENRL_REQUESTS xx where xx.PARTNER_ID =  temp.party_id 
 )

 or exists (select 'Y' from PV_PG_MEMBERSHIPS xx where xx.PARTNER_ID =  temp.party_id 
 )

 or exists (select 'Y' from PV_PARTNER_PROFILES xx where xx.PARTNER_PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from PV_REFERRALS_B xx where xx.PARTNER_ID =  temp.party_id 
 )

 or exists (select 'Y' from PV_REFERRALS_B xx where xx.CUSTOMER_PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from PV_REFERRALS_B
 yy where yy.CUSTOMER_PARTY_SITE_ID=xx.PARTY_SITE_ID
))

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists 
 (select 'Y' from HZ_ORG_CONTACTS
 yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID 
 and nvl(STATUS, 'A') in ('A','I')
 and exists 
 (select 'Y' from PV_REFERRALS_B zz where zz.CUSTOMER_ORG_CONTACT_ID = yy.ORG_CONTACT_ID )))
 or exists (select 'Y' from HZ_RELATIONSHIPS
 xx where xx.OBJECT_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES'  AND object_table_name = 'HZ_PARTIES'
AND directional_flag = 'F')
 and exists 
 (select 'Y' from HZ_ORG_CONTACTS
 yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID 
 and nvl(STATUS, 'A') in ('A','I')
 and exists 
 (select 'Y' from PV_REFERRALS_B zz where zz.CUSTOMER_ORG_CONTACT_ID = yy.ORG_CONTACT_ID )))
 or exists (select 'Y' from HZ_RELATIONSHIPS
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES'  AND object_table_name = 'HZ_PARTIES'
AND directional_flag = 'F')
 and exists 
 (select 'Y' from HZ_ORG_CONTACTS
 yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID 
 and nvl(STATUS, 'A') in ('A','I')
 and exists 
 (select 'Y' from PV_REFERRALS_B zz where zz.CUSTOMER_ORG_CONTACT_ID = yy.ORG_CONTACT_ID )))
 or exists (select 'Y' from HZ_RELATIONSHIPS
 xx where xx.SUBJECT_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES'  AND object_table_name = 'HZ_PARTIES'
AND directional_flag = 'F')
 and exists 
 (select 'Y' from HZ_ORG_CONTACTS
 yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID 
 and nvl(STATUS, 'A') in ('A','I')
 and exists 
 (select 'Y' from PV_REFERRALS_B zz where zz.CUSTOMER_ORG_CONTACT_ID = yy.ORG_CONTACT_ID )))

 or exists (select 'Y' from PV_REFERRALS_B xx where xx.CUSTOMER_CONTACT_PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from PV_LEAD_ASSIGNMENTS xx where xx.RELATED_PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from PV_PARTNER_ACCESSES xx where xx.PARTNER_ID =  temp.party_id 
 );

Line: 254


insert into hz_application_trans_gt(app_id,party_id) select 665, temp.party_id from hz_purge_gt temp where 


 exists (select 'Y' from WSH_CARRIERS xx where xx.CARRIER_ID =  temp.party_id 
 )

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from WSH_CARRIER_SITES
 yy where yy.CARRIER_SITE_ID=xx.PARTY_SITE_ID
));

Line: 268


delete from hz_purge_gt temp where 


 exists (select 'Y' from WSH_CARRIERS xx where xx.CARRIER_ID =  temp.party_id 
 )

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from WSH_CARRIER_SITES
 yy where yy.CARRIER_SITE_ID=xx.PARTY_SITE_ID
));

Line: 287


insert into hz_application_trans_gt(app_id,party_id) select 222, temp.party_id from hz_purge_gt temp where 


 exists (select 'Y' from HZ_ORGANIZATION_PROFILES xx where xx.DISPLAYED_DUNS_PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I')))

 or exists (select 'Y' from HZ_CUST_ACCOUNTS xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I')))

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from HZ_CUST_ACCT_SITES_ALL
 yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID
 and nvl(STATUS, 'A') in ('A','I')))

 or exists (select 'Y' from HZ_CUST_ACCOUNTS xx where xx.SELLING_PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I')))

 or exists (select 'Y' from HZ_CUSTOMER_PROFILES xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I')))

 or exists (select 'Y' from HZ_RELATIONSHIPS xx where xx.OBJECT_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES'  AND object_table_name = 'HZ_PARTIES'
AND directional_flag = 'F'))

 or exists (select 'Y' from HZ_RELATIONSHIPS xx where xx.SUBJECT_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES'  AND object_table_name = 'HZ_PARTIES'
AND directional_flag = 'F'));

Line: 318


delete from hz_purge_gt temp where 


 exists (select 'Y' from HZ_ORGANIZATION_PROFILES xx where xx.DISPLAYED_DUNS_PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I')))

 or exists (select 'Y' from HZ_CUST_ACCOUNTS xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I')))

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from HZ_CUST_ACCT_SITES_ALL
 yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID
 and nvl(STATUS, 'A') in ('A','I')))

 or exists (select 'Y' from HZ_CUST_ACCOUNTS xx where xx.SELLING_PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I')))

 or exists (select 'Y' from HZ_CUSTOMER_PROFILES xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I')))

 or exists (select 'Y' from HZ_RELATIONSHIPS xx where xx.OBJECT_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES'  AND object_table_name = 'HZ_PARTIES'
AND directional_flag = 'F'))

 or exists (select 'Y' from HZ_RELATIONSHIPS xx where xx.SUBJECT_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES'  AND object_table_name = 'HZ_PARTIES'
AND directional_flag = 'F'));

Line: 354


insert into hz_application_trans_gt(app_id,party_id) select 671, temp.party_id from hz_purge_gt temp where 


 exists (select 'Y' from IBE_SH_SHP_LISTS_ALL xx where xx.PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from IBE_ORD_ONECLICK_ALL xx where xx.PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from IBE_ORD_ONECLICK_ALL
 yy where yy.BILL_TO_PTY_SITE_ID=xx.PARTY_SITE_ID
))

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from IBE_ORD_ONECLICK_ALL
 yy where yy.SHIP_TO_PTY_SITE_ID=xx.PARTY_SITE_ID
))

 or exists (select 'Y' from IBE_MSITE_PRTY_ACCSS xx where xx.PARTY_ID =  temp.party_id 
 );

Line: 382


delete from hz_purge_gt temp where 


 exists (select 'Y' from IBE_SH_SHP_LISTS_ALL xx where xx.PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from IBE_ORD_ONECLICK_ALL xx where xx.PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from IBE_ORD_ONECLICK_ALL
 yy where yy.BILL_TO_PTY_SITE_ID=xx.PARTY_SITE_ID
))

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from IBE_ORD_ONECLICK_ALL
 yy where yy.SHIP_TO_PTY_SITE_ID=xx.PARTY_SITE_ID
))

 or exists (select 'Y' from IBE_MSITE_PRTY_ACCSS xx where xx.PARTY_ID =  temp.party_id 
 );

Line: 415


insert into hz_application_trans_gt(app_id,party_id) select 682, temp.party_id from hz_purge_gt temp where 


 exists (select 'Y' from OZF_CUST_TRD_PRFLS_ALL xx where xx.PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from OZF_CLAIMS_ALL xx where xx.BROKER_ID =  temp.party_id 
 )

 or exists (select 'Y' from OZF_CLAIMS_ALL xx where xx.CONTACT_ID =  temp.party_id 
 )

 or exists (select 'Y' from OZF_ACT_BUDGETS xx where xx.BUDGET_SOURCE_ID =  temp.party_id 
 and (BUDGET_SOURCE_TYPE='PTNR'))

 or exists (select 'Y' from OZF_ACT_BUDGETS xx where xx.VENDOR_ID =  temp.party_id 
 )

 or exists (select 'Y' from OZF_OFFERS xx where xx.BUYING_GROUP_CONTACT_ID =  temp.party_id 
 )

 or exists (select 'Y' from OZF_REQUEST_HEADERS_ALL_B xx where xx.PARTNER_ID =  temp.party_id 
 )

 or exists (select 'Y' from OZF_CODE_CONVERSIONS_ALL xx where xx.PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from OZF_RESALE_BATCHES_ALL xx where xx.PARTNER_PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from OZF_REQUEST_HEADERS_ALL_B xx where xx.PARTNER_ID =  temp.party_id 
 );

Line: 448


delete from hz_purge_gt temp where 


 exists (select 'Y' from OZF_CUST_TRD_PRFLS_ALL xx where xx.PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from OZF_CLAIMS_ALL xx where xx.BROKER_ID =  temp.party_id 
 )

 or exists (select 'Y' from OZF_CLAIMS_ALL xx where xx.CONTACT_ID =  temp.party_id 
 )

 or exists (select 'Y' from OZF_ACT_BUDGETS xx where xx.BUDGET_SOURCE_ID =  temp.party_id 
 and (BUDGET_SOURCE_TYPE='PTNR'))

 or exists (select 'Y' from OZF_ACT_BUDGETS xx where xx.VENDOR_ID =  temp.party_id 
 )

 or exists (select 'Y' from OZF_OFFERS xx where xx.BUYING_GROUP_CONTACT_ID =  temp.party_id 
 )

 or exists (select 'Y' from OZF_REQUEST_HEADERS_ALL_B xx where xx.PARTNER_ID =  temp.party_id 
 )

 or exists (select 'Y' from OZF_CODE_CONVERSIONS_ALL xx where xx.PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from OZF_RESALE_BATCHES_ALL xx where xx.PARTNER_PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from OZF_REQUEST_HEADERS_ALL_B xx where xx.PARTNER_ID =  temp.party_id 
 );

Line: 486


insert into hz_application_trans_gt(app_id,party_id) select 695, temp.party_id from hz_purge_gt temp where 


 exists (select 'Y' from IEX_DELINQUENCIES_ALL xx where xx.PARTY_CUST_ID =  temp.party_id 
 )

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from IEX_CASE_CONTACTS
 yy where yy.ADDRESS_ID=xx.PARTY_SITE_ID
));

Line: 500


delete from hz_purge_gt temp where 


 exists (select 'Y' from IEX_DELINQUENCIES_ALL xx where xx.PARTY_CUST_ID =  temp.party_id 
 )

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from IEX_CASE_CONTACTS
 yy where yy.ADDRESS_ID=xx.PARTY_SITE_ID
));

Line: 519


insert into hz_application_trans_gt(app_id,party_id) select 8405, temp.party_id from hz_purge_gt temp where 


 exists (select 'Y' from HZ_EDUCATION
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from IGS_AD_HZ_ACAD_HIST
 yy where yy.EDUCATION_ID=xx.EDUCATION_ID
))
 or exists (select 'Y' from HZ_EDUCATION
 xx where xx.SCHOOL_PARTY_ID =  temp.party_id 
 and (nvl(STATUS,'A') in ('A','I'))
 and exists
(select 'Y' from IGS_AD_HZ_ACAD_HIST
 yy where yy.EDUCATION_ID=xx.EDUCATION_ID
))

 or exists (select 'Y' from HZ_EMPLOYMENT_HISTORY
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from IGS_AD_HZ_EMP_DTL
 yy where yy.EMPLOYMENT_HISTORY_ID=xx.EMPLOYMENT_HISTORY_ID
))
 or exists (select 'Y' from HZ_EMPLOYMENT_HISTORY
 xx where xx.EMPLOYED_BY_PARTY_ID =  temp.party_id 
 and (nvl(STATUS,'A') in ('A','I'))
 and exists
(select 'Y' from IGS_AD_HZ_EMP_DTL
 yy where yy.EMPLOYMENT_HISTORY_ID=xx.EMPLOYMENT_HISTORY_ID
))

 or exists (select 'Y' from HZ_PERSON_INTEREST
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from IGS_AD_HZ_EXTRACURR_ACT
 yy where yy.PERSON_INTEREST_ID=xx.PERSON_INTEREST_ID
))

 or exists (select 'Y' from HZ_EDUCATION
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from IGS_AD_TRANSCRIPT
 yy where yy.EDUCATION_ID=xx.EDUCATION_ID
))
 or exists (select 'Y' from HZ_EDUCATION
 xx where xx.SCHOOL_PARTY_ID =  temp.party_id 
 and (nvl(STATUS,'A') in ('A','I'))
 and exists
(select 'Y' from IGS_AD_TRANSCRIPT
 yy where yy.EDUCATION_ID=xx.EDUCATION_ID
))

 or exists (select 'Y' from IGS_PE_HZ_PARTIES xx where xx.PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from IGS_FI_CREDITS_ALL xx where xx.PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from IGS_FI_INV_INT_ALL xx where xx.PERSON_ID =  temp.party_id 
 )

 or exists (select 'Y' from IGS_FI_PARTY_VENDRS xx where xx.PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from IGS_FI_PP_STD_ATTRS xx where xx.PERSON_ID =  temp.party_id 
 )

 or exists (select 'Y' from IGS_FI_P_SA_NOTES xx where xx.PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from IGS_FI_REFUNDS xx where xx.PERSON_ID =  temp.party_id 
 )

 or exists (select 'Y' from IGP_AC_ACCOUNTS xx where xx.PARTY_ID =  temp.party_id 
 );

Line: 599


delete from hz_purge_gt temp where 


 exists (select 'Y' from HZ_EDUCATION
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from IGS_AD_HZ_ACAD_HIST
 yy where yy.EDUCATION_ID=xx.EDUCATION_ID
))
 or exists (select 'Y' from HZ_EDUCATION
 xx where xx.SCHOOL_PARTY_ID =  temp.party_id 
 and (nvl(STATUS,'A') in ('A','I'))
 and exists
(select 'Y' from IGS_AD_HZ_ACAD_HIST
 yy where yy.EDUCATION_ID=xx.EDUCATION_ID
))

 or exists (select 'Y' from HZ_EMPLOYMENT_HISTORY
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from IGS_AD_HZ_EMP_DTL
 yy where yy.EMPLOYMENT_HISTORY_ID=xx.EMPLOYMENT_HISTORY_ID
))
 or exists (select 'Y' from HZ_EMPLOYMENT_HISTORY
 xx where xx.EMPLOYED_BY_PARTY_ID =  temp.party_id 
 and (nvl(STATUS,'A') in ('A','I'))
 and exists
(select 'Y' from IGS_AD_HZ_EMP_DTL
 yy where yy.EMPLOYMENT_HISTORY_ID=xx.EMPLOYMENT_HISTORY_ID
))

 or exists (select 'Y' from HZ_PERSON_INTEREST
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from IGS_AD_HZ_EXTRACURR_ACT
 yy where yy.PERSON_INTEREST_ID=xx.PERSON_INTEREST_ID
))

 or exists (select 'Y' from HZ_EDUCATION
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from IGS_AD_TRANSCRIPT
 yy where yy.EDUCATION_ID=xx.EDUCATION_ID
))
 or exists (select 'Y' from HZ_EDUCATION
 xx where xx.SCHOOL_PARTY_ID =  temp.party_id 
 and (nvl(STATUS,'A') in ('A','I'))
 and exists
(select 'Y' from IGS_AD_TRANSCRIPT
 yy where yy.EDUCATION_ID=xx.EDUCATION_ID
))

 or exists (select 'Y' from IGS_PE_HZ_PARTIES xx where xx.PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from IGS_FI_CREDITS_ALL xx where xx.PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from IGS_FI_INV_INT_ALL xx where xx.PERSON_ID =  temp.party_id 
 )

 or exists (select 'Y' from IGS_FI_PARTY_VENDRS xx where xx.PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from IGS_FI_PP_STD_ATTRS xx where xx.PERSON_ID =  temp.party_id 
 )

 or exists (select 'Y' from IGS_FI_P_SA_NOTES xx where xx.PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from IGS_FI_REFUNDS xx where xx.PERSON_ID =  temp.party_id 
 )

 or exists (select 'Y' from IGP_AC_ACCOUNTS xx where xx.PARTY_ID =  temp.party_id 
 );

Line: 684


insert into hz_application_trans_gt(app_id,party_id) select 661, temp.party_id from hz_purge_gt temp where 


 exists (select 'Y' from QP_QUALIFIERS xx where xx.QUALIFIER_ATTR_VALUE =  to_char(temp.party_id) 
 and ((qualifier_context = 'ASOPARTYINFO'  AND qualifier_attribute = 'QUALIFIER_ATTRIBUTE1'  OR qualifier_context = 'CUSTOMER' AND qualifier_attribute ='QUALIFIER_ATTRIBUTE16'  OR qualifier_context = 'CUSTOMER_GROUP' AND qualifier_attribute = 'QUALIFIER_ATTRIBUTE3'  OR qualifier_context = 'PARTY' AND qualifier_attribute IN ('QUALIFIER_ATTRIBUTE1', 'QUALIFIER_ATTRIBUTE2'))))

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from QP_QUALIFIERS
 yy where yy.QUALIFIER_ATTR_VALUE=to_char(xx.PARTY_SITE_ID)
 and (qualifier_context = 'ASOPARTYINFO'  AND qualifier_attribute IN ('QUALIFIER_ATTRIBUTE10','QUALIFIER_ATTRIBUTE11')  OR qualifier_context = 'CUSTOMER' AND qualifier_attribute IN ('QUALIFIER_ATTRIBUTE17', 'QUALIFIER_ATTRIBUTE18'))));

Line: 698


delete from hz_purge_gt temp where 


 exists (select 'Y' from QP_QUALIFIERS xx where xx.QUALIFIER_ATTR_VALUE =  to_char(temp.party_id) 
 and ((qualifier_context = 'ASOPARTYINFO'  AND qualifier_attribute = 'QUALIFIER_ATTRIBUTE1'  OR qualifier_context = 'CUSTOMER' AND qualifier_attribute ='QUALIFIER_ATTRIBUTE16'  OR qualifier_context = 'CUSTOMER_GROUP' AND qualifier_attribute = 'QUALIFIER_ATTRIBUTE3'  OR qualifier_context = 'PARTY' AND qualifier_attribute IN ('QUALIFIER_ATTRIBUTE1', 'QUALIFIER_ATTRIBUTE2'))))

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from QP_QUALIFIERS
 yy where yy.QUALIFIER_ATTR_VALUE=to_char(xx.PARTY_SITE_ID)
 and (qualifier_context = 'ASOPARTYINFO'  AND qualifier_attribute IN ('QUALIFIER_ATTRIBUTE10','QUALIFIER_ATTRIBUTE11')  OR qualifier_context = 'CUSTOMER' AND qualifier_attribute IN ('QUALIFIER_ATTRIBUTE17', 'QUALIFIER_ATTRIBUTE18'))));

Line: 717


insert into hz_application_trans_gt(app_id,party_id) select 694, temp.party_id from hz_purge_gt temp where 


 exists (select 'Y' from PRP_PROPOSALS xx where xx.PARTY_ID =  temp.party_id 
 );

Line: 723


delete from hz_purge_gt temp where 


 exists (select 'Y' from PRP_PROPOSALS xx where xx.PARTY_ID =  temp.party_id 
 );

Line: 734


insert into hz_application_trans_gt(app_id,party_id) select 542, temp.party_id from hz_purge_gt temp where 


 exists (select 'Y' from CSI_ITEM_INSTANCES xx where xx.OWNER_PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from CSI_T_TXN_LINE_DETAILS
 yy where yy.LOCATION_ID=xx.PARTY_SITE_ID
))

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from CSI_T_TXN_LINE_DETAILS
 yy where yy.INSTALL_LOCATION_ID=xx.PARTY_SITE_ID
))

 or exists (select 'Y' from CSI_I_PARTIES xx where xx.PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from CSI_SYSTEMS_B xx where xx.SHIP_TO_CONTACT_ID =  temp.party_id 
 )

 or exists (select 'Y' from CSI_T_PARTY_DETAILS xx where xx.PARTY_SOURCE_ID =  temp.party_id 
 )

 or exists (select 'Y' from CSI_T_TXN_SYSTEMS xx where xx.SHIP_TO_CONTACT_ID =  temp.party_id 
 )

 or exists (select 'Y' from CSI_SYSTEMS_B xx where xx.BILL_TO_CONTACT_ID =  temp.party_id 
 )

 or exists (select 'Y' from CSI_SYSTEMS_B xx where xx.TECHNICAL_CONTACT_ID =  temp.party_id 
 )

 or exists (select 'Y' from CSI_SYSTEMS_B xx where xx.SERVICE_ADMIN_CONTACT_ID =  temp.party_id 
 )

 or exists (select 'Y' from CSI_T_TXN_SYSTEMS xx where xx.BILL_TO_CONTACT_ID =  temp.party_id 
 )

 or exists (select 'Y' from CSI_T_TXN_SYSTEMS xx where xx.SERVICE_ADMIN_CONTACT_ID =  temp.party_id 
 )

 or exists (select 'Y' from CSI_T_TXN_SYSTEMS xx where xx.TECHNICAL_CONTACT_ID =  temp.party_id 
 )

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from CSI_SYSTEMS_B
 yy where yy.INSTALL_SITE_USE_ID=xx.PARTY_SITE_ID
));

Line: 794


delete from hz_purge_gt temp where 


 exists (select 'Y' from CSI_ITEM_INSTANCES xx where xx.OWNER_PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from CSI_T_TXN_LINE_DETAILS
 yy where yy.LOCATION_ID=xx.PARTY_SITE_ID
))

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from CSI_T_TXN_LINE_DETAILS
 yy where yy.INSTALL_LOCATION_ID=xx.PARTY_SITE_ID
))

 or exists (select 'Y' from CSI_I_PARTIES xx where xx.PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from CSI_SYSTEMS_B xx where xx.SHIP_TO_CONTACT_ID =  temp.party_id 
 )

 or exists (select 'Y' from CSI_T_PARTY_DETAILS xx where xx.PARTY_SOURCE_ID =  temp.party_id 
 )

 or exists (select 'Y' from CSI_T_TXN_SYSTEMS xx where xx.SHIP_TO_CONTACT_ID =  temp.party_id 
 )

 or exists (select 'Y' from CSI_SYSTEMS_B xx where xx.BILL_TO_CONTACT_ID =  temp.party_id 
 )

 or exists (select 'Y' from CSI_SYSTEMS_B xx where xx.TECHNICAL_CONTACT_ID =  temp.party_id 
 )

 or exists (select 'Y' from CSI_SYSTEMS_B xx where xx.SERVICE_ADMIN_CONTACT_ID =  temp.party_id 
 )

 or exists (select 'Y' from CSI_T_TXN_SYSTEMS xx where xx.BILL_TO_CONTACT_ID =  temp.party_id 
 )

 or exists (select 'Y' from CSI_T_TXN_SYSTEMS xx where xx.SERVICE_ADMIN_CONTACT_ID =  temp.party_id 
 )

 or exists (select 'Y' from CSI_T_TXN_SYSTEMS xx where xx.TECHNICAL_CONTACT_ID =  temp.party_id 
 )

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from CSI_SYSTEMS_B
 yy where yy.INSTALL_SITE_USE_ID=xx.PARTY_SITE_ID
));

Line: 859


insert into hz_application_trans_gt(app_id,party_id) select 510, temp.party_id from hz_purge_gt temp where 


 exists (select 'Y' from OKC_K_PARTY_ROLES_B xx where xx.OBJECT1_ID1 =  to_char(temp.party_id) 
 and (jtot_object1_code IN (SELECT ojt.object_code FROM jtf_objects_b ojt  ,jtf_object_usages oue WHERE ojt.object_code = oue.object_code AND oue.object_user_code = 'OKX_PARTY')))

 or exists (select 'Y' from OKC_CONTACTS xx where xx.OBJECT1_ID1 =  to_char(temp.party_id) 
 and (jtot_object1_code IN (SELECT ojt.object_code FROM jtf_objects_b ojt  ,jtf_object_usages oue WHERE ojt.object_code = oue.object_code AND oue.object_user_code = 'OKX_CONTACTS')))

 or exists (select 'Y' from OKC_RULES_B xx where xx.OBJECT1_ID1 =  to_char(temp.party_id) 
 and (jtot_object1_code IN (SELECT ojt.object_code FROM jtf_objects_b ojt  ,jtf_object_usages oue WHERE ojt.object_code = oue.object_code AND oue.object_user_code = 'OKX_PARTY')))

 or exists (select 'Y' from OKC_RULES_B xx where xx.OBJECT2_ID1 =  to_char(temp.party_id) 
 and (jtot_object2_code IN (SELECT ojt.object_code FROM jtf_objects_b ojt  ,jtf_object_usages oue WHERE ojt.object_code = oue.object_code AND oue.object_user_code = 'OKX_PARTY')))

 or exists (select 'Y' from OKC_RULES_B xx where xx.OBJECT3_ID1 =  to_char(temp.party_id) 
 and (jtot_object3_code IN (SELECT ojt.object_code FROM jtf_objects_b ojt  ,jtf_object_usages oue WHERE ojt.object_code = oue.object_code AND oue.object_user_code = 'OKX_PARTY')))

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from OKC_RULES_B
 yy where yy.OBJECT1_ID1=to_char(xx.PARTY_SITE_ID)
 and jtot_object1_code IN (SELECT ojt.object_code FROM jtf_objects_b ojt  ,jtf_object_usages oue WHERE ojt.object_code = oue.object_code AND oue.object_user_code = 'OKX_P_SITE')))

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from OKC_RULES_B
 yy where yy.OBJECT2_ID1=to_char(xx.PARTY_SITE_ID)
 and jtot_object2_code IN (SELECT ojt.object_code FROM jtf_objects_b ojt  ,jtf_object_usages oue WHERE ojt.object_code = oue.object_code AND oue.object_user_code = 'OKX_P_SITE')))

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from OKC_RULES_B
 yy where yy.OBJECT3_ID1=to_char(xx.PARTY_SITE_ID)
 and jtot_object3_code IN (SELECT ojt.object_code FROM jtf_objects_b ojt  ,jtf_object_usages oue WHERE ojt.object_code = oue.object_code AND oue.object_user_code = 'OKX_P_SITE')))

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists 
 (select 'Y' from HZ_PARTY_SITE_USES
 yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID 
 and nvl(STATUS, 'A') in ('A','I')
 and exists 
 (select 'Y' from OKC_RULES_B zz where zz.OBJECT1_ID1=to_char(yy.PARTY_SITE_USE_ID) and jtot_object1_code IN (SELECT ojt.object_code FROM jtf_objects_b ojt  ,jtf_object_usages oue WHERE ojt.object_code = oue.object_code AND oue.object_user_code = 'OKX_P_SITE_USE'))))

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists 
 (select 'Y' from HZ_PARTY_SITE_USES
 yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID 
 and nvl(STATUS, 'A') in ('A','I')
 and exists 
 (select 'Y' from OKC_RULES_B zz where zz.OBJECT2_ID1=to_char(yy.PARTY_SITE_USE_ID) and jtot_object2_code IN (SELECT ojt.object_code FROM jtf_objects_b ojt  ,jtf_object_usages oue WHERE ojt.object_code = oue.object_code AND oue.object_user_code = 'OKX_P_SITE_USE'))))

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists 
 (select 'Y' from HZ_PARTY_SITE_USES
 yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID 
 and nvl(STATUS, 'A') in ('A','I')
 and exists 
 (select 'Y' from OKC_RULES_B zz where zz.OBJECT3_ID1=to_char(yy.PARTY_SITE_USE_ID) and jtot_object3_code IN (SELECT ojt.object_code FROM jtf_objects_b ojt  ,jtf_object_usages oue WHERE ojt.object_code = oue.object_code AND oue.object_user_code = 'OKX_P_SITE_USE'))))

 or exists (select 'Y' from OKC_K_ITEMS xx where xx.OBJECT1_ID1 =  to_char(temp.party_id) 
 and (jtot_object1_code IN (SELECT ojt.object_code FROM jtf_objects_b ojt  ,jtf_object_usages oue WHERE ojt.object_code = oue.object_code AND oue.object_user_code = 'OKX_PARTY')))

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from OKC_K_ITEMS
 yy where yy.OBJECT1_ID1=to_char(xx.PARTY_SITE_ID)
 and jtot_object1_code IN (SELECT ojt.object_code FROM jtf_objects_b ojt  ,jtf_object_usages oue WHERE ojt.object_code = oue.object_code AND oue.object_user_code = 'OKX_P_SITE')))

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists 
 (select 'Y' from HZ_PARTY_SITE_USES
 yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID 
 and nvl(STATUS, 'A') in ('A','I')
 and exists 
 (select 'Y' from OKC_K_ITEMS zz where zz.OBJECT1_ID1=to_char(yy.PARTY_SITE_USE_ID) and jtot_object1_code IN (SELECT ojt.object_code FROM jtf_objects_b ojt  ,jtf_object_usages oue WHERE ojt.object_code = oue.object_code AND oue.object_user_code = 'OKX_P_SITE_USE'))));

Line: 952


delete from hz_purge_gt temp where 


 exists (select 'Y' from OKC_K_PARTY_ROLES_B xx where xx.OBJECT1_ID1 =  to_char(temp.party_id) 
 and (jtot_object1_code IN (SELECT ojt.object_code FROM jtf_objects_b ojt  ,jtf_object_usages oue WHERE ojt.object_code = oue.object_code AND oue.object_user_code = 'OKX_PARTY')))

 or exists (select 'Y' from OKC_CONTACTS xx where xx.OBJECT1_ID1 =  to_char(temp.party_id) 
 and (jtot_object1_code IN (SELECT ojt.object_code FROM jtf_objects_b ojt  ,jtf_object_usages oue WHERE ojt.object_code = oue.object_code AND oue.object_user_code = 'OKX_CONTACTS')))

 or exists (select 'Y' from OKC_RULES_B xx where xx.OBJECT1_ID1 =  to_char(temp.party_id) 
 and (jtot_object1_code IN (SELECT ojt.object_code FROM jtf_objects_b ojt  ,jtf_object_usages oue WHERE ojt.object_code = oue.object_code AND oue.object_user_code = 'OKX_PARTY')))

 or exists (select 'Y' from OKC_RULES_B xx where xx.OBJECT2_ID1 =  to_char(temp.party_id) 
 and (jtot_object2_code IN (SELECT ojt.object_code FROM jtf_objects_b ojt  ,jtf_object_usages oue WHERE ojt.object_code = oue.object_code AND oue.object_user_code = 'OKX_PARTY')))

 or exists (select 'Y' from OKC_RULES_B xx where xx.OBJECT3_ID1 =  to_char(temp.party_id) 
 and (jtot_object3_code IN (SELECT ojt.object_code FROM jtf_objects_b ojt  ,jtf_object_usages oue WHERE ojt.object_code = oue.object_code AND oue.object_user_code = 'OKX_PARTY')))

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from OKC_RULES_B
 yy where yy.OBJECT1_ID1=to_char(xx.PARTY_SITE_ID)
 and jtot_object1_code IN (SELECT ojt.object_code FROM jtf_objects_b ojt  ,jtf_object_usages oue WHERE ojt.object_code = oue.object_code AND oue.object_user_code = 'OKX_P_SITE')))

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from OKC_RULES_B
 yy where yy.OBJECT2_ID1=to_char(xx.PARTY_SITE_ID)
 and jtot_object2_code IN (SELECT ojt.object_code FROM jtf_objects_b ojt  ,jtf_object_usages oue WHERE ojt.object_code = oue.object_code AND oue.object_user_code = 'OKX_P_SITE')))

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from OKC_RULES_B
 yy where yy.OBJECT3_ID1=to_char(xx.PARTY_SITE_ID)
 and jtot_object3_code IN (SELECT ojt.object_code FROM jtf_objects_b ojt  ,jtf_object_usages oue WHERE ojt.object_code = oue.object_code AND oue.object_user_code = 'OKX_P_SITE')))

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists 
 (select 'Y' from HZ_PARTY_SITE_USES
 yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID 
 and nvl(STATUS, 'A') in ('A','I')
 and exists 
 (select 'Y' from OKC_RULES_B zz where zz.OBJECT1_ID1=to_char(yy.PARTY_SITE_USE_ID) and jtot_object1_code IN (SELECT ojt.object_code FROM jtf_objects_b ojt  ,jtf_object_usages oue WHERE ojt.object_code = oue.object_code AND oue.object_user_code = 'OKX_P_SITE_USE'))))

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists 
 (select 'Y' from HZ_PARTY_SITE_USES
 yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID 
 and nvl(STATUS, 'A') in ('A','I')
 and exists 
 (select 'Y' from OKC_RULES_B zz where zz.OBJECT2_ID1=to_char(yy.PARTY_SITE_USE_ID) and jtot_object2_code IN (SELECT ojt.object_code FROM jtf_objects_b ojt  ,jtf_object_usages oue WHERE ojt.object_code = oue.object_code AND oue.object_user_code = 'OKX_P_SITE_USE'))))

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists 
 (select 'Y' from HZ_PARTY_SITE_USES
 yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID 
 and nvl(STATUS, 'A') in ('A','I')
 and exists 
 (select 'Y' from OKC_RULES_B zz where zz.OBJECT3_ID1=to_char(yy.PARTY_SITE_USE_ID) and jtot_object3_code IN (SELECT ojt.object_code FROM jtf_objects_b ojt  ,jtf_object_usages oue WHERE ojt.object_code = oue.object_code AND oue.object_user_code = 'OKX_P_SITE_USE'))))

 or exists (select 'Y' from OKC_K_ITEMS xx where xx.OBJECT1_ID1 =  to_char(temp.party_id) 
 and (jtot_object1_code IN (SELECT ojt.object_code FROM jtf_objects_b ojt  ,jtf_object_usages oue WHERE ojt.object_code = oue.object_code AND oue.object_user_code = 'OKX_PARTY')))

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from OKC_K_ITEMS
 yy where yy.OBJECT1_ID1=to_char(xx.PARTY_SITE_ID)
 and jtot_object1_code IN (SELECT ojt.object_code FROM jtf_objects_b ojt  ,jtf_object_usages oue WHERE ojt.object_code = oue.object_code AND oue.object_user_code = 'OKX_P_SITE')))

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists 
 (select 'Y' from HZ_PARTY_SITE_USES
 yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID 
 and nvl(STATUS, 'A') in ('A','I')
 and exists 
 (select 'Y' from OKC_K_ITEMS zz where zz.OBJECT1_ID1=to_char(yy.PARTY_SITE_USE_ID) and jtot_object1_code IN (SELECT ojt.object_code FROM jtf_objects_b ojt  ,jtf_object_usages oue WHERE ojt.object_code = oue.object_code AND oue.object_user_code = 'OKX_P_SITE_USE'))));

Line: 1050


insert into hz_application_trans_gt(app_id,party_id) select 697, temp.party_id from hz_purge_gt temp where 


 exists (select 'Y' from ASO_QUOTE_HEADERS_ALL xx where xx.PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from ASO_SHIPMENTS
 yy where yy.SHIP_TO_PARTY_SITE_ID=xx.PARTY_SITE_ID
))

 or exists (select 'Y' from ASO_QUOTE_HEADERS_ALL xx where xx.CUST_PARTY_ID =  temp.party_id 
 );

Line: 1067


delete from hz_purge_gt temp where 


 exists (select 'Y' from ASO_QUOTE_HEADERS_ALL xx where xx.PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from ASO_SHIPMENTS
 yy where yy.SHIP_TO_PARTY_SITE_ID=xx.PARTY_SITE_ID
))

 or exists (select 'Y' from ASO_QUOTE_HEADERS_ALL xx where xx.CUST_PARTY_ID =  temp.party_id 
 );

Line: 1089


insert into hz_application_trans_gt(app_id,party_id) select 777, temp.party_id from hz_purge_gt temp where 


 exists (select 'Y' from OKE_K_FUNDING_SOURCES_PM_HV xx where xx.K_PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from OKE_K_FUNDING_SOURCES xx where xx.K_PARTY_ID =  temp.party_id 
 );

Line: 1098


delete from hz_purge_gt temp where 


 exists (select 'Y' from OKE_K_FUNDING_SOURCES_PM_HV xx where xx.K_PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from OKE_K_FUNDING_SOURCES xx where xx.K_PARTY_ID =  temp.party_id 
 );

Line: 1112


insert into hz_application_trans_gt(app_id,party_id) select 867, temp.party_id from hz_purge_gt temp where 


 exists (select 'Y' from AHL_DOCUMENTS_B xx where xx.SOURCE_PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from AHL_SUPPLIER_DOCUMENTS xx where xx.SUPPLIER_ID =  temp.party_id 
 )

 or exists (select 'Y' from AHL_RECIPIENT_DOCUMENTS xx where xx.RECIPIENT_PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from AHL_DOC_REVISIONS_B xx where xx.APPROVED_BY_PARTY_ID =  temp.party_id 
 );

Line: 1127


delete from hz_purge_gt temp where 


 exists (select 'Y' from AHL_DOCUMENTS_B xx where xx.SOURCE_PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from AHL_SUPPLIER_DOCUMENTS xx where xx.SUPPLIER_ID =  temp.party_id 
 )

 or exists (select 'Y' from AHL_RECIPIENT_DOCUMENTS xx where xx.RECIPIENT_PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from AHL_DOC_REVISIONS_B xx where xx.APPROVED_BY_PARTY_ID =  temp.party_id 
 );

Line: 1147


insert into hz_application_trans_gt(app_id,party_id) select 279, temp.party_id from hz_purge_gt temp where 


 exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from AS_SALES_LEAD_CONTACTS
 yy where yy.ADDRESS_ID=xx.PARTY_SITE_ID
))

 or exists (select 'Y' from HZ_CONTACT_POINTS
 xx where xx.OWNER_TABLE_ID =  temp.party_id 
 and (OWNER_TABLE_NAME='HZ_PARTIES' AND nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from AS_SALES_LEAD_CONTACTS
 yy where yy.PHONE_ID=xx.CONTACT_POINT_ID
))
 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists 
 (select 'Y' from HZ_CONTACT_POINTS
 yy where yy.OWNER_TABLE_ID=xx.PARTY_SITE_ID 
 and OWNER_TABLE_NAME='HZ_PARTY_SITES' AND nvl(STATUS, 'A') in ('A','I')
 and exists 
 (select 'Y' from AS_SALES_LEAD_CONTACTS zz where zz.PHONE_ID = yy.CONTACT_POINT_ID )))

 or exists (select 'Y' from AS_SALES_LEAD_CONTACTS xx where xx.CONTACT_PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from AS_ACCESSES_ALL xx where xx.CUSTOMER_ID =  temp.party_id 
 )

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from AS_ACCESSES_ALL
 yy where yy.ADDRESS_ID=xx.PARTY_SITE_ID
))

 or exists (select 'Y' from AS_ACCESSES_ALL xx where xx.PARTNER_CUSTOMER_ID =  temp.party_id 
 )

 or exists (select 'Y' from AS_ACCESSES_ALL xx where xx.PARTNER_CONT_PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from AS_INTERESTS_ALL xx where xx.CUSTOMER_ID =  temp.party_id 
 )

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from AS_INTERESTS_ALL
 yy where yy.ADDRESS_ID=xx.PARTY_SITE_ID
))

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists 
 (select 'Y' from HZ_ORG_CONTACTS
 yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID 
 and nvl(STATUS, 'A') in ('A','I')
 and exists 
 (select 'Y' from AS_INTERESTS_ALL zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))
 or exists (select 'Y' from HZ_RELATIONSHIPS
 xx where xx.OBJECT_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES'  AND object_table_name = 'HZ_PARTIES'
AND directional_flag = 'F')
 and exists 
 (select 'Y' from HZ_ORG_CONTACTS
 yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID 
 and nvl(STATUS, 'A') in ('A','I')
 and exists 
 (select 'Y' from AS_INTERESTS_ALL zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))
 or exists (select 'Y' from HZ_RELATIONSHIPS
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES'  AND object_table_name = 'HZ_PARTIES'
AND directional_flag = 'F')
 and exists 
 (select 'Y' from HZ_ORG_CONTACTS
 yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID 
 and nvl(STATUS, 'A') in ('A','I')
 and exists 
 (select 'Y' from AS_INTERESTS_ALL zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))
 or exists (select 'Y' from HZ_RELATIONSHIPS
 xx where xx.SUBJECT_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES'  AND object_table_name = 'HZ_PARTIES'
AND directional_flag = 'F')
 and exists 
 (select 'Y' from HZ_ORG_CONTACTS
 yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID 
 and nvl(STATUS, 'A') in ('A','I')
 and exists 
 (select 'Y' from AS_INTERESTS_ALL zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from AS_ACCESSES_ALL
 yy where yy.PARTNER_ADDRESS_ID=xx.PARTY_SITE_ID
))

 or exists (select 'Y' from AS_SALES_LEADS xx where xx.CUSTOMER_ID =  temp.party_id 
 )

 or exists (select 'Y' from AS_SALES_LEAD_CONTACTS xx where xx.CUSTOMER_ID =  temp.party_id 
 )

 or exists (select 'Y' from AS_LEADS_ALL xx where xx.CUSTOMER_ID =  temp.party_id 
 )

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from AS_LEADS_ALL
 yy where yy.ADDRESS_ID=xx.PARTY_SITE_ID
))

 or exists (select 'Y' from AS_LEADS_ALL xx where xx.CLOSE_COMPETITOR_ID =  temp.party_id 
 )

 or exists (select 'Y' from AS_LEADS_ALL xx where xx.INCUMBENT_PARTNER_PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from AS_LEAD_COMPETITORS xx where xx.COMPETITOR_ID =  temp.party_id 
 )

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists 
 (select 'Y' from HZ_ORG_CONTACTS
 yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID 
 and nvl(STATUS, 'A') in ('A','I')
 and exists 
 (select 'Y' from AS_LEAD_CONTACTS_ALL zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))
 or exists (select 'Y' from HZ_RELATIONSHIPS
 xx where xx.OBJECT_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES'  AND object_table_name = 'HZ_PARTIES'
AND directional_flag = 'F')
 and exists 
 (select 'Y' from HZ_ORG_CONTACTS
 yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID 
 and nvl(STATUS, 'A') in ('A','I')
 and exists 
 (select 'Y' from AS_LEAD_CONTACTS_ALL zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))
 or exists (select 'Y' from HZ_RELATIONSHIPS
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES'  AND object_table_name = 'HZ_PARTIES'
AND directional_flag = 'F')
 and exists 
 (select 'Y' from HZ_ORG_CONTACTS
 yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID 
 and nvl(STATUS, 'A') in ('A','I')
 and exists 
 (select 'Y' from AS_LEAD_CONTACTS_ALL zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))
 or exists (select 'Y' from HZ_RELATIONSHIPS
 xx where xx.SUBJECT_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES'  AND object_table_name = 'HZ_PARTIES'
AND directional_flag = 'F')
 and exists 
 (select 'Y' from HZ_ORG_CONTACTS
 yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID 
 and nvl(STATUS, 'A') in ('A','I')
 and exists 
 (select 'Y' from AS_LEAD_CONTACTS_ALL zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))

 or exists (select 'Y' from AS_LEAD_CONTACTS_ALL xx where xx.CONTACT_PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from AS_LEAD_CONTACTS_ALL xx where xx.CUSTOMER_ID =  temp.party_id 
 )

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from AS_LEAD_CONTACTS_ALL
 yy where yy.ADDRESS_ID=xx.PARTY_SITE_ID
))

 or exists (select 'Y' from AS_SALES_CREDITS xx where xx.PARTNER_CUSTOMER_ID =  temp.party_id 
 )

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from AS_SALES_CREDITS
 yy where yy.PARTNER_ADDRESS_ID=xx.PARTY_SITE_ID
))

 or exists (select 'Y' from AS_SALES_CREDITS_DENORM xx where xx.PARTNER_CUSTOMER_ID =  temp.party_id 
 )

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from AS_SALES_CREDITS_DENORM
 yy where yy.PARTNER_ADDRESS_ID=xx.PARTY_SITE_ID
))

 or exists (select 'Y' from AS_SALES_CREDITS_DENORM xx where xx.CUSTOMER_ID =  temp.party_id 
 )

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from AS_SALES_CREDITS_DENORM
 yy where yy.ADDRESS_ID=xx.PARTY_SITE_ID
))

 or exists (select 'Y' from HZ_CONTACT_POINTS
 xx where xx.OWNER_TABLE_ID =  temp.party_id 
 and (OWNER_TABLE_NAME='HZ_PARTIES' AND nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from AS_LEAD_CONTACTS_ALL
 yy where yy.PHONE_ID=xx.CONTACT_POINT_ID
))
 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists 
 (select 'Y' from HZ_CONTACT_POINTS
 yy where yy.OWNER_TABLE_ID=xx.PARTY_SITE_ID 
 and OWNER_TABLE_NAME='HZ_PARTY_SITES' AND nvl(STATUS, 'A') in ('A','I')
 and exists 
 (select 'Y' from AS_LEAD_CONTACTS_ALL zz where zz.PHONE_ID = yy.CONTACT_POINT_ID )))

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from AS_CURRENT_ENVIRONMENT
 yy where yy.ADDRESS_ID=xx.PARTY_SITE_ID
))

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists 
 (select 'Y' from HZ_ORG_CONTACTS
 yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID 
 and nvl(STATUS, 'A') in ('A','I')
 and exists 
 (select 'Y' from AS_SALES_LEAD_CONTACTS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))
 or exists (select 'Y' from HZ_RELATIONSHIPS
 xx where xx.OBJECT_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES'  AND object_table_name = 'HZ_PARTIES'
AND directional_flag = 'F')
 and exists 
 (select 'Y' from HZ_ORG_CONTACTS
 yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID 
 and nvl(STATUS, 'A') in ('A','I')
 and exists 
 (select 'Y' from AS_SALES_LEAD_CONTACTS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))
 or exists (select 'Y' from HZ_RELATIONSHIPS
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES'  AND object_table_name = 'HZ_PARTIES'
AND directional_flag = 'F')
 and exists 
 (select 'Y' from HZ_ORG_CONTACTS
 yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID 
 and nvl(STATUS, 'A') in ('A','I')
 and exists 
 (select 'Y' from AS_SALES_LEAD_CONTACTS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))
 or exists (select 'Y' from HZ_RELATIONSHIPS
 xx where xx.SUBJECT_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES'  AND object_table_name = 'HZ_PARTIES'
AND directional_flag = 'F')
 and exists 
 (select 'Y' from HZ_ORG_CONTACTS
 yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID 
 and nvl(STATUS, 'A') in ('A','I')
 and exists 
 (select 'Y' from AS_SALES_LEAD_CONTACTS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from AS_SALES_LEADS
 yy where yy.ADDRESS_ID=xx.PARTY_SITE_ID
))

 or exists (select 'Y' from AS_SALES_LEADS xx where xx.PRIMARY_CONTACT_PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from AS_SALES_LEADS xx where xx.PRIMARY_CNT_PERSON_PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from HZ_CONTACT_POINTS
 xx where xx.OWNER_TABLE_ID =  temp.party_id 
 and (OWNER_TABLE_NAME='HZ_PARTIES' AND nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from AS_SALES_LEADS
 yy where yy.PRIMARY_CONTACT_PHONE_ID=xx.CONTACT_POINT_ID
))
 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists 
 (select 'Y' from HZ_CONTACT_POINTS
 yy where yy.OWNER_TABLE_ID=xx.PARTY_SITE_ID 
 and OWNER_TABLE_NAME='HZ_PARTY_SITES' AND nvl(STATUS, 'A') in ('A','I')
 and exists 
 (select 'Y' from AS_SALES_LEADS zz where zz.PRIMARY_CONTACT_PHONE_ID = yy.CONTACT_POINT_ID )))

 or exists (select 'Y' from AS_AP_ACCOUNT_PLANS xx where xx.CUST_PARTY_ID =  temp.party_id 
 );

Line: 1466


delete from hz_purge_gt temp where 


 exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from AS_SALES_LEAD_CONTACTS
 yy where yy.ADDRESS_ID=xx.PARTY_SITE_ID
))

 or exists (select 'Y' from HZ_CONTACT_POINTS
 xx where xx.OWNER_TABLE_ID =  temp.party_id 
 and (OWNER_TABLE_NAME='HZ_PARTIES' AND nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from AS_SALES_LEAD_CONTACTS
 yy where yy.PHONE_ID=xx.CONTACT_POINT_ID
))
 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists 
 (select 'Y' from HZ_CONTACT_POINTS
 yy where yy.OWNER_TABLE_ID=xx.PARTY_SITE_ID 
 and OWNER_TABLE_NAME='HZ_PARTY_SITES' AND nvl(STATUS, 'A') in ('A','I')
 and exists 
 (select 'Y' from AS_SALES_LEAD_CONTACTS zz where zz.PHONE_ID = yy.CONTACT_POINT_ID )))

 or exists (select 'Y' from AS_SALES_LEAD_CONTACTS xx where xx.CONTACT_PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from AS_ACCESSES_ALL xx where xx.CUSTOMER_ID =  temp.party_id 
 )

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from AS_ACCESSES_ALL
 yy where yy.ADDRESS_ID=xx.PARTY_SITE_ID
))

 or exists (select 'Y' from AS_ACCESSES_ALL xx where xx.PARTNER_CUSTOMER_ID =  temp.party_id 
 )

 or exists (select 'Y' from AS_ACCESSES_ALL xx where xx.PARTNER_CONT_PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from AS_INTERESTS_ALL xx where xx.CUSTOMER_ID =  temp.party_id 
 )

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from AS_INTERESTS_ALL
 yy where yy.ADDRESS_ID=xx.PARTY_SITE_ID
))

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists 
 (select 'Y' from HZ_ORG_CONTACTS
 yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID 
 and nvl(STATUS, 'A') in ('A','I')
 and exists 
 (select 'Y' from AS_INTERESTS_ALL zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))
 or exists (select 'Y' from HZ_RELATIONSHIPS
 xx where xx.OBJECT_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES'  AND object_table_name = 'HZ_PARTIES'
AND directional_flag = 'F')
 and exists 
 (select 'Y' from HZ_ORG_CONTACTS
 yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID 
 and nvl(STATUS, 'A') in ('A','I')
 and exists 
 (select 'Y' from AS_INTERESTS_ALL zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))
 or exists (select 'Y' from HZ_RELATIONSHIPS
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES'  AND object_table_name = 'HZ_PARTIES'
AND directional_flag = 'F')
 and exists 
 (select 'Y' from HZ_ORG_CONTACTS
 yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID 
 and nvl(STATUS, 'A') in ('A','I')
 and exists 
 (select 'Y' from AS_INTERESTS_ALL zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))
 or exists (select 'Y' from HZ_RELATIONSHIPS
 xx where xx.SUBJECT_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES'  AND object_table_name = 'HZ_PARTIES'
AND directional_flag = 'F')
 and exists 
 (select 'Y' from HZ_ORG_CONTACTS
 yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID 
 and nvl(STATUS, 'A') in ('A','I')
 and exists 
 (select 'Y' from AS_INTERESTS_ALL zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from AS_ACCESSES_ALL
 yy where yy.PARTNER_ADDRESS_ID=xx.PARTY_SITE_ID
))

 or exists (select 'Y' from AS_SALES_LEADS xx where xx.CUSTOMER_ID =  temp.party_id 
 )

 or exists (select 'Y' from AS_SALES_LEAD_CONTACTS xx where xx.CUSTOMER_ID =  temp.party_id 
 )

 or exists (select 'Y' from AS_LEADS_ALL xx where xx.CUSTOMER_ID =  temp.party_id 
 )

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from AS_LEADS_ALL
 yy where yy.ADDRESS_ID=xx.PARTY_SITE_ID
))

 or exists (select 'Y' from AS_LEADS_ALL xx where xx.CLOSE_COMPETITOR_ID =  temp.party_id 
 )

 or exists (select 'Y' from AS_LEADS_ALL xx where xx.INCUMBENT_PARTNER_PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from AS_LEAD_COMPETITORS xx where xx.COMPETITOR_ID =  temp.party_id 
 )

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists 
 (select 'Y' from HZ_ORG_CONTACTS
 yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID 
 and nvl(STATUS, 'A') in ('A','I')
 and exists 
 (select 'Y' from AS_LEAD_CONTACTS_ALL zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))
 or exists (select 'Y' from HZ_RELATIONSHIPS
 xx where xx.OBJECT_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES'  AND object_table_name = 'HZ_PARTIES'
AND directional_flag = 'F')
 and exists 
 (select 'Y' from HZ_ORG_CONTACTS
 yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID 
 and nvl(STATUS, 'A') in ('A','I')
 and exists 
 (select 'Y' from AS_LEAD_CONTACTS_ALL zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))
 or exists (select 'Y' from HZ_RELATIONSHIPS
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES'  AND object_table_name = 'HZ_PARTIES'
AND directional_flag = 'F')
 and exists 
 (select 'Y' from HZ_ORG_CONTACTS
 yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID 
 and nvl(STATUS, 'A') in ('A','I')
 and exists 
 (select 'Y' from AS_LEAD_CONTACTS_ALL zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))
 or exists (select 'Y' from HZ_RELATIONSHIPS
 xx where xx.SUBJECT_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES'  AND object_table_name = 'HZ_PARTIES'
AND directional_flag = 'F')
 and exists 
 (select 'Y' from HZ_ORG_CONTACTS
 yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID 
 and nvl(STATUS, 'A') in ('A','I')
 and exists 
 (select 'Y' from AS_LEAD_CONTACTS_ALL zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))

 or exists (select 'Y' from AS_LEAD_CONTACTS_ALL xx where xx.CONTACT_PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from AS_LEAD_CONTACTS_ALL xx where xx.CUSTOMER_ID =  temp.party_id 
 )

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from AS_LEAD_CONTACTS_ALL
 yy where yy.ADDRESS_ID=xx.PARTY_SITE_ID
))

 or exists (select 'Y' from AS_SALES_CREDITS xx where xx.PARTNER_CUSTOMER_ID =  temp.party_id 
 )

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from AS_SALES_CREDITS
 yy where yy.PARTNER_ADDRESS_ID=xx.PARTY_SITE_ID
))

 or exists (select 'Y' from AS_SALES_CREDITS_DENORM xx where xx.PARTNER_CUSTOMER_ID =  temp.party_id 
 )

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from AS_SALES_CREDITS_DENORM
 yy where yy.PARTNER_ADDRESS_ID=xx.PARTY_SITE_ID
))

 or exists (select 'Y' from AS_SALES_CREDITS_DENORM xx where xx.CUSTOMER_ID =  temp.party_id 
 )

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from AS_SALES_CREDITS_DENORM
 yy where yy.ADDRESS_ID=xx.PARTY_SITE_ID
))

 or exists (select 'Y' from HZ_CONTACT_POINTS
 xx where xx.OWNER_TABLE_ID =  temp.party_id 
 and (OWNER_TABLE_NAME='HZ_PARTIES' AND nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from AS_LEAD_CONTACTS_ALL
 yy where yy.PHONE_ID=xx.CONTACT_POINT_ID
))
 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists 
 (select 'Y' from HZ_CONTACT_POINTS
 yy where yy.OWNER_TABLE_ID=xx.PARTY_SITE_ID 
 and OWNER_TABLE_NAME='HZ_PARTY_SITES' AND nvl(STATUS, 'A') in ('A','I')
 and exists 
 (select 'Y' from AS_LEAD_CONTACTS_ALL zz where zz.PHONE_ID = yy.CONTACT_POINT_ID )))

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from AS_CURRENT_ENVIRONMENT
 yy where yy.ADDRESS_ID=xx.PARTY_SITE_ID
))

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists 
 (select 'Y' from HZ_ORG_CONTACTS
 yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID 
 and nvl(STATUS, 'A') in ('A','I')
 and exists 
 (select 'Y' from AS_SALES_LEAD_CONTACTS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))
 or exists (select 'Y' from HZ_RELATIONSHIPS
 xx where xx.OBJECT_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES'  AND object_table_name = 'HZ_PARTIES'
AND directional_flag = 'F')
 and exists 
 (select 'Y' from HZ_ORG_CONTACTS
 yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID 
 and nvl(STATUS, 'A') in ('A','I')
 and exists 
 (select 'Y' from AS_SALES_LEAD_CONTACTS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))
 or exists (select 'Y' from HZ_RELATIONSHIPS
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES'  AND object_table_name = 'HZ_PARTIES'
AND directional_flag = 'F')
 and exists 
 (select 'Y' from HZ_ORG_CONTACTS
 yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID 
 and nvl(STATUS, 'A') in ('A','I')
 and exists 
 (select 'Y' from AS_SALES_LEAD_CONTACTS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))
 or exists (select 'Y' from HZ_RELATIONSHIPS
 xx where xx.SUBJECT_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES'  AND object_table_name = 'HZ_PARTIES'
AND directional_flag = 'F')
 and exists 
 (select 'Y' from HZ_ORG_CONTACTS
 yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID 
 and nvl(STATUS, 'A') in ('A','I')
 and exists 
 (select 'Y' from AS_SALES_LEAD_CONTACTS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID )))

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from AS_SALES_LEADS
 yy where yy.ADDRESS_ID=xx.PARTY_SITE_ID
))

 or exists (select 'Y' from AS_SALES_LEADS xx where xx.PRIMARY_CONTACT_PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from AS_SALES_LEADS xx where xx.PRIMARY_CNT_PERSON_PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from HZ_CONTACT_POINTS
 xx where xx.OWNER_TABLE_ID =  temp.party_id 
 and (OWNER_TABLE_NAME='HZ_PARTIES' AND nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from AS_SALES_LEADS
 yy where yy.PRIMARY_CONTACT_PHONE_ID=xx.CONTACT_POINT_ID
))
 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists 
 (select 'Y' from HZ_CONTACT_POINTS
 yy where yy.OWNER_TABLE_ID=xx.PARTY_SITE_ID 
 and OWNER_TABLE_NAME='HZ_PARTY_SITES' AND nvl(STATUS, 'A') in ('A','I')
 and exists 
 (select 'Y' from AS_SALES_LEADS zz where zz.PRIMARY_CONTACT_PHONE_ID = yy.CONTACT_POINT_ID )))

 or exists (select 'Y' from AS_AP_ACCOUNT_PLANS xx where xx.CUST_PARTY_ID =  temp.party_id 
 );

Line: 1790


insert into hz_application_trans_gt(app_id,party_id) select 206, temp.party_id from hz_purge_gt temp where 


 exists (select 'Y' from LNS_LOAN_HEADERS_ALL xx where xx.PRIMARY_BORROWER_ID =  temp.party_id 
 )

 or exists (select 'Y' from LNS_PARTICIPANTS xx where xx.HZ_PARTY_ID =  temp.party_id 
 );

Line: 1799


delete from hz_purge_gt temp where 


 exists (select 'Y' from LNS_LOAN_HEADERS_ALL xx where xx.PRIMARY_BORROWER_ID =  temp.party_id 
 )

 or exists (select 'Y' from LNS_PARTICIPANTS xx where xx.HZ_PARTY_ID =  temp.party_id 
 );

Line: 1813


insert into hz_application_trans_gt(app_id,party_id) select 275, temp.party_id from hz_purge_gt temp where 


 exists (select 'Y' from PA_CI_ACTIONS xx where xx.ASSIGNED_TO =  temp.party_id 
 )

 or exists (select 'Y' from PA_CONTROL_ITEMS xx where xx.OWNER_ID =  temp.party_id 
 )

 or exists (select 'Y' from PA_PERCENT_COMPLETES xx where xx.PUBLISHED_BY_PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from PA_PROJECT_REQUESTS xx where xx.CUST_PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from PA_PROJECT_SETS_B xx where xx.PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from PA_RESOURCE_TXN_ATTRIBUTES xx where xx.PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from PA_CI_IMPACTS xx where xx.IMPLEMENTED_BY =  temp.party_id 
 )

 or exists (select 'Y' from PA_CONTROL_ITEMS xx where xx.LAST_MODIFIED_BY_ID =  temp.party_id 
 )

 or exists (select 'Y' from PA_CONTROL_ITEMS xx where xx.CLOSED_BY_ID =  temp.party_id 
 );

Line: 1843


delete from hz_purge_gt temp where 


 exists (select 'Y' from PA_CI_ACTIONS xx where xx.ASSIGNED_TO =  temp.party_id 
 )

 or exists (select 'Y' from PA_CONTROL_ITEMS xx where xx.OWNER_ID =  temp.party_id 
 )

 or exists (select 'Y' from PA_PERCENT_COMPLETES xx where xx.PUBLISHED_BY_PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from PA_PROJECT_REQUESTS xx where xx.CUST_PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from PA_PROJECT_SETS_B xx where xx.PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from PA_RESOURCE_TXN_ATTRIBUTES xx where xx.PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from PA_CI_IMPACTS xx where xx.IMPLEMENTED_BY =  temp.party_id 
 )

 or exists (select 'Y' from PA_CONTROL_ITEMS xx where xx.LAST_MODIFIED_BY_ID =  temp.party_id 
 )

 or exists (select 'Y' from PA_CONTROL_ITEMS xx where xx.CLOSED_BY_ID =  temp.party_id 
 );

Line: 1878


insert into hz_application_trans_gt(app_id,party_id) select 451, temp.party_id from hz_purge_gt temp where 


 exists (select 'Y' from OPI_DBI_COGS_F xx where xx.CUSTOMER_ID =  temp.party_id 
 );

Line: 1884


delete from hz_purge_gt temp where 


 exists (select 'Y' from OPI_DBI_COGS_F xx where xx.CUSTOMER_ID =  temp.party_id 
 );

Line: 1895


insert into hz_application_trans_gt(app_id,party_id) select 396, temp.party_id from hz_purge_gt temp where 


 exists (select 'Y' from PON_TE_RECIPIENTS xx where xx.TO_ID =  temp.party_id 
 )

 or exists (select 'Y' from PON_BIDDING_PARTIES xx where xx.TRADING_PARTNER_ID =  temp.party_id 
 )

 or exists (select 'Y' from PON_BID_ITEM_PRICES xx where xx.BID_TRADING_PARTNER_ID =  temp.party_id 
 )

 or exists (select 'Y' from PON_AUCTION_HEADERS_ALL xx where xx.TRADING_PARTNER_CONTACT_ID =  temp.party_id 
 )

 or exists (select 'Y' from PON_AUCTION_HEADERS_ALL xx where xx.TRADING_PARTNER_ID =  temp.party_id 
 )

 or exists (select 'Y' from PON_AUCTION_EVENTS xx where xx.TRADING_PARTNER_ID =  temp.party_id 
 )

 or exists (select 'Y' from PON_BIDDERS_LISTS xx where xx.TRADING_PARTNER_CONTACT_ID =  temp.party_id 
 )

 or exists (select 'Y' from PON_BIDDERS_LISTS xx where xx.TRADING_PARTNER_ID =  temp.party_id 
 )

 or exists (select 'Y' from PON_ATTRIBUTE_LISTS xx where xx.TRADING_PARTNER_CONTACT_ID =  temp.party_id 
 )

 or exists (select 'Y' from PON_ATTRIBUTE_LISTS xx where xx.TRADING_PARTNER_ID =  temp.party_id 
 )

 or exists (select 'Y' from PON_BID_HEADERS xx where xx.TRADING_PARTNER_CONTACT_ID =  temp.party_id 
 )

 or exists (select 'Y' from PON_BID_HEADERS xx where xx.TRADING_PARTNER_ID =  temp.party_id 
 );

Line: 1934


delete from hz_purge_gt temp where 


 exists (select 'Y' from PON_TE_RECIPIENTS xx where xx.TO_ID =  temp.party_id 
 )

 or exists (select 'Y' from PON_BIDDING_PARTIES xx where xx.TRADING_PARTNER_ID =  temp.party_id 
 )

 or exists (select 'Y' from PON_BID_ITEM_PRICES xx where xx.BID_TRADING_PARTNER_ID =  temp.party_id 
 )

 or exists (select 'Y' from PON_AUCTION_HEADERS_ALL xx where xx.TRADING_PARTNER_CONTACT_ID =  temp.party_id 
 )

 or exists (select 'Y' from PON_AUCTION_HEADERS_ALL xx where xx.TRADING_PARTNER_ID =  temp.party_id 
 )

 or exists (select 'Y' from PON_AUCTION_EVENTS xx where xx.TRADING_PARTNER_ID =  temp.party_id 
 )

 or exists (select 'Y' from PON_BIDDERS_LISTS xx where xx.TRADING_PARTNER_CONTACT_ID =  temp.party_id 
 )

 or exists (select 'Y' from PON_BIDDERS_LISTS xx where xx.TRADING_PARTNER_ID =  temp.party_id 
 )

 or exists (select 'Y' from PON_ATTRIBUTE_LISTS xx where xx.TRADING_PARTNER_CONTACT_ID =  temp.party_id 
 )

 or exists (select 'Y' from PON_ATTRIBUTE_LISTS xx where xx.TRADING_PARTNER_ID =  temp.party_id 
 )

 or exists (select 'Y' from PON_BID_HEADERS xx where xx.TRADING_PARTNER_CONTACT_ID =  temp.party_id 
 )

 or exists (select 'Y' from PON_BID_HEADERS xx where xx.TRADING_PARTNER_ID =  temp.party_id 
 );

Line: 1978


insert into hz_application_trans_gt(app_id,party_id) select 540, temp.party_id from hz_purge_gt temp where 


 exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists 
 (select 'Y' from HZ_PARTY_SITE_USES
 yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID 
 and nvl(STATUS, 'A') in ('A','I')
 and exists 
 (select 'Y' from OKL_RELOCATE_ASSETS_B zz where zz.IST_ID = yy.PARTY_SITE_USE_ID )))

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists 
 (select 'Y' from HZ_PARTY_SITE_USES
 yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID 
 and nvl(STATUS, 'A') in ('A','I')
 and exists 
 (select 'Y' from OKL_RELOCATE_ASSETS_B zz where zz.IST_ID = yy.PARTY_SITE_USE_ID )))

 or exists (select 'Y' from OKL_TRX_AR_INVOICES_B xx where xx.IBT_ID =  temp.party_id 
 )

 or exists (select 'Y' from OKL_CNSLD_AR_HDRS_B xx where xx.IBT_ID =  temp.party_id 
 )

 or exists (select 'Y' from OKL_TXL_RCPT_APPS_B xx where xx.ILE_ID =  temp.party_id 
 )

 or exists (select 'Y' from HZ_CONTACT_POINTS
 xx where xx.OWNER_TABLE_ID =  temp.party_id 
 and (OWNER_TABLE_NAME='HZ_PARTIES' AND nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from OKL_RELOCATE_ASSETS_B
 yy where yy.PAC_ID=xx.CONTACT_POINT_ID
))
 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists 
 (select 'Y' from HZ_CONTACT_POINTS
 yy where yy.OWNER_TABLE_ID=xx.PARTY_SITE_ID 
 and OWNER_TABLE_NAME='HZ_PARTY_SITES' AND nvl(STATUS, 'A') in ('A','I')
 and exists 
 (select 'Y' from OKL_RELOCATE_ASSETS_B zz where zz.PAC_ID = yy.CONTACT_POINT_ID )));

Line: 2027


delete from hz_purge_gt temp where 


 exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists 
 (select 'Y' from HZ_PARTY_SITE_USES
 yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID 
 and nvl(STATUS, 'A') in ('A','I')
 and exists 
 (select 'Y' from OKL_RELOCATE_ASSETS_B zz where zz.IST_ID = yy.PARTY_SITE_USE_ID )))

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists 
 (select 'Y' from HZ_PARTY_SITE_USES
 yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID 
 and nvl(STATUS, 'A') in ('A','I')
 and exists 
 (select 'Y' from OKL_RELOCATE_ASSETS_B zz where zz.IST_ID = yy.PARTY_SITE_USE_ID )))

 or exists (select 'Y' from OKL_TRX_AR_INVOICES_B xx where xx.IBT_ID =  temp.party_id 
 )

 or exists (select 'Y' from OKL_CNSLD_AR_HDRS_B xx where xx.IBT_ID =  temp.party_id 
 )

 or exists (select 'Y' from OKL_TXL_RCPT_APPS_B xx where xx.ILE_ID =  temp.party_id 
 )

 or exists (select 'Y' from HZ_CONTACT_POINTS
 xx where xx.OWNER_TABLE_ID =  temp.party_id 
 and (OWNER_TABLE_NAME='HZ_PARTIES' AND nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from OKL_RELOCATE_ASSETS_B
 yy where yy.PAC_ID=xx.CONTACT_POINT_ID
))
 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists 
 (select 'Y' from HZ_CONTACT_POINTS
 yy where yy.OWNER_TABLE_ID=xx.PARTY_SITE_ID 
 and OWNER_TABLE_NAME='HZ_PARTY_SITES' AND nvl(STATUS, 'A') in ('A','I')
 and exists 
 (select 'Y' from OKL_RELOCATE_ASSETS_B zz where zz.PAC_ID = yy.CONTACT_POINT_ID )));

Line: 2081


insert into hz_application_trans_gt(app_id,party_id) select 530, temp.party_id from hz_purge_gt temp where 


 exists (select 'Y' from AMS_PARTY_SOURCES xx where xx.PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from AMS_ACT_PARTNERS xx where xx.PARTNER_ID =  temp.party_id 
 )

 or exists (select 'Y' from AMS_ACT_PARTNERS xx where xx.PREFERRED_VAD_ID =  temp.party_id 
 )

 or exists (select 'Y' from AMS_ACT_PARTNERS xx where xx.PRIMARY_CONTACT_ID =  temp.party_id 
 )

 or exists (select 'Y' from AMS_EVENT_REGISTRATIONS xx where xx.REGISTRANT_PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from AMS_EVENT_REGISTRATIONS xx where xx.ATTENDANT_CONTACT_ID =  temp.party_id 
 )

 or exists (select 'Y' from AMS_CHANNELS_B xx where xx.PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from AMS_IBA_POSTINGS_B xx where xx.CUSTOMER_PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from AMS_IBA_POSTINGS_B xx where xx.AFFILIATE_PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from AMS_COMPETITOR_PRODUCTS_B xx where xx.COMPETITOR_PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from AMS_VENUES_B xx where xx.PARTY_ID =  temp.party_id 
 and (OBJECT_TYPE='VENU'))

 or exists (select 'Y' from AMS_IMP_SOURCE_LINES xx where xx.PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from AMS_LIST_ENTRIES xx where xx.PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from AMS_LIST_ENTRIES xx where xx.PARENT_PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from AMS_ACT_RESOURCES xx where xx.RESOURCE_ID =  temp.party_id 
 )

 or exists (select 'Y' from AMS_TCOP_CONTACT_SUMMARY xx where xx.PARTY_ID =  temp.party_id 
 );

Line: 2132


delete from hz_purge_gt temp where 


 exists (select 'Y' from AMS_PARTY_SOURCES xx where xx.PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from AMS_ACT_PARTNERS xx where xx.PARTNER_ID =  temp.party_id 
 )

 or exists (select 'Y' from AMS_ACT_PARTNERS xx where xx.PREFERRED_VAD_ID =  temp.party_id 
 )

 or exists (select 'Y' from AMS_ACT_PARTNERS xx where xx.PRIMARY_CONTACT_ID =  temp.party_id 
 )

 or exists (select 'Y' from AMS_EVENT_REGISTRATIONS xx where xx.REGISTRANT_PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from AMS_EVENT_REGISTRATIONS xx where xx.ATTENDANT_CONTACT_ID =  temp.party_id 
 )

 or exists (select 'Y' from AMS_CHANNELS_B xx where xx.PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from AMS_IBA_POSTINGS_B xx where xx.CUSTOMER_PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from AMS_IBA_POSTINGS_B xx where xx.AFFILIATE_PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from AMS_COMPETITOR_PRODUCTS_B xx where xx.COMPETITOR_PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from AMS_VENUES_B xx where xx.PARTY_ID =  temp.party_id 
 and (OBJECT_TYPE='VENU'))

 or exists (select 'Y' from AMS_IMP_SOURCE_LINES xx where xx.PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from AMS_LIST_ENTRIES xx where xx.PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from AMS_LIST_ENTRIES xx where xx.PARENT_PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from AMS_ACT_RESOURCES xx where xx.RESOURCE_ID =  temp.party_id 
 )

 or exists (select 'Y' from AMS_TCOP_CONTACT_SUMMARY xx where xx.PARTY_ID =  temp.party_id 
 );

Line: 2188


insert into hz_application_trans_gt(app_id,party_id) select 511, temp.party_id from hz_purge_gt temp where 


 exists (select 'Y' from CSC_CUSTOMERS xx where xx.PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from CSC_CUSTOMIZED_PLANS xx where xx.PARTY_ID =  temp.party_id 
 );

Line: 2197


delete from hz_purge_gt temp where 


 exists (select 'Y' from CSC_CUSTOMERS xx where xx.PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from CSC_CUSTOMIZED_PLANS xx where xx.PARTY_ID =  temp.party_id 
 );

Line: 2211


insert into hz_application_trans_gt(app_id,party_id) select 454, temp.party_id from hz_purge_gt temp where 


 exists (select 'Y' from ISC_BOOK_SUM2_PDUE_F xx where xx.CUSTOMER_ID =  temp.party_id 
 )

 or exists (select 'Y' from ISC_BOOK_SUM2_PDUE2_F xx where xx.CUSTOMER_ID =  temp.party_id 
 )

 or exists (select 'Y' from ISC_BOOK_SUM2_BKORD_F xx where xx.CUSTOMER_ID =  temp.party_id 
 )

 or exists (select 'Y' from ISC_BOOK_SUM2_F xx where xx.CUSTOMER_ID =  temp.party_id 
 )

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from ISC_FS_TASKS_F
 yy where yy.ADDRESS_ID=xx.PARTY_SITE_ID
))

 or exists (select 'Y' from ISC_FS_TASKS_F xx where xx.CUSTOMER_ID =  temp.party_id 
 );

Line: 2237


delete from hz_purge_gt temp where 


 exists (select 'Y' from ISC_BOOK_SUM2_PDUE_F xx where xx.CUSTOMER_ID =  temp.party_id 
 )

 or exists (select 'Y' from ISC_BOOK_SUM2_PDUE2_F xx where xx.CUSTOMER_ID =  temp.party_id 
 )

 or exists (select 'Y' from ISC_BOOK_SUM2_BKORD_F xx where xx.CUSTOMER_ID =  temp.party_id 
 )

 or exists (select 'Y' from ISC_BOOK_SUM2_F xx where xx.CUSTOMER_ID =  temp.party_id 
 )

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from ISC_FS_TASKS_F
 yy where yy.ADDRESS_ID=xx.PARTY_SITE_ID
))

 or exists (select 'Y' from ISC_FS_TASKS_F xx where xx.CUSTOMER_ID =  temp.party_id 
 );

Line: 2268


insert into hz_application_trans_gt(app_id,party_id) select 690, temp.party_id from hz_purge_gt temp where 


 exists (select 'Y' from JTF_TASKS_B xx where xx.CUSTOMER_ID =  temp.party_id 
 )

 or exists (select 'Y' from JTF_TASKS_B xx where xx.SOURCE_OBJECT_ID =  temp.party_id 
 and (SOURCE_OBJECT_TYPE_CODE in (select object_code from jtf_objects_b where ltrim(rtrim(upper(from_table))) = 'HZ_PARTIES' and rtrim(ltrim(upper(select_id))) = 'PARTY_ID')))

 or exists (select 'Y' from JTF_TASK_AUDITS_B xx where xx.NEW_CUSTOMER_ID =  temp.party_id 
 )

 or exists (select 'Y' from JTF_TASK_AUDITS_B xx where xx.OLD_CUSTOMER_ID =  temp.party_id 
 )

 or exists (select 'Y' from JTF_TASK_AUDITS_B xx where xx.NEW_SOURCE_OBJECT_ID =  temp.party_id 
 and (NEW_SOURCE_OBJECT_TYPE_CODE in (select object_code from jtf_objects_b where ltrim(rtrim(upper(from_table))) = 'HZ_PARTIES' and rtrim(ltrim(upper(select_id))) = 'PARTY_ID')))

 or exists (select 'Y' from JTF_TASK_AUDITS_B xx where xx.OLD_SOURCE_OBJECT_ID =  temp.party_id 
 and (OLD_SOURCE_OBJECT_TYPE_CODE in (select object_code from jtf_objects_b where ltrim(rtrim(upper(from_table))) = 'HZ_PARTIES' and rtrim(ltrim(upper(select_id))) = 'PARTY_ID')))

 or exists (select 'Y' from JTF_TASK_CONTACTS xx where xx.CONTACT_ID =  temp.party_id 
 and (CONTACT_TYPE_CODE = 'CUST'))

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from JTF_TASK_REFERENCES_B
 yy where yy.OBJECT_ID=xx.PARTY_SITE_ID
 and object_type_code in (select object_code from jtf_objects_b where ltrim(rtrim(upper(from_table))) = 'HZ_PARTY_SITES' and rtrim(ltrim(upper(select_id))) = 'PARTY_SITE_ID')))

 or exists (select 'Y' from JTF_TASK_REFERENCES_B xx where xx.OBJECT_ID =  temp.party_id 
 and (OBJECT_TYPE_CODE in (select object_code from jtf_objects_b where ltrim(rtrim(upper(from_table))) = 'HZ_PARTIES' and rtrim(ltrim(upper(select_id))) = 'PARTY_ID')))

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from JTF_TASKS_B
 yy where yy.ADDRESS_ID=xx.PARTY_SITE_ID
))

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from JTF_TASK_AUDITS_B
 yy where yy.NEW_ADDRESS_ID=xx.PARTY_SITE_ID
))

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from JTF_TASK_AUDITS_B
 yy where yy.OLD_ADDRESS_ID=xx.PARTY_SITE_ID
))

 or exists (select 'Y' from HZ_CONTACT_POINTS
 xx where xx.OWNER_TABLE_ID =  temp.party_id 
 and (OWNER_TABLE_NAME='HZ_PARTIES' AND nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from JTF_TASK_PHONES
 yy where yy.PHONE_ID=xx.CONTACT_POINT_ID
))
 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists 
 (select 'Y' from HZ_CONTACT_POINTS
 yy where yy.OWNER_TABLE_ID=xx.PARTY_SITE_ID 
 and OWNER_TABLE_NAME='HZ_PARTY_SITES' AND nvl(STATUS, 'A') in ('A','I')
 and exists 
 (select 'Y' from JTF_TASK_PHONES zz where zz.PHONE_ID = yy.CONTACT_POINT_ID )))

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists 
 (select 'Y' from HZ_ORG_CONTACTS
 yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID 
 and nvl(STATUS, 'A') in ('A','I')
 and exists 
 (select 'Y' from JTF_RS_RESOURCE_EXTNS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID and category in ('PARTY', 'PARTNER' ))))
 or exists (select 'Y' from HZ_RELATIONSHIPS
 xx where xx.OBJECT_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES'  AND object_table_name = 'HZ_PARTIES'
AND directional_flag = 'F')
 and exists 
 (select 'Y' from HZ_ORG_CONTACTS
 yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID 
 and nvl(STATUS, 'A') in ('A','I')
 and exists 
 (select 'Y' from JTF_RS_RESOURCE_EXTNS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID and category in ('PARTY', 'PARTNER' ))))
 or exists (select 'Y' from HZ_RELATIONSHIPS
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES'  AND object_table_name = 'HZ_PARTIES'
AND directional_flag = 'F')
 and exists 
 (select 'Y' from HZ_ORG_CONTACTS
 yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID 
 and nvl(STATUS, 'A') in ('A','I')
 and exists 
 (select 'Y' from JTF_RS_RESOURCE_EXTNS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID and category in ('PARTY', 'PARTNER' ))))
 or exists (select 'Y' from HZ_RELATIONSHIPS
 xx where xx.SUBJECT_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES'  AND object_table_name = 'HZ_PARTIES'
AND directional_flag = 'F')
 and exists 
 (select 'Y' from HZ_ORG_CONTACTS
 yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID 
 and nvl(STATUS, 'A') in ('A','I')
 and exists 
 (select 'Y' from JTF_RS_RESOURCE_EXTNS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID and category in ('PARTY', 'PARTNER' ))))

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from JTF_NOTES_B
 yy where yy.SOURCE_OBJECT_ID=xx.PARTY_SITE_ID
 and source_object_code  IN (SELECT ojt.object_code FROM jtf_objects_b ojt  ,jtf_object_usages oue WHERE ojt.object_code = oue.object_code AND oue.object_user_code = 'NOTES' and ojt.from_table ='HZ_PARTY_SITES')))

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from JTF_NOTE_CONTEXTS
 yy where yy.NOTE_CONTEXT_TYPE_ID=xx.PARTY_SITE_ID
 and NOTE_CONTEXT_TYPE  IN (SELECT ojt.object_code FROM jtf_objects_b ojt  ,jtf_object_usages oue WHERE ojt.object_code = oue.object_code AND oue.object_user_code = 'NOTES' and ojt.from_table ='HZ_PARTY_SITES')))

 or exists (select 'Y' from JTF_NOTES_B xx where xx.SOURCE_OBJECT_ID =  temp.party_id 
 and (source_object_code  IN (SELECT ojt.object_code FROM jtf_objects_b ojt  ,jtf_object_usages oue WHERE ojt.object_code = oue.object_code AND oue.object_user_code = 'NOTES' and ojt.from_table ='HZ_PARTIES' )))

 or exists (select 'Y' from JTF_NOTE_CONTEXTS xx where xx.NOTE_CONTEXT_TYPE_ID =  temp.party_id 
 and (NOTE_CONTEXT_TYPE  IN (SELECT ojt.object_code FROM jtf_objects_b ojt  ,jtf_object_usages oue WHERE ojt.object_code = oue.object_code AND oue.object_user_code = 'NOTES' and ojt.from_table ='HZ_PARTIES')))

 or exists (select 'Y' from JTF_IH_INTERACTIONS xx where xx.PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from JTF_RS_RESOURCE_EXTNS xx where xx.SOURCE_ID =  temp.party_id 
 and (category IN ( 'PARTY' , 'PARTNER')))

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from JTF_RS_RESOURCE_EXTNS
 yy where yy.ADDRESS_ID=xx.PARTY_SITE_ID
 and category  =   'PARTNER'))

 or exists (select 'Y' from JTF_UM_APPROVERS xx where xx.ORG_PARTY_ID =  temp.party_id 
 and (ROWNUM < 2))

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from JTF_TERR_VALUES_ALL
 yy where yy.LOW_VALUE_CHAR_ID=xx.PARTY_SITE_ID
 and TERR_QUAL_ID in ( select TERR_QUAL_ID from JTF_TERR_QUAL_ALL where QUAL_USG_ID in (-1511, -1435, -1078, -1064, -1063, -1037, -1014, -1002,  -1001))))

 or exists (select 'Y' from JTF_TERR_VALUES_ALL xx where xx.LOW_VALUE_CHAR_ID =  temp.party_id 
 and (TERR_QUAL_ID in ( select TERR_QUAL_ID from JTF_TERR_QUAL_ALL where QUAL_USG_ID in (-1511, -1435, -1078, -1064, -1063, -1037, -1014, -1002,  -1001))))

 or exists (select 'Y' from JTF_TASK_ASSIGNMENTS xx where xx.RESOURCE_ID =  temp.party_id 
 and (RESOURCE_TYPE_CODE  IN (SELECT object_code FROM jtf_objects_b WHERE LTRIM(RTRIM(UPPER(from_table))) = 'HZ_PARTIES' AND RTRIM(LTRIM(UPPER(select_id))) = 'PARTY_ID')))

 or exists (select 'Y' from JTF_PERZ_QUERY_PARAM xx where xx.PARAMETER_VALUE =  to_char(temp.party_id) 
 and (parameter_name = 'CUSTOMER_ID' AND query_id IN (SELECT q.query_id FROM  jtf_perz_query q, jtf_perz_query_param p WHERE q.query_type= 'JTF_TASK' AND q.application_id = 690 AND  p.query_id = q.query_id AND p.parameter_name = 'CUSTOMER' AND p.parameter_value = 'NAME')))

 or exists (select 'Y' from JTF_PERZ_QUERY_PARAM xx where xx.PARAMETER_VALUE =  to_char(temp.party_id) 
 and (parameter_name = 'CUSTOMER_ID' AND query_id IN (SELECT q.query_id FROM  jtf_perz_query q, jtf_perz_query_param p WHERE q.query_type= 'JTF_TASK' AND q.application_id = 690 AND  p.query_id = q.query_id AND p.parameter_name = 'CUSTOMER' AND p.parameter_value = 'NUMBER')))

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from JTF_RS_RESOURCE_EXTNS
 yy where yy.SUPPORT_SITE_ID=xx.PARTY_SITE_ID
))

 or exists (select 'Y' from JTF_TTY_NAMED_ACCTS xx where xx.PARTY_ID =  temp.party_id 
 );

Line: 2454


delete from hz_purge_gt temp where 


 exists (select 'Y' from JTF_TASKS_B xx where xx.CUSTOMER_ID =  temp.party_id 
 )

 or exists (select 'Y' from JTF_TASKS_B xx where xx.SOURCE_OBJECT_ID =  temp.party_id 
 and (SOURCE_OBJECT_TYPE_CODE in (select object_code from jtf_objects_b where ltrim(rtrim(upper(from_table))) = 'HZ_PARTIES' and rtrim(ltrim(upper(select_id))) = 'PARTY_ID')))

 or exists (select 'Y' from JTF_TASK_AUDITS_B xx where xx.NEW_CUSTOMER_ID =  temp.party_id 
 )

 or exists (select 'Y' from JTF_TASK_AUDITS_B xx where xx.OLD_CUSTOMER_ID =  temp.party_id 
 )

 or exists (select 'Y' from JTF_TASK_AUDITS_B xx where xx.NEW_SOURCE_OBJECT_ID =  temp.party_id 
 and (NEW_SOURCE_OBJECT_TYPE_CODE in (select object_code from jtf_objects_b where ltrim(rtrim(upper(from_table))) = 'HZ_PARTIES' and rtrim(ltrim(upper(select_id))) = 'PARTY_ID')))

 or exists (select 'Y' from JTF_TASK_AUDITS_B xx where xx.OLD_SOURCE_OBJECT_ID =  temp.party_id 
 and (OLD_SOURCE_OBJECT_TYPE_CODE in (select object_code from jtf_objects_b where ltrim(rtrim(upper(from_table))) = 'HZ_PARTIES' and rtrim(ltrim(upper(select_id))) = 'PARTY_ID')))

 or exists (select 'Y' from JTF_TASK_CONTACTS xx where xx.CONTACT_ID =  temp.party_id 
 and (CONTACT_TYPE_CODE = 'CUST'))

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from JTF_TASK_REFERENCES_B
 yy where yy.OBJECT_ID=xx.PARTY_SITE_ID
 and object_type_code in (select object_code from jtf_objects_b where ltrim(rtrim(upper(from_table))) = 'HZ_PARTY_SITES' and rtrim(ltrim(upper(select_id))) = 'PARTY_SITE_ID')))

 or exists (select 'Y' from JTF_TASK_REFERENCES_B xx where xx.OBJECT_ID =  temp.party_id 
 and (OBJECT_TYPE_CODE in (select object_code from jtf_objects_b where ltrim(rtrim(upper(from_table))) = 'HZ_PARTIES' and rtrim(ltrim(upper(select_id))) = 'PARTY_ID')))

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from JTF_TASKS_B
 yy where yy.ADDRESS_ID=xx.PARTY_SITE_ID
))

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from JTF_TASK_AUDITS_B
 yy where yy.NEW_ADDRESS_ID=xx.PARTY_SITE_ID
))

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from JTF_TASK_AUDITS_B
 yy where yy.OLD_ADDRESS_ID=xx.PARTY_SITE_ID
))

 or exists (select 'Y' from HZ_CONTACT_POINTS
 xx where xx.OWNER_TABLE_ID =  temp.party_id 
 and (OWNER_TABLE_NAME='HZ_PARTIES' AND nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from JTF_TASK_PHONES
 yy where yy.PHONE_ID=xx.CONTACT_POINT_ID
))
 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists 
 (select 'Y' from HZ_CONTACT_POINTS
 yy where yy.OWNER_TABLE_ID=xx.PARTY_SITE_ID 
 and OWNER_TABLE_NAME='HZ_PARTY_SITES' AND nvl(STATUS, 'A') in ('A','I')
 and exists 
 (select 'Y' from JTF_TASK_PHONES zz where zz.PHONE_ID = yy.CONTACT_POINT_ID )))

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists 
 (select 'Y' from HZ_ORG_CONTACTS
 yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID 
 and nvl(STATUS, 'A') in ('A','I')
 and exists 
 (select 'Y' from JTF_RS_RESOURCE_EXTNS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID and category in ('PARTY', 'PARTNER' ))))
 or exists (select 'Y' from HZ_RELATIONSHIPS
 xx where xx.OBJECT_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES'  AND object_table_name = 'HZ_PARTIES'
AND directional_flag = 'F')
 and exists 
 (select 'Y' from HZ_ORG_CONTACTS
 yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID 
 and nvl(STATUS, 'A') in ('A','I')
 and exists 
 (select 'Y' from JTF_RS_RESOURCE_EXTNS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID and category in ('PARTY', 'PARTNER' ))))
 or exists (select 'Y' from HZ_RELATIONSHIPS
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES'  AND object_table_name = 'HZ_PARTIES'
AND directional_flag = 'F')
 and exists 
 (select 'Y' from HZ_ORG_CONTACTS
 yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID 
 and nvl(STATUS, 'A') in ('A','I')
 and exists 
 (select 'Y' from JTF_RS_RESOURCE_EXTNS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID and category in ('PARTY', 'PARTNER' ))))
 or exists (select 'Y' from HZ_RELATIONSHIPS
 xx where xx.SUBJECT_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I') AND subject_table_name = 'HZ_PARTIES'  AND object_table_name = 'HZ_PARTIES'
AND directional_flag = 'F')
 and exists 
 (select 'Y' from HZ_ORG_CONTACTS
 yy where yy.PARTY_RELATIONSHIP_ID=xx.RELATIONSHIP_ID 
 and nvl(STATUS, 'A') in ('A','I')
 and exists 
 (select 'Y' from JTF_RS_RESOURCE_EXTNS zz where zz.CONTACT_ID = yy.ORG_CONTACT_ID and category in ('PARTY', 'PARTNER' ))))

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from JTF_NOTES_B
 yy where yy.SOURCE_OBJECT_ID=xx.PARTY_SITE_ID
 and source_object_code  IN (SELECT ojt.object_code FROM jtf_objects_b ojt  ,jtf_object_usages oue WHERE ojt.object_code = oue.object_code AND oue.object_user_code = 'NOTES' and ojt.from_table ='HZ_PARTY_SITES')))

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from JTF_NOTE_CONTEXTS
 yy where yy.NOTE_CONTEXT_TYPE_ID=xx.PARTY_SITE_ID
 and NOTE_CONTEXT_TYPE  IN (SELECT ojt.object_code FROM jtf_objects_b ojt  ,jtf_object_usages oue WHERE ojt.object_code = oue.object_code AND oue.object_user_code = 'NOTES' and ojt.from_table ='HZ_PARTY_SITES')))

 or exists (select 'Y' from JTF_NOTES_B xx where xx.SOURCE_OBJECT_ID =  temp.party_id 
 and (source_object_code  IN (SELECT ojt.object_code FROM jtf_objects_b ojt  ,jtf_object_usages oue WHERE ojt.object_code = oue.object_code AND oue.object_user_code = 'NOTES' and ojt.from_table ='HZ_PARTIES' )))

 or exists (select 'Y' from JTF_NOTE_CONTEXTS xx where xx.NOTE_CONTEXT_TYPE_ID =  temp.party_id 
 and (NOTE_CONTEXT_TYPE  IN (SELECT ojt.object_code FROM jtf_objects_b ojt  ,jtf_object_usages oue WHERE ojt.object_code = oue.object_code AND oue.object_user_code = 'NOTES' and ojt.from_table ='HZ_PARTIES')))

 or exists (select 'Y' from JTF_IH_INTERACTIONS xx where xx.PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from JTF_RS_RESOURCE_EXTNS xx where xx.SOURCE_ID =  temp.party_id 
 and (category IN ( 'PARTY' , 'PARTNER')))

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from JTF_RS_RESOURCE_EXTNS
 yy where yy.ADDRESS_ID=xx.PARTY_SITE_ID
 and category  =   'PARTNER'))

 or exists (select 'Y' from JTF_UM_APPROVERS xx where xx.ORG_PARTY_ID =  temp.party_id 
 and (ROWNUM < 2))

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from JTF_TERR_VALUES_ALL
 yy where yy.LOW_VALUE_CHAR_ID=xx.PARTY_SITE_ID
 and TERR_QUAL_ID in ( select TERR_QUAL_ID from JTF_TERR_QUAL_ALL where QUAL_USG_ID in (-1511, -1435, -1078, -1064, -1063, -1037, -1014, -1002,  -1001))))

 or exists (select 'Y' from JTF_TERR_VALUES_ALL xx where xx.LOW_VALUE_CHAR_ID =  temp.party_id 
 and (TERR_QUAL_ID in ( select TERR_QUAL_ID from JTF_TERR_QUAL_ALL where QUAL_USG_ID in (-1511, -1435, -1078, -1064, -1063, -1037, -1014, -1002,  -1001))))

 or exists (select 'Y' from JTF_TASK_ASSIGNMENTS xx where xx.RESOURCE_ID =  temp.party_id 
 and (RESOURCE_TYPE_CODE  IN (SELECT object_code FROM jtf_objects_b WHERE LTRIM(RTRIM(UPPER(from_table))) = 'HZ_PARTIES' AND RTRIM(LTRIM(UPPER(select_id))) = 'PARTY_ID')))

 or exists (select 'Y' from JTF_PERZ_QUERY_PARAM xx where xx.PARAMETER_VALUE =  to_char(temp.party_id) 
 and (parameter_name = 'CUSTOMER_ID' AND query_id IN (SELECT q.query_id FROM  jtf_perz_query q, jtf_perz_query_param p WHERE q.query_type= 'JTF_TASK' AND q.application_id = 690 AND  p.query_id = q.query_id AND p.parameter_name = 'CUSTOMER' AND p.parameter_value = 'NAME')))

 or exists (select 'Y' from JTF_PERZ_QUERY_PARAM xx where xx.PARAMETER_VALUE =  to_char(temp.party_id) 
 and (parameter_name = 'CUSTOMER_ID' AND query_id IN (SELECT q.query_id FROM  jtf_perz_query q, jtf_perz_query_param p WHERE q.query_type= 'JTF_TASK' AND q.application_id = 690 AND  p.query_id = q.query_id AND p.parameter_name = 'CUSTOMER' AND p.parameter_value = 'NUMBER')))

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from JTF_RS_RESOURCE_EXTNS
 yy where yy.SUPPORT_SITE_ID=xx.PARTY_SITE_ID
))

 or exists (select 'Y' from JTF_TTY_NAMED_ACCTS xx where xx.PARTY_ID =  temp.party_id 
 );

Line: 2645


insert into hz_application_trans_gt(app_id,party_id) select 515, temp.party_id from hz_purge_gt temp where 


 exists (select 'Y' from OKS_BILLING_PROFILES_B xx where xx.OWNED_PARTY_ID1 =  to_char(temp.party_id) 
 )

 or exists (select 'Y' from OKS_K_DEFAULTS xx where xx.SEGMENT_ID1 =  to_char(temp.party_id) 
 and (JTOT_OBJECT_CODE = 'OKX_PARTY'))

 or exists (select 'Y' from OKS_SERV_AVAIL_EXCEPTS xx where xx.OBJECT1_ID1 =  to_char(temp.party_id) 
 and (JTOT_OBJECT1_CODE = 'OKX_PARTY'));

Line: 2657


delete from hz_purge_gt temp where 


 exists (select 'Y' from OKS_BILLING_PROFILES_B xx where xx.OWNED_PARTY_ID1 =  to_char(temp.party_id) 
 )

 or exists (select 'Y' from OKS_K_DEFAULTS xx where xx.SEGMENT_ID1 =  to_char(temp.party_id) 
 and (JTOT_OBJECT_CODE = 'OKX_PARTY'))

 or exists (select 'Y' from OKS_SERV_AVAIL_EXCEPTS xx where xx.OBJECT1_ID1 =  to_char(temp.party_id) 
 and (JTOT_OBJECT1_CODE = 'OKX_PARTY'));

Line: 2674


insert into hz_application_trans_gt(app_id,party_id) select 0, temp.party_id from hz_purge_gt temp where 


 exists (select 'Y' from FND_USER xx where xx.CUSTOMER_ID =  temp.party_id 
 )

 or exists (select 'Y' from FND_USER xx where xx.PERSON_PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from UMX_REG_REQUESTS xx where xx.REQUESTED_FOR_PARTY_ID =  temp.party_id 
 and (ROWNUM < 2));

Line: 2686


delete from hz_purge_gt temp where 


 exists (select 'Y' from FND_USER xx where xx.CUSTOMER_ID =  temp.party_id 
 )

 or exists (select 'Y' from FND_USER xx where xx.PERSON_PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from UMX_REG_REQUESTS xx where xx.REQUESTED_FOR_PARTY_ID =  temp.party_id 
 and (ROWNUM < 2));

Line: 2703


insert into hz_application_trans_gt(app_id,party_id) select 170, temp.party_id from hz_purge_gt temp where 


 exists (select 'Y' from CS_INCIDENTS_ALL_B xx where xx.CUSTOMER_ID =  temp.party_id 
 )

 or exists (select 'Y' from CS_HZ_SR_CONTACT_POINTS xx where xx.PARTY_ID =  temp.party_id 
 and (CONTACT_TYPE <> 'EMPLOYEE'))

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from CS_ESTIMATE_DETAILS
 yy where yy.INVOICE_TO_ORG_ID=xx.PARTY_SITE_ID
))

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from CS_ESTIMATE_DETAILS
 yy where yy.SHIP_TO_ORG_ID=xx.PARTY_SITE_ID
));

Line: 2728


delete from hz_purge_gt temp where 


 exists (select 'Y' from CS_INCIDENTS_ALL_B xx where xx.CUSTOMER_ID =  temp.party_id 
 )

 or exists (select 'Y' from CS_HZ_SR_CONTACT_POINTS xx where xx.PARTY_ID =  temp.party_id 
 and (CONTACT_TYPE <> 'EMPLOYEE'))

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from CS_ESTIMATE_DETAILS
 yy where yy.INVOICE_TO_ORG_ID=xx.PARTY_SITE_ID
))

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from CS_ESTIMATE_DETAILS
 yy where yy.SHIP_TO_ORG_ID=xx.PARTY_SITE_ID
));

Line: 2758


insert into hz_application_trans_gt(app_id,party_id) select 660, temp.party_id from hz_purge_gt temp where 


 exists (select 'Y' from OE_PRICE_ADJ_ATTRIBS xx where xx.PRICING_ATTR_VALUE_FROM =  to_char(temp.party_id) 
 and (pricing_context = 'ASOPARTYINFO'  AND pricing_attribute = 'QUALIFIER_ATTRIBUTE1'  OR pricing_context = 'CUSTOMER' AND pricing_attribute ='QUALIFIER_ATTRIBUTE16'  OR pricing_context = 'CUSTOMER_GROUP' AND pricing_attribute = 'QUALIFIER_ATTRIBUTE3'  OR pricing_context = 'PARTY' AND pricing_attribute IN ('QUALIFIER_ATTRIBUTE1', 'QUALIFIER_ATTRIBUTE2')))

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from OE_PRICE_ADJ_ATTRIBS
 yy where yy.PRICING_ATTR_VALUE_FROM=to_char(xx.PARTY_SITE_ID)
 and pricing_context = 'ASOPARTYINFO'  AND pricing_attribute IN ('QUALIFIER_ATTRIBUTE10','QUALIFIER_ATTRIBUTE11')  OR pricing_context = 'CUSTOMER' AND pricing_attribute IN ('QUALIFIER_ATTRIBUTE17', 'QUALIFIER_ATTRIBUTE18')));

Line: 2772


delete from hz_purge_gt temp where 


 exists (select 'Y' from OE_PRICE_ADJ_ATTRIBS xx where xx.PRICING_ATTR_VALUE_FROM =  to_char(temp.party_id) 
 and (pricing_context = 'ASOPARTYINFO'  AND pricing_attribute = 'QUALIFIER_ATTRIBUTE1'  OR pricing_context = 'CUSTOMER' AND pricing_attribute ='QUALIFIER_ATTRIBUTE16'  OR pricing_context = 'CUSTOMER_GROUP' AND pricing_attribute = 'QUALIFIER_ATTRIBUTE3'  OR pricing_context = 'PARTY' AND pricing_attribute IN ('QUALIFIER_ATTRIBUTE1', 'QUALIFIER_ATTRIBUTE2')))

 or exists (select 'Y' from HZ_PARTY_SITES
 xx where xx.PARTY_ID =  temp.party_id 
 and (nvl(STATUS, 'A') in ('A','I'))
 and exists
(select 'Y' from OE_PRICE_ADJ_ATTRIBS
 yy where yy.PRICING_ATTR_VALUE_FROM=to_char(xx.PARTY_SITE_ID)
 and pricing_context = 'ASOPARTYINFO'  AND pricing_attribute IN ('QUALIFIER_ATTRIBUTE10','QUALIFIER_ATTRIBUTE11')  OR pricing_context = 'CUSTOMER' AND pricing_attribute IN ('QUALIFIER_ATTRIBUTE17', 'QUALIFIER_ATTRIBUTE18')));

Line: 2791


insert into hz_application_trans_gt(app_id,party_id) select 800, temp.party_id from hz_purge_gt temp where 


 exists (select 'Y' from PER_ALL_PEOPLE_F xx where xx.PARTY_ID =  temp.party_id 
 and (effective_end_date = to_date('12/31/4712','MM/DD/YYYY')));

Line: 2797


delete from hz_purge_gt temp where 


 exists (select 'Y' from PER_ALL_PEOPLE_F xx where xx.PARTY_ID =  temp.party_id 
 and (effective_end_date = to_date('12/31/4712','MM/DD/YYYY')));

Line: 2808


insert into hz_application_trans_gt(app_id,party_id) select 174, temp.party_id from hz_purge_gt temp where 


 exists (select 'Y' from ECX_TP_HEADERS xx where xx.PARTY_ID =  temp.party_id 
 );

Line: 2814


delete from hz_purge_gt temp where 


 exists (select 'Y' from ECX_TP_HEADERS xx where xx.PARTY_ID =  temp.party_id 
 );

Line: 2825


insert into hz_application_trans_gt(app_id,party_id) select 204, temp.party_id from hz_purge_gt temp where 


 exists (select 'Y' from XLE_ENTITY_PROFILES xx where xx.PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from XLE_ETB_PROFILES xx where xx.PARTY_ID =  temp.party_id 
 );

Line: 2834


delete from hz_purge_gt temp where 


 exists (select 'Y' from XLE_ENTITY_PROFILES xx where xx.PARTY_ID =  temp.party_id 
 )

 or exists (select 'Y' from XLE_ETB_PROFILES xx where xx.PARTY_ID =  temp.party_id 
 );

Line: 2848


insert into hz_application_trans_gt(app_id,party_id) select 666, temp.party_id from hz_purge_gt temp where 


 exists (select 'Y' from IBW_SITE_VISITS xx where xx.PARTY_ID =  temp.party_id 
 );

Line: 2854


delete from hz_purge_gt temp where 


 exists (select 'Y' from IBW_SITE_VISITS xx where xx.PARTY_ID =  temp.party_id 
 );

Line: 2865


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 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.PARTY_ID from IGW_PROP_LOCATIONS xx 
 );

Line: 2870


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.PARTY_ID from IGW_PROP_LOCATIONS xx 
 );

Line: 2877


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 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.PARTY_ID from IGW_PERSON_DEGREES xx 
 );

Line: 2882


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.PARTY_ID from IGW_PERSON_DEGREES xx 
 );

Line: 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 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.PARTY_ID from IGW_PERSON_BIOSKETCH xx 
 );

Line: 2894


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.PARTY_ID from IGW_PERSON_BIOSKETCH xx 
 );

Line: 2901


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 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.ORG_PARTY_ID from IGW_PROP_PERSONS_TCA_V xx 
 );

Line: 2906


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.ORG_PARTY_ID from IGW_PROP_PERSONS_TCA_V xx 
 );

Line: 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 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.LOCATION_PARTY_ID from IGW_PROP_PERSON_SUPPORT xx 
 );

Line: 2918


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.LOCATION_PARTY_ID from IGW_PROP_PERSON_SUPPORT xx 
 );

Line: 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 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.PI_PARTY_ID from IGW_PROP_PERSON_SUPPORT xx 
 );

Line: 2930


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.PI_PARTY_ID from IGW_PROP_PERSON_SUPPORT xx 
 );

Line: 2937


insert into hz_application_trans_gt(app_id,party_id) select 665, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 665 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
 xx 
 where (nvl(STATUS, 'A') in ('A','I'))
 and  xx.PARTY_SITE_ID 
 in (select /*+ parallel(yy)*/ yy.PARTY_SITE_ID from WSH_PARTY_SITES_V
 yy 
));

Line: 2947


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
 xx 
 where (nvl(STATUS, 'A') in ('A','I'))
 and  xx.PARTY_SITE_ID 
 in (select /*+ parallel(yy)*/ yy.PARTY_SITE_ID from WSH_PARTY_SITES_V
 yy 
));

Line: 2959


insert into hz_application_trans_gt(app_id,party_id) select 8406, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 8406 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.PERSON_ID from IGF_AP_FA_BASE_REC_ALL xx 
 );

Line: 2964


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.PERSON_ID from IGF_AP_FA_BASE_REC_ALL xx 
 );

Line: 2971


insert into hz_application_trans_gt(app_id,party_id) select 8406, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 8406 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.PARTY_ID from IGF_AW_FUND_MAST_ALL xx 
 );

Line: 2976


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.PARTY_ID from IGF_AW_FUND_MAST_ALL xx 
 );

Line: 2983


insert into hz_application_trans_gt(app_id,party_id) select 222, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 222 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.OWNER_TABLE_ID from HZ_CODE_ASSIGNMENTS xx 
 where (OWNER_TABLE_NAME='HZ_PARTIES' AND nvl(STATUS, 'A') in ('A','I')));

Line: 2988


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.OWNER_TABLE_ID from HZ_CODE_ASSIGNMENTS xx 
 where (OWNER_TABLE_NAME='HZ_PARTIES' AND nvl(STATUS, 'A') in ('A','I')));

Line: 2995


insert into hz_application_trans_gt(app_id,party_id) select 222, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 222 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
 xx 
 where (nvl(STATUS, 'A') in ('A','I'))
 and  xx.PARTY_SITE_ID 
 in (select /*+ parallel(yy)*/ yy.OWNER_TABLE_ID from HZ_CODE_ASSIGNMENTS
 yy 
 where OWNER_TABLE_NAME='HZ_PARTY_SITES' AND nvl(STATUS, 'A') in ('A','I')));

Line: 3005


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
 xx 
 where (nvl(STATUS, 'A') in ('A','I'))
 and  xx.PARTY_SITE_ID 
 in (select /*+ parallel(yy)*/ yy.OWNER_TABLE_ID from HZ_CODE_ASSIGNMENTS
 yy 
 where OWNER_TABLE_NAME='HZ_PARTY_SITES' AND nvl(STATUS, 'A') in ('A','I')));

Line: 3017


insert into hz_application_trans_gt(app_id,party_id) select 222, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 222 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_EMPLOYMENT_HISTORY
 xx 
 where (nvl(STATUS, 'A') in ('A','I'))
 and  xx.EMPLOYMENT_HISTORY_ID 
 in (select /*+ parallel(yy)*/ yy.EMPLOYMENT_HISTORY_ID from HZ_WORK_CLASS
 yy 
 where nvl(STATUS, 'A') in ('A','I')))
 or  temp.party_id  in (select /*+ parallel (xx)*/ xx.EMPLOYED_BY_PARTY_ID from HZ_EMPLOYMENT_HISTORY
 xx 
 where (nvl(STATUS,'A') in ('A','I'))
 and  xx.EMPLOYMENT_HISTORY_ID 
 in (select /*+ parallel(yy)*/ yy.EMPLOYMENT_HISTORY_ID from HZ_WORK_CLASS
 yy 
 where nvl(STATUS, 'A') in ('A','I')));

Line: 3034


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_EMPLOYMENT_HISTORY
 xx 
 where (nvl(STATUS, 'A') in ('A','I'))
 and  xx.EMPLOYMENT_HISTORY_ID 
 in (select /*+ parallel(yy)*/ yy.EMPLOYMENT_HISTORY_ID from HZ_WORK_CLASS
 yy 
 where nvl(STATUS, 'A') in ('A','I')))
 or  temp.party_id  in (select /*+ parallel (xx)*/ xx.EMPLOYED_BY_PARTY_ID from HZ_EMPLOYMENT_HISTORY
 xx 
 where (nvl(STATUS,'A') in ('A','I'))
 and  xx.EMPLOYMENT_HISTORY_ID 
 in (select /*+ parallel(yy)*/ yy.EMPLOYMENT_HISTORY_ID from HZ_WORK_CLASS
 yy 
 where nvl(STATUS, 'A') in ('A','I')));

Line: 3053


insert into hz_application_trans_gt(app_id,party_id) select 222, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 222 and appl.party_id=temp.party_id) and 

 to_char(temp.party_id)  in (select /*+ parallel(xx)*/ xx.PK1_VALUE from FND_ATTACHED_DOCUMENTS xx 
 where (entity_name = 'HZ_PARTIES'));

Line: 3058


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 to_char(temp.party_id)  in (select /*+ parallel(xx)*/ xx.PK1_VALUE from FND_ATTACHED_DOCUMENTS xx 
 where (entity_name = 'HZ_PARTIES'));

Line: 3065


insert into hz_application_trans_gt(app_id,party_id) select 222, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 222 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.PARTY_ID from HZ_EMAIL_DOMAINS xx 
 );

Line: 3070


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.PARTY_ID from HZ_EMAIL_DOMAINS xx 
 );

Line: 3077


insert into hz_application_trans_gt(app_id,party_id) select 671, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 671 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.PARTY_ID from IBE_SH_QUOTE_ACCESS xx 
 );

Line: 3082


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.PARTY_ID from IBE_SH_QUOTE_ACCESS xx 
 );

Line: 3089


insert into hz_application_trans_gt(app_id,party_id) select 671, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 671 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.PARTY_ID from IBE_ACTIVE_QUOTES_ALL xx 
 );

Line: 3094


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.PARTY_ID from IBE_ACTIVE_QUOTES_ALL xx 
 );

Line: 3101


insert into hz_application_trans_gt(app_id,party_id) select 682, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 682 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.BROKER_ID from OZF_CLAIMS_HISTORY_ALL xx 
 );

Line: 3106


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.BROKER_ID from OZF_CLAIMS_HISTORY_ALL xx 
 );

Line: 3113


insert into hz_application_trans_gt(app_id,party_id) select 682, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 682 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.CONTACT_ID from OZF_CLAIMS_HISTORY_ALL xx 
 );

Line: 3118


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.CONTACT_ID from OZF_CLAIMS_HISTORY_ALL xx 
 );

Line: 3125


insert into hz_application_trans_gt(app_id,party_id) select 682, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 682 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.SHIP_FROM_CONTACT_PARTY_ID from OZF_RESALE_LINES_INT_ALL xx 
 );

Line: 3130


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.SHIP_FROM_CONTACT_PARTY_ID from OZF_RESALE_LINES_INT_ALL xx 
 );

Line: 3137


insert into hz_application_trans_gt(app_id,party_id) select 682, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 682 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.SOLD_FROM_CONTACT_PARTY_ID from OZF_RESALE_LINES_INT_ALL xx 
 );

Line: 3142


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.SOLD_FROM_CONTACT_PARTY_ID from OZF_RESALE_LINES_INT_ALL xx 
 );

Line: 3149


insert into hz_application_trans_gt(app_id,party_id) select 682, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 682 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.BILL_TO_PARTY_ID from OZF_RESALE_LINES_INT_ALL xx 
 );

Line: 3154


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.BILL_TO_PARTY_ID from OZF_RESALE_LINES_INT_ALL xx 
 );

Line: 3161


insert into hz_application_trans_gt(app_id,party_id) select 682, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 682 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.BILL_TO_CONTACT_PARTY_ID from OZF_RESALE_LINES_INT_ALL xx 
 );

Line: 3166


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.BILL_TO_CONTACT_PARTY_ID from OZF_RESALE_LINES_INT_ALL xx 
 );

Line: 3173


insert into hz_application_trans_gt(app_id,party_id) select 682, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 682 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.SHIP_TO_PARTY_ID from OZF_RESALE_LINES_INT_ALL xx 
 );

Line: 3178


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.SHIP_TO_PARTY_ID from OZF_RESALE_LINES_INT_ALL xx 
 );

Line: 3185


insert into hz_application_trans_gt(app_id,party_id) select 682, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 682 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.SHIP_TO_CONTACT_PARTY_ID from OZF_RESALE_LINES_INT_ALL xx 
 );

Line: 3190


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.SHIP_TO_CONTACT_PARTY_ID from OZF_RESALE_LINES_INT_ALL xx 
 );

Line: 3197


insert into hz_application_trans_gt(app_id,party_id) select 682, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 682 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.END_CUST_PARTY_ID from OZF_RESALE_LINES_INT_ALL xx 
 );

Line: 3202


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.END_CUST_PARTY_ID from OZF_RESALE_LINES_INT_ALL xx 
 );

Line: 3209


insert into hz_application_trans_gt(app_id,party_id) select 682, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 682 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.END_CUST_CONTACT_PARTY_ID from OZF_RESALE_LINES_INT_ALL xx 
 );

Line: 3214


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.END_CUST_CONTACT_PARTY_ID from OZF_RESALE_LINES_INT_ALL xx 
 );

Line: 3221


insert into hz_application_trans_gt(app_id,party_id) select 682, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 682 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.BILL_TO_PARTY_ID from OZF_RESALE_HEADERS_ALL xx 
 );

Line: 3226


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.BILL_TO_PARTY_ID from OZF_RESALE_HEADERS_ALL xx 
 );

Line: 3233


insert into hz_application_trans_gt(app_id,party_id) select 682, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 682 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.BILL_TO_CONTACT_PARTY_ID from OZF_RESALE_HEADERS_ALL xx 
 );

Line: 3238


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.BILL_TO_CONTACT_PARTY_ID from OZF_RESALE_HEADERS_ALL xx 
 );

Line: 3245


insert into hz_application_trans_gt(app_id,party_id) select 682, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 682 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.SHIP_TO_PARTY_ID from OZF_RESALE_HEADERS_ALL xx 
 );

Line: 3250


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.SHIP_TO_PARTY_ID from OZF_RESALE_HEADERS_ALL xx 
 );

Line: 3257


insert into hz_application_trans_gt(app_id,party_id) select 682, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 682 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.SHIP_TO_CONTACT_PARTY_ID from OZF_RESALE_HEADERS_ALL xx 
 );

Line: 3262


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.SHIP_TO_CONTACT_PARTY_ID from OZF_RESALE_HEADERS_ALL xx 
 );

Line: 3269


insert into hz_application_trans_gt(app_id,party_id) select 682, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 682 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.SHIP_FROM_CONTACT_PARTY_ID from OZF_RESALE_LINES_ALL xx 
 );

Line: 3274


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.SHIP_FROM_CONTACT_PARTY_ID from OZF_RESALE_LINES_ALL xx 
 );

Line: 3281


insert into hz_application_trans_gt(app_id,party_id) select 682, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 682 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.SOLD_FROM_CONTACT_PARTY_ID from OZF_RESALE_LINES_ALL xx 
 );

Line: 3286


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.SOLD_FROM_CONTACT_PARTY_ID from OZF_RESALE_LINES_ALL xx 
 );

Line: 3293


insert into hz_application_trans_gt(app_id,party_id) select 682, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 682 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.BILL_TO_PARTY_ID from OZF_RESALE_LINES_ALL xx 
 );

Line: 3298


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.BILL_TO_PARTY_ID from OZF_RESALE_LINES_ALL xx 
 );

Line: 3305


insert into hz_application_trans_gt(app_id,party_id) select 682, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 682 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.BILL_TO_CONTACT_PARTY_ID from OZF_RESALE_LINES_ALL xx 
 );

Line: 3310


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.BILL_TO_CONTACT_PARTY_ID from OZF_RESALE_LINES_ALL xx 
 );

Line: 3317


insert into hz_application_trans_gt(app_id,party_id) select 682, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 682 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.SHIP_TO_PARTY_ID from OZF_RESALE_LINES_ALL xx 
 );

Line: 3322


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.SHIP_TO_PARTY_ID from OZF_RESALE_LINES_ALL xx 
 );

Line: 3329


insert into hz_application_trans_gt(app_id,party_id) select 682, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 682 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.SHIP_TO_CONTACT_PARTY_ID from OZF_RESALE_LINES_ALL xx 
 );

Line: 3334


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.SHIP_TO_CONTACT_PARTY_ID from OZF_RESALE_LINES_ALL xx 
 );

Line: 3341


insert into hz_application_trans_gt(app_id,party_id) select 682, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 682 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.END_CUST_PARTY_ID from OZF_RESALE_LINES_ALL xx 
 );

Line: 3346


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.END_CUST_PARTY_ID from OZF_RESALE_LINES_ALL xx 
 );

Line: 3353


insert into hz_application_trans_gt(app_id,party_id) select 682, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 682 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.END_CUST_CONTACT_PARTY_ID from OZF_RESALE_LINES_ALL xx 
 );

Line: 3358


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.END_CUST_CONTACT_PARTY_ID from OZF_RESALE_LINES_ALL xx 
 );

Line: 3365


insert into hz_application_trans_gt(app_id,party_id) select 682, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 682 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.END_CUST_PARTY_ID from OZF_REQUEST_HEADERS_ALL_B xx 
 );

Line: 3370


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.END_CUST_PARTY_ID from OZF_REQUEST_HEADERS_ALL_B xx 
 );

Line: 3377


insert into hz_application_trans_gt(app_id,party_id) select 682, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 682 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.RESELLER_PARTY_ID from OZF_REQUEST_HEADERS_ALL_B xx 
 );

Line: 3382


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.RESELLER_PARTY_ID from OZF_REQUEST_HEADERS_ALL_B xx 
 );

Line: 3389


insert into hz_application_trans_gt(app_id,party_id) select 682, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 682 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.AUTOPAY_PARTY_ID from OZF_OFFERS xx 
 );

Line: 3394


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.AUTOPAY_PARTY_ID from OZF_OFFERS xx 
 );

Line: 3401


insert into hz_application_trans_gt(app_id,party_id) select 682, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 682 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.PARTY_ID from OZF_ACTIVITY_CUSTOMERS xx 
 );

Line: 3406


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.PARTY_ID from OZF_ACTIVITY_CUSTOMERS xx 
 );

Line: 3413


insert into hz_application_trans_gt(app_id,party_id) select 682, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 682 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.BUY_GROUP_PARTY_ID from OZF_CLAIM_LINES_HIST_ALL xx 
 );

Line: 3418


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.BUY_GROUP_PARTY_ID from OZF_CLAIM_LINES_HIST_ALL xx 
 );

Line: 3425


insert into hz_application_trans_gt(app_id,party_id) select 682, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 682 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.PARTNER_CONTACT_PARTY_ID from OZF_RESALE_BATCHES_ALL xx 
 );

Line: 3430


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.PARTNER_CONTACT_PARTY_ID from OZF_RESALE_BATCHES_ALL xx 
 );

Line: 3437


insert into hz_application_trans_gt(app_id,party_id) select 682, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 682 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.BUY_GROUP_PARTY_ID from OZF_CLAIM_LINES_ALL xx 
 );

Line: 3442


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.BUY_GROUP_PARTY_ID from OZF_CLAIM_LINES_ALL xx 
 );

Line: 3449


insert into hz_application_trans_gt(app_id,party_id) select 682, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 682 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.PARENT_PARTY_ID from OZF_ACCOUNT_ALLOCATIONS xx 
 );

Line: 3454


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.PARENT_PARTY_ID from OZF_ACCOUNT_ALLOCATIONS xx 
 );

Line: 3461


insert into hz_application_trans_gt(app_id,party_id) select 682, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 682 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.ROLLUP_PARTY_ID from OZF_ACCOUNT_ALLOCATIONS xx 
 );

Line: 3466


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.ROLLUP_PARTY_ID from OZF_ACCOUNT_ALLOCATIONS xx 
 );

Line: 3473


insert into hz_application_trans_gt(app_id,party_id) select 435, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 435 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.INITIATOR_ID from FUN_TRX_BATCHES xx 
 );

Line: 3478


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.INITIATOR_ID from FUN_TRX_BATCHES xx 
 );

Line: 3485


insert into hz_application_trans_gt(app_id,party_id) select 435, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 435 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.RECIPIENT_ID from FUN_TRX_HEADERS xx 
 );

Line: 3490


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.RECIPIENT_ID from FUN_TRX_HEADERS xx 
 );

Line: 3497


insert into hz_application_trans_gt(app_id,party_id) select 435, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 435 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.PARTY_ID from FUN_DIST_LINES xx 
 );

Line: 3502


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.PARTY_ID from FUN_DIST_LINES xx 
 );

Line: 3509


insert into hz_application_trans_gt(app_id,party_id) select 435, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 435 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
 xx 
 where (nvl(STATUS, 'A') in ('A','I'))
 and  xx.PARTY_SITE_ID 
 in (select /*+ parallel(yy)*/ yy.VENDOR_SITE_ID from FUN_SUPPLIER_MAPS
 yy 
));

Line: 3519


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
 xx 
 where (nvl(STATUS, 'A') in ('A','I'))
 and  xx.PARTY_SITE_ID 
 in (select /*+ parallel(yy)*/ yy.VENDOR_SITE_ID from FUN_SUPPLIER_MAPS
 yy 
));

Line: 3531


insert into hz_application_trans_gt(app_id,party_id) select 8405, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 8405 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PERSON_PROFILES
 xx 
 where (nvl(STATUS, 'A') in ('A','I') and effective_end_date is null)
 and  xx.PERSON_PROFILE_ID 
 in (select /*+ parallel(yy)*/ yy.PERSON_PROFILE_ID from IGS_PE_STAT_DETAILS
 yy 
));

Line: 3541


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PERSON_PROFILES
 xx 
 where (nvl(STATUS, 'A') in ('A','I') and effective_end_date is null)
 and  xx.PERSON_PROFILE_ID 
 in (select /*+ parallel(yy)*/ yy.PERSON_PROFILE_ID from IGS_PE_STAT_DETAILS
 yy 
));

Line: 3553


insert into hz_application_trans_gt(app_id,party_id) select 8405, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 8405 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.PAY_PERSON_ID from IGS_FI_REFUNDS xx 
 );

Line: 3558


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.PAY_PERSON_ID from IGS_FI_REFUNDS xx 
 );

Line: 3565


insert into hz_application_trans_gt(app_id,party_id) select 8405, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 8405 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.PARTY_ID from IGP_AC_ACCOUNT_INTS xx 
 );

Line: 3570


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.PARTY_ID from IGP_AC_ACCOUNT_INTS xx 
 );

Line: 3577


insert into hz_application_trans_gt(app_id,party_id) select 8405, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 8405 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.ORG_PARTY_ID from IGP_US_REG_VIEWERS xx 
 );

Line: 3582


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.ORG_PARTY_ID from IGP_US_REG_VIEWERS xx 
 );

Line: 3589


insert into hz_application_trans_gt(app_id,party_id) select 535, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 535 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.CUSTOMER_ID from XDP_ORDER_HEADERS xx 
 );

Line: 3594


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.CUSTOMER_ID from XDP_ORDER_HEADERS xx 
 );

Line: 3601


insert into hz_application_trans_gt(app_id,party_id) select 250, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 250 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.PARTY_ID from QA_RESULTS xx 
 );

Line: 3606


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.PARTY_ID from QA_RESULTS xx 
 );

Line: 3613


insert into hz_application_trans_gt(app_id,party_id) select 694, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 694 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.PARTY_ID from PRP_EMAIL_RECIPIENTS xx 
 );

Line: 3618


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.PARTY_ID from PRP_EMAIL_RECIPIENTS xx 
 );

Line: 3625


insert into hz_application_trans_gt(app_id,party_id) select 694, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 694 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.CONTACT_PARTY_ID from PRP_PROPOSALS xx 
 );

Line: 3630


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.CONTACT_PARTY_ID from PRP_PROPOSALS xx 
 );

Line: 3637


insert into hz_application_trans_gt(app_id,party_id) select 542, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 542 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
 xx 
 where (nvl(STATUS, 'A') in ('A','I'))
 and  xx.PARTY_SITE_ID 
 in (select /*+ parallel(yy)*/ yy.LOCATION_ID from CSI_ITEM_INSTANCES
 yy 
));

Line: 3647


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
 xx 
 where (nvl(STATUS, 'A') in ('A','I'))
 and  xx.PARTY_SITE_ID 
 in (select /*+ parallel(yy)*/ yy.LOCATION_ID from CSI_ITEM_INSTANCES
 yy 
));

Line: 3659


insert into hz_application_trans_gt(app_id,party_id) select 542, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 542 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
 xx 
 where (nvl(STATUS, 'A') in ('A','I'))
 and  xx.PARTY_SITE_ID 
 in (select /*+ parallel(yy)*/ yy.INSTALL_LOCATION_ID from CSI_ITEM_INSTANCES
 yy 
));

Line: 3669


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
 xx 
 where (nvl(STATUS, 'A') in ('A','I'))
 and  xx.PARTY_SITE_ID 
 in (select /*+ parallel(yy)*/ yy.INSTALL_LOCATION_ID from CSI_ITEM_INSTANCES
 yy 
));

Line: 3681


insert into hz_application_trans_gt(app_id,party_id) select 542, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 542 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
 xx 
 where (nvl(STATUS, 'A') in ('A','I'))
 and  xx.PARTY_SITE_ID 
 in (select /*+ parallel(yy)*/ yy.INSTALL_SITE_USE_ID from CSI_T_TXN_SYSTEMS
 yy 
));

Line: 3691


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
 xx 
 where (nvl(STATUS, 'A') in ('A','I'))
 and  xx.PARTY_SITE_ID 
 in (select /*+ parallel(yy)*/ yy.INSTALL_SITE_USE_ID from CSI_T_TXN_SYSTEMS
 yy 
));

Line: 3703


insert into hz_application_trans_gt(app_id,party_id) select 697, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 697 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.INVOICE_TO_PARTY_ID from ASO_QUOTE_HEADERS_ALL xx 
 );

Line: 3708


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.INVOICE_TO_PARTY_ID from ASO_QUOTE_HEADERS_ALL xx 
 );

Line: 3715


insert into hz_application_trans_gt(app_id,party_id) select 697, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 697 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.INVOICE_TO_PARTY_ID from ASO_QUOTE_LINES_ALL xx 
 );

Line: 3720


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.INVOICE_TO_PARTY_ID from ASO_QUOTE_LINES_ALL xx 
 );

Line: 3727


insert into hz_application_trans_gt(app_id,party_id) select 697, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 697 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.SHIP_TO_PARTY_ID from ASO_SHIPMENTS xx 
 );

Line: 3732


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.SHIP_TO_PARTY_ID from ASO_SHIPMENTS xx 
 );

Line: 3739


insert into hz_application_trans_gt(app_id,party_id) select 697, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 697 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
 xx 
 where (nvl(STATUS, 'A') in ('A','I'))
 and  xx.PARTY_SITE_ID 
 in (select /*+ parallel(yy)*/ yy.INVOICE_TO_PARTY_SITE_ID from ASO_QUOTE_HEADERS_ALL
 yy 
));

Line: 3749


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
 xx 
 where (nvl(STATUS, 'A') in ('A','I'))
 and  xx.PARTY_SITE_ID 
 in (select /*+ parallel(yy)*/ yy.INVOICE_TO_PARTY_SITE_ID from ASO_QUOTE_HEADERS_ALL
 yy 
));

Line: 3761


insert into hz_application_trans_gt(app_id,party_id) select 697, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 697 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
 xx 
 where (nvl(STATUS, 'A') in ('A','I'))
 and  xx.PARTY_SITE_ID 
 in (select /*+ parallel(yy)*/ yy.INVOICE_TO_PARTY_SITE_ID from ASO_QUOTE_LINES_ALL
 yy 
));

Line: 3771


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
 xx 
 where (nvl(STATUS, 'A') in ('A','I'))
 and  xx.PARTY_SITE_ID 
 in (select /*+ parallel(yy)*/ yy.INVOICE_TO_PARTY_SITE_ID from ASO_QUOTE_LINES_ALL
 yy 
));

Line: 3783


insert into hz_application_trans_gt(app_id,party_id) select 697, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 697 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.INVOICE_TO_CUST_PARTY_ID from ASO_QUOTE_HEADERS_ALL xx 
 );

Line: 3788


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.INVOICE_TO_CUST_PARTY_ID from ASO_QUOTE_HEADERS_ALL xx 
 );

Line: 3795


insert into hz_application_trans_gt(app_id,party_id) select 697, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 697 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
 xx 
 where (nvl(STATUS, 'A') in ('A','I'))
 and  xx.PARTY_SITE_ID 
 in (select /*+ parallel(yy)*/ yy.SOLD_TO_PARTY_SITE_ID from ASO_QUOTE_HEADERS_ALL
 yy 
));

Line: 3805


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
 xx 
 where (nvl(STATUS, 'A') in ('A','I'))
 and  xx.PARTY_SITE_ID 
 in (select /*+ parallel(yy)*/ yy.SOLD_TO_PARTY_SITE_ID from ASO_QUOTE_HEADERS_ALL
 yy 
));

Line: 3817


insert into hz_application_trans_gt(app_id,party_id) select 697, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 697 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.INVOICE_TO_CUST_PARTY_ID from ASO_QUOTE_LINES_ALL xx 
 );

Line: 3822


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.INVOICE_TO_CUST_PARTY_ID from ASO_QUOTE_LINES_ALL xx 
 );

Line: 3829


insert into hz_application_trans_gt(app_id,party_id) select 697, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 697 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.SHIP_TO_CUST_PARTY_ID from ASO_SHIPMENTS xx 
 );

Line: 3834


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.SHIP_TO_CUST_PARTY_ID from ASO_SHIPMENTS xx 
 );

Line: 3841


insert into hz_application_trans_gt(app_id,party_id) select 697, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 697 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.END_CUSTOMER_PARTY_ID from ASO_QUOTE_HEADERS_ALL xx 
 );

Line: 3846


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.END_CUSTOMER_PARTY_ID from ASO_QUOTE_HEADERS_ALL xx 
 );

Line: 3853


insert into hz_application_trans_gt(app_id,party_id) select 697, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 697 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.END_CUSTOMER_CUST_PARTY_ID from ASO_QUOTE_HEADERS_ALL xx 
 );

Line: 3858


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.END_CUSTOMER_CUST_PARTY_ID from ASO_QUOTE_HEADERS_ALL xx 
 );

Line: 3865


insert into hz_application_trans_gt(app_id,party_id) select 697, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 697 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
 xx 
 where (nvl(STATUS, 'A') in ('A','I'))
 and  xx.PARTY_SITE_ID 
 in (select /*+ parallel(yy)*/ yy.END_CUSTOMER_PARTY_SITE_ID from ASO_QUOTE_HEADERS_ALL
 yy 
));

Line: 3875


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
 xx 
 where (nvl(STATUS, 'A') in ('A','I'))
 and  xx.PARTY_SITE_ID 
 in (select /*+ parallel(yy)*/ yy.END_CUSTOMER_PARTY_SITE_ID from ASO_QUOTE_HEADERS_ALL
 yy 
));

Line: 3887


insert into hz_application_trans_gt(app_id,party_id) select 697, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 697 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.END_CUSTOMER_PARTY_ID from ASO_QUOTE_LINES_ALL xx 
 );

Line: 3892


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.END_CUSTOMER_PARTY_ID from ASO_QUOTE_LINES_ALL xx 
 );

Line: 3899


insert into hz_application_trans_gt(app_id,party_id) select 697, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 697 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.END_CUSTOMER_CUST_PARTY_ID from ASO_QUOTE_LINES_ALL xx 
 );

Line: 3904


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.END_CUSTOMER_CUST_PARTY_ID from ASO_QUOTE_LINES_ALL xx 
 );

Line: 3911


insert into hz_application_trans_gt(app_id,party_id) select 697, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 697 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
 xx 
 where (nvl(STATUS, 'A') in ('A','I'))
 and  xx.PARTY_SITE_ID 
 in (select /*+ parallel(yy)*/ yy.END_CUSTOMER_PARTY_SITE_ID from ASO_QUOTE_LINES_ALL
 yy 
));

Line: 3921


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
 xx 
 where (nvl(STATUS, 'A') in ('A','I'))
 and  xx.PARTY_SITE_ID 
 in (select /*+ parallel(yy)*/ yy.END_CUSTOMER_PARTY_SITE_ID from ASO_QUOTE_LINES_ALL
 yy 
));

Line: 3933


insert into hz_application_trans_gt(app_id,party_id) select 777, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 777 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.PARTY_ID from OKE_POOL_PARTIES xx 
 );

Line: 3938


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.PARTY_ID from OKE_POOL_PARTIES xx 
 );

Line: 3945


insert into hz_application_trans_gt(app_id,party_id) select 867, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 867 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.REQUESTED_BY_PARTY_ID from AHL_SUBSCRIPTIONS_B xx 
 );

Line: 3950


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.REQUESTED_BY_PARTY_ID from AHL_SUBSCRIPTIONS_B xx 
 );

Line: 3957


insert into hz_application_trans_gt(app_id,party_id) select 867, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 867 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.SUBSCRIBED_FRM_PARTY_ID from AHL_SUBSCRIPTIONS_B xx 
 );

Line: 3962


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.SUBSCRIBED_FRM_PARTY_ID from AHL_SUBSCRIPTIONS_B xx 
 );

Line: 3969


insert into hz_application_trans_gt(app_id,party_id) select 867, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 867 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.OPERATOR_PARTY_ID from AHL_ROUTES_B xx 
 );

Line: 3974


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.OPERATOR_PARTY_ID from AHL_ROUTES_B xx 
 );

Line: 3981


insert into hz_application_trans_gt(app_id,party_id) select 279, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 279 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.INCUMBENT_PARTNER_PARTY_ID from AS_SALES_LEADS xx 
 );

Line: 3986


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.INCUMBENT_PARTNER_PARTY_ID from AS_SALES_LEADS xx 
 );

Line: 3993


insert into hz_application_trans_gt(app_id,party_id) select 279, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 279 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.CLOSE_COMPETITOR_ID from AS_SALES_CREDITS_DENORM xx 
 );

Line: 3998


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.CLOSE_COMPETITOR_ID from AS_SALES_CREDITS_DENORM xx 
 );

Line: 4005


insert into hz_application_trans_gt(app_id,party_id) select 279, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 279 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.CUSTOMER_ID from AS_LEADS_LOG xx 
 );

Line: 4010


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.CUSTOMER_ID from AS_LEADS_LOG xx 
 );

Line: 4017


insert into hz_application_trans_gt(app_id,party_id) select 279, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 279 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
 xx 
 where (nvl(STATUS, 'A') in ('A','I'))
 and  xx.PARTY_SITE_ID 
 in (select /*+ parallel(yy)*/ yy.ADDRESS_ID from AS_LEADS_LOG
 yy 
));

Line: 4027


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
 xx 
 where (nvl(STATUS, 'A') in ('A','I'))
 and  xx.PARTY_SITE_ID 
 in (select /*+ parallel(yy)*/ yy.ADDRESS_ID from AS_LEADS_LOG
 yy 
));

Line: 4039


insert into hz_application_trans_gt(app_id,party_id) select 279, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 279 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.CLOSE_COMPETITOR_ID from AS_LEADS_LOG xx 
 );

Line: 4044


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.CLOSE_COMPETITOR_ID from AS_LEADS_LOG xx 
 );

Line: 4051


insert into hz_application_trans_gt(app_id,party_id) select 279, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 279 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.CUSTOMER_ID from AS_CURRENT_ENVIRONMENT xx 
 );

Line: 4056


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.CUSTOMER_ID from AS_CURRENT_ENVIRONMENT xx 
 );

Line: 4063


insert into hz_application_trans_gt(app_id,party_id) select 279, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 279 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.REFERRED_BY from AS_SALES_LEADS xx 
 );

Line: 4068


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.REFERRED_BY from AS_SALES_LEADS xx 
 );

Line: 4075


insert into hz_application_trans_gt(app_id,party_id) select 242, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 242 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.ASSESSMENT_OWNER_ID from AMW_ASSESSMENTS_B xx 
 );

Line: 4080


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.ASSESSMENT_OWNER_ID from AMW_ASSESSMENTS_B xx 
 );

Line: 4087


insert into hz_application_trans_gt(app_id,party_id) select 242, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 242 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.EXECUTED_BY from AMW_AP_EXECUTIONS xx 
 );

Line: 4092


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.EXECUTED_BY from AMW_AP_EXECUTIONS xx 
 );

Line: 4099


insert into hz_application_trans_gt(app_id,party_id) select 242, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 242 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.ENTERED_BY_ID from AMW_CONSTRAINTS_B xx 
 );

Line: 4104


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.ENTERED_BY_ID from AMW_CONSTRAINTS_B xx 
 );

Line: 4111


insert into hz_application_trans_gt(app_id,party_id) select 242, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 242 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.REQUESTED_BY_ID from AMW_VIOLATIONS xx 
 );

Line: 4116


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.REQUESTED_BY_ID from AMW_VIOLATIONS xx 
 );

Line: 4123


insert into hz_application_trans_gt(app_id,party_id) select 242, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 242 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.CERTIFICATION_OWNER_ID from AMW_CERTIFICATION_B xx 
 );

Line: 4128


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.CERTIFICATION_OWNER_ID from AMW_CERTIFICATION_B xx 
 );

Line: 4135


insert into hz_application_trans_gt(app_id,party_id) select 514, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 514 and appl.party_id=temp.party_id) and 

 to_char(temp.party_id)  in (select /*+ parallel(xx)*/ xx.ATTRIBUTE_VALUE from JTF_PERZ_DATA_V xx 
 where (attribute_name = 'customer ID' and application_id = 514 and perz_data_type in ('CSS_PROFILE_DEFECT_TEMPLATE','CSS_PROFILE_ENH_TEMPLATE') and profile_name like 'CSS_514%'));

Line: 4140


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 to_char(temp.party_id)  in (select /*+ parallel(xx)*/ xx.ATTRIBUTE_VALUE from JTF_PERZ_DATA_V xx 
 where (attribute_name = 'customer ID' and application_id = 514 and perz_data_type in ('CSS_PROFILE_DEFECT_TEMPLATE','CSS_PROFILE_ENH_TEMPLATE') and profile_name like 'CSS_514%'));

Line: 4147


insert into hz_application_trans_gt(app_id,party_id) select 514, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 514 and appl.party_id=temp.party_id) and 

 to_char(temp.party_id)  in (select /*+ parallel(xx)*/ xx.PARAMETER_VALUE from JTF_PERZ_QUERY_PARAM_V xx 
 where (parameter_name in ('CUSTOMER_ID','SR_CUSTOMER_ID') and application_id = 514 and query_type like 'ADV_SEARCH_%' and profile_name like 'CSS_514%' ));

Line: 4152


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 to_char(temp.party_id)  in (select /*+ parallel(xx)*/ xx.PARAMETER_VALUE from JTF_PERZ_QUERY_PARAM_V xx 
 where (parameter_name in ('CUSTOMER_ID','SR_CUSTOMER_ID') and application_id = 514 and query_type like 'ADV_SEARCH_%' and profile_name like 'CSS_514%' ));

Line: 4159


insert into hz_application_trans_gt(app_id,party_id) select 396, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 396 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_ID from PON_SUPPLIER_ACTIVITIES xx 
 );

Line: 4164


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_ID from PON_SUPPLIER_ACTIVITIES xx 
 );

Line: 4171


insert into hz_application_trans_gt(app_id,party_id) select 396, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 396 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.SUPPLIER_TRADING_PARTNER_ID from PON_SUPPLIER_ACCESS xx 
 );

Line: 4176


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.SUPPLIER_TRADING_PARTNER_ID from PON_SUPPLIER_ACCESS xx 
 );

Line: 4183


insert into hz_application_trans_gt(app_id,party_id) select 396, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 396 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_ID from PON_PARTY_LINE_EXCLUSIONS xx 
 );

Line: 4188


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_ID from PON_PARTY_LINE_EXCLUSIONS xx 
 );

Line: 4195


insert into hz_application_trans_gt(app_id,party_id) select 396, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 396 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_ID from PON_PF_SUPPLIER_FORMULA xx 
 );

Line: 4200


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_ID from PON_PF_SUPPLIER_FORMULA xx 
 );

Line: 4207


insert into hz_application_trans_gt(app_id,party_id) select 396, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 396 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.SURROG_BID_CREATED_TP_ID from PON_BID_HEADERS xx 
 );

Line: 4212


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.SURROG_BID_CREATED_TP_ID from PON_BID_HEADERS xx 
 );

Line: 4219


insert into hz_application_trans_gt(app_id,party_id) select 396, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 396 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.AUTHORING_PARTY_CONTACT_ID from PON_CONTRACTS xx 
 );

Line: 4224


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.AUTHORING_PARTY_CONTACT_ID from PON_CONTRACTS xx 
 );

Line: 4231


insert into hz_application_trans_gt(app_id,party_id) select 396, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 396 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.AUTHORING_PARTY_ID from PON_CONTRACTS xx 
 );

Line: 4236


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.AUTHORING_PARTY_ID from PON_CONTRACTS xx 
 );

Line: 4243


insert into hz_application_trans_gt(app_id,party_id) select 396, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 396 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.OWNER_PARTY_ID from PON_THREADS xx 
 );

Line: 4248


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.OWNER_PARTY_ID from PON_THREADS xx 
 );

Line: 4255


insert into hz_application_trans_gt(app_id,party_id) select 396, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 396 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.FROM_ID from PON_THREAD_ENTRIES xx 
 );

Line: 4260


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.FROM_ID from PON_THREAD_ENTRIES xx 
 );

Line: 4267


insert into hz_application_trans_gt(app_id,party_id) select 396, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 396 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.FROM_COMPANY_ID from PON_THREAD_ENTRIES xx 
 );

Line: 4272


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.FROM_COMPANY_ID from PON_THREAD_ENTRIES xx 
 );

Line: 4279


insert into hz_application_trans_gt(app_id,party_id) select 396, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 396 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.TO_COMPANY_ID from PON_TE_RECIPIENTS xx 
 );

Line: 4284


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.TO_COMPANY_ID from PON_TE_RECIPIENTS xx 
 );

Line: 4291


insert into hz_application_trans_gt(app_id,party_id) select 396, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 396 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.SURROG_BID_ACK_CONTACT_ID from PON_ACKNOWLEDGEMENTS xx 
 );

Line: 4296


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.SURROG_BID_ACK_CONTACT_ID from PON_ACKNOWLEDGEMENTS xx 
 );

Line: 4303


insert into hz_application_trans_gt(app_id,party_id) select 396, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 396 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.SURROG_BID_ACK_TP_ID from PON_ACKNOWLEDGEMENTS xx 
 );

Line: 4308


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.SURROG_BID_ACK_TP_ID from PON_ACKNOWLEDGEMENTS xx 
 );

Line: 4315


insert into hz_application_trans_gt(app_id,party_id) select 396, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 396 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.BUYER_TP_CONTACT_ID from PON_SUPPLIER_ACCESS xx 
 );

Line: 4320


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.BUYER_TP_CONTACT_ID from PON_SUPPLIER_ACCESS xx 
 );

Line: 4327


insert into hz_application_trans_gt(app_id,party_id) select 396, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 396 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_CONTACT_ID from PON_BIDDING_PARTIES xx 
 );

Line: 4332


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_CONTACT_ID from PON_BIDDING_PARTIES xx 
 );

Line: 4339


insert into hz_application_trans_gt(app_id,party_id) select 396, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 396 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.ACK_PARTNER_CONTACT_ID from PON_BIDDING_PARTIES xx 
 );

Line: 4344


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.ACK_PARTNER_CONTACT_ID from PON_BIDDING_PARTIES xx 
 );

Line: 4351


insert into hz_application_trans_gt(app_id,party_id) select 396, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 396 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_CONTACT_ID from PON_OPTIMIZE_CONSTRAINTS xx 
 );

Line: 4356


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_CONTACT_ID from PON_OPTIMIZE_CONSTRAINTS xx 
 );

Line: 4363


insert into hz_application_trans_gt(app_id,party_id) select 396, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 396 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_ID from PON_OPTIMIZE_CONSTRAINTS xx 
 );

Line: 4368


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_ID from PON_OPTIMIZE_CONSTRAINTS xx 
 );

Line: 4375


insert into hz_application_trans_gt(app_id,party_id) select 396, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 396 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_CONTACT_ID from PON_ACKNOWLEDGEMENTS xx 
 );

Line: 4380


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_CONTACT_ID from PON_ACKNOWLEDGEMENTS xx 
 );

Line: 4387


insert into hz_application_trans_gt(app_id,party_id) select 396, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 396 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_ID from PON_ACKNOWLEDGEMENTS xx 
 );

Line: 4392


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_ID from PON_ACKNOWLEDGEMENTS xx 
 );

Line: 4399


insert into hz_application_trans_gt(app_id,party_id) select 396, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 396 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_CONTACT_ID from PON_AUCTION_SUMMARY xx 
 );

Line: 4404


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_CONTACT_ID from PON_AUCTION_SUMMARY xx 
 );

Line: 4411


insert into hz_application_trans_gt(app_id,party_id) select 396, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 396 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_ID from PON_AUCTION_SUMMARY xx 
 );

Line: 4416


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_ID from PON_AUCTION_SUMMARY xx 
 );

Line: 4423


insert into hz_application_trans_gt(app_id,party_id) select 396, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 396 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_CONTACT_ID from PON_SUPPLIER_ACTIVITIES xx 
 );

Line: 4428


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_CONTACT_ID from PON_SUPPLIER_ACTIVITIES xx 
 );

Line: 4435


insert into hz_application_trans_gt(app_id,party_id) select 396, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 396 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.DRAFT_LOCKED_BY_CONTACT_ID from PON_AUCTION_HEADERS_ALL xx 
 );

Line: 4440


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.DRAFT_LOCKED_BY_CONTACT_ID from PON_AUCTION_HEADERS_ALL xx 
 );

Line: 4447


insert into hz_application_trans_gt(app_id,party_id) select 396, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 396 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.DRAFT_UNLOCKED_BY_CONTACT_ID from PON_AUCTION_HEADERS_ALL xx 
 );

Line: 4452


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.DRAFT_UNLOCKED_BY_CONTACT_ID from PON_AUCTION_HEADERS_ALL xx 
 );

Line: 4459


insert into hz_application_trans_gt(app_id,party_id) select 396, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 396 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.SCORING_LOCK_TP_CONTACT_ID from PON_AUCTION_HEADERS_ALL xx 
 );

Line: 4464


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.SCORING_LOCK_TP_CONTACT_ID from PON_AUCTION_HEADERS_ALL xx 
 );

Line: 4471


insert into hz_application_trans_gt(app_id,party_id) select 396, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 396 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_CONTACT_ID from PON_AUCTION_EVENTS xx 
 );

Line: 4476


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.TRADING_PARTNER_CONTACT_ID from PON_AUCTION_EVENTS xx 
 );

Line: 4483


insert into hz_application_trans_gt(app_id,party_id) select 396, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 396 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.SURROG_BID_CREATED_CONTACT_ID from PON_BID_HEADERS xx 
 );

Line: 4488


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.SURROG_BID_CREATED_CONTACT_ID from PON_BID_HEADERS xx 
 );

Line: 4495


insert into hz_application_trans_gt(app_id,party_id) select 396, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 396 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.SCORE_OVERRIDE_TP_CONTACT_ID from PON_BID_HEADERS xx 
 );

Line: 4500


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.SCORE_OVERRIDE_TP_CONTACT_ID from PON_BID_HEADERS xx 
 );

Line: 4507


insert into hz_application_trans_gt(app_id,party_id) select 396, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 396 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.SHORTLIST_TPC_ID from PON_BID_HEADERS xx 
 );

Line: 4512


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.SHORTLIST_TPC_ID from PON_BID_HEADERS xx 
 );

Line: 4519


insert into hz_application_trans_gt(app_id,party_id) select 396, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 396 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.DRAFT_UNLOCKED_BY_CONTACT_ID from PON_BID_HEADERS xx 
 );

Line: 4524


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.DRAFT_UNLOCKED_BY_CONTACT_ID from PON_BID_HEADERS xx 
 );

Line: 4531


insert into hz_application_trans_gt(app_id,party_id) select 396, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 396 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.DRAFT_LOCKED_BY_CONTACT_ID from PON_BID_HEADERS xx 
 );

Line: 4536


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.DRAFT_LOCKED_BY_CONTACT_ID from PON_BID_HEADERS xx 
 );

Line: 4543


insert into hz_application_trans_gt(app_id,party_id) select 540, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 540 and appl.party_id=temp.party_id) and 

 to_char(temp.party_id)  in (select /*+ parallel(xx)*/ xx.INT_ID from OKL_INS_POLICIES_B xx 
 where (IPY_TYPE = 'THIRD_PARTY_POLICY'));

Line: 4548


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 to_char(temp.party_id)  in (select /*+ parallel(xx)*/ xx.INT_ID from OKL_INS_POLICIES_B xx 
 where (IPY_TYPE = 'THIRD_PARTY_POLICY'));

Line: 4555


insert into hz_application_trans_gt(app_id,party_id) select 540, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 540 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
 xx 
 where (nvl(STATUS, 'A') in ('A','I'))
 and  to_char(xx.PARTY_SITE_ID)
 in (select /*+ parallel(yy)*/ yy.AGENT_SITE_ID from OKL_INS_POLICIES_B
 yy 
 where IPY_TYPE = 'THIRD_PARTY_POLICY'));

Line: 4565


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
 xx 
 where (nvl(STATUS, 'A') in ('A','I'))
 and  to_char(xx.PARTY_SITE_ID)
 in (select /*+ parallel(yy)*/ yy.AGENT_SITE_ID from OKL_INS_POLICIES_B
 yy 
 where IPY_TYPE = 'THIRD_PARTY_POLICY'));

Line: 4577


insert into hz_application_trans_gt(app_id,party_id) select 540, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 540 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
 xx 
 where (nvl(STATUS, 'A') in ('A','I'))
 and  xx.PARTY_SITE_ID 
 in (select /*+ parallel(yy)*/ yy.AGENCY_SITE_ID from OKL_INS_POLICIES_B
 yy 
 where IPY_TYPE = 'THIRD_PARTY_POLICY'));

Line: 4587


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
 xx 
 where (nvl(STATUS, 'A') in ('A','I'))
 and  xx.PARTY_SITE_ID 
 in (select /*+ parallel(yy)*/ yy.AGENCY_SITE_ID from OKL_INS_POLICIES_B
 yy 
 where IPY_TYPE = 'THIRD_PARTY_POLICY'));

Line: 4599


insert into hz_application_trans_gt(app_id,party_id) select 540, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 540 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
 xx 
 where (nvl(STATUS, 'A') in ('A','I'))
 and  xx.PARTY_SITE_ID 
 in (select /*+ parallel(yy)*/ yy.AGENCY_SITE_ID from OKL_INS_POLICIES_B
 yy 
 where IPY_TYPE = 'THIRD_PARTY_POLICY'));

Line: 4609


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
 xx 
 where (nvl(STATUS, 'A') in ('A','I'))
 and  xx.PARTY_SITE_ID 
 in (select /*+ parallel(yy)*/ yy.AGENCY_SITE_ID from OKL_INS_POLICIES_B
 yy 
 where IPY_TYPE = 'THIRD_PARTY_POLICY'));

Line: 4621


insert into hz_application_trans_gt(app_id,party_id) select 540, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 540 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.ISU_ID from OKL_INS_POLICIES_B xx 
 where (IPY_TYPE = 'THIRD_PARTY_POLICY'));

Line: 4626


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.ISU_ID from OKL_INS_POLICIES_B xx 
 where (IPY_TYPE = 'THIRD_PARTY_POLICY'));

Line: 4633


insert into hz_application_trans_gt(app_id,party_id) select 540, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 540 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.CUSTOMER_ID from OKL_EXT_SELL_INVS_B xx 
 );

Line: 4638


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.CUSTOMER_ID from OKL_EXT_SELL_INVS_B xx 
 );

Line: 4645


insert into hz_application_trans_gt(app_id,party_id) select 540, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 540 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.PARTY_ID from OKL_OPEN_INT xx 
 );

Line: 4650


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.PARTY_ID from OKL_OPEN_INT xx 
 );

Line: 4657


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 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.SITE_CATEGORY_OBJECT_ID from AMS_IBA_PL_SITES_B xx 
 where (SITE_CATEGORY_TYPE = 'AFFILIATES'));

Line: 4662


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.SITE_CATEGORY_OBJECT_ID from AMS_IBA_PL_SITES_B xx 
 where (SITE_CATEGORY_TYPE = 'AFFILIATES'));

Line: 4669


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 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.PARTY_ID from AMS_PARTY_MARKET_SEGMENTS xx 
 );

Line: 4674


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.PARTY_ID from AMS_PARTY_MARKET_SEGMENTS xx 
 );

Line: 4681


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 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.COORDINATOR_ID from AMS_AGENDAS_B xx 
 );

Line: 4686


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.COORDINATOR_ID from AMS_AGENDAS_B xx 
 );

Line: 4693


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 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.PARTY_ID from AMS_TCOP_CHANNEL_SUMMARY xx 
 );

Line: 4698


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.PARTY_ID from AMS_TCOP_CHANNEL_SUMMARY xx 
 );

Line: 4705


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 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.PARTY_ID from AMS_TCOP_CONTACTS xx 
 );

Line: 4710


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.PARTY_ID from AMS_TCOP_CONTACTS xx 
 );

Line: 4717


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 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.PARTY_ID from AMS_TCOP_PRVW_CONTACTS xx 
 );

Line: 4722


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.PARTY_ID from AMS_TCOP_PRVW_CONTACTS xx 
 );

Line: 4729


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 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.PARTY_ID from AMS_TCOP_PRVW_FTG_DTLS xx 
 );

Line: 4734


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.PARTY_ID from AMS_TCOP_PRVW_FTG_DTLS xx 
 );

Line: 4741


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 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.PARTY_ID from CSC_CUST_PLANS xx 
 );

Line: 4746


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.PARTY_ID from CSC_CUST_PLANS xx 
 );

Line: 4753


insert into hz_application_trans_gt(app_id,party_id) select 454, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 454 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.CUSTOMER_ID from ISC_DR_REPAIR_ORDERS_F xx 
 );

Line: 4758


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.CUSTOMER_ID from ISC_DR_REPAIR_ORDERS_F xx 
 );

Line: 4765


insert into hz_application_trans_gt(app_id,party_id) select 716, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 716 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.FACILITY_CONTACT_ID from FTE_LOCATION_PARAMETERS xx 
 );

Line: 4770


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.FACILITY_CONTACT_ID from FTE_LOCATION_PARAMETERS xx 
 );

Line: 4777


insert into hz_application_trans_gt(app_id,party_id) select 272, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 272 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.PARTY_ID from FEM_PARTY_PROFITABILITY xx 
 );

Line: 4782


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.PARTY_ID from FEM_PARTY_PROFITABILITY xx 
 );

Line: 4789


insert into hz_application_trans_gt(app_id,party_id) select 690, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 690 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.PARTY_ID from JTF_FM_PROCESSED_V xx 
 );

Line: 4794


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.PARTY_ID from JTF_FM_PROCESSED_V xx 
 );

Line: 4801


insert into hz_application_trans_gt(app_id,party_id) select 690, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 690 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.PARTY_ID from JTF_FM_CONTENT_HISTORY_V xx 
 );

Line: 4806


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.PARTY_ID from JTF_FM_CONTENT_HISTORY_V xx 
 );

Line: 4813


insert into hz_application_trans_gt(app_id,party_id) select 690, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 690 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
 xx 
 where (nvl(STATUS, 'A') in ('A','I'))
 and  xx.PARTY_SITE_ID 
 in (select /*+ parallel(yy)*/ yy.PARTY_SITE_ID from JTF_TTY_NAMED_ACCTS
 yy 
));

Line: 4823


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
 xx 
 where (nvl(STATUS, 'A') in ('A','I'))
 and  xx.PARTY_SITE_ID 
 in (select /*+ parallel(yy)*/ yy.PARTY_SITE_ID from JTF_TTY_NAMED_ACCTS
 yy 
));

Line: 4835


insert into hz_application_trans_gt(app_id,party_id) select 515, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 515 and appl.party_id=temp.party_id) and 

 to_char(temp.party_id)  in (select /*+ parallel(xx)*/ xx.QUALIFIER_ATTR_VALUE from OKS_QUALIFIERS xx 
 where ((qualifier_context = 'ASOPARTYINFO'  AND qualifier_attribute = 'QUALIFIER_ATTRIBUTE1'  OR qualifier_context = 'CUSTOMER' AND qualifier_attribute ='QUALIFIER_ATTRIBUTE16'  OR qualifier_context = 'CUSTOMER_GROUP' AND qualifier_attribute = 'QUALIFIER_ATTRIBUTE3'  OR qualifier_context = 'PARTY' AND qualifier_attribute IN ('QUALIFIER_ATTRIBUTE1', 'QUALIFIER_ATTRIBUTE2'))));

Line: 4840


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 to_char(temp.party_id)  in (select /*+ parallel(xx)*/ xx.QUALIFIER_ATTR_VALUE from OKS_QUALIFIERS xx 
 where ((qualifier_context = 'ASOPARTYINFO'  AND qualifier_attribute = 'QUALIFIER_ATTRIBUTE1'  OR qualifier_context = 'CUSTOMER' AND qualifier_attribute ='QUALIFIER_ATTRIBUTE16'  OR qualifier_context = 'CUSTOMER_GROUP' AND qualifier_attribute = 'QUALIFIER_ATTRIBUTE3'  OR qualifier_context = 'PARTY' AND qualifier_attribute IN ('QUALIFIER_ATTRIBUTE1', 'QUALIFIER_ATTRIBUTE2'))));

Line: 4847


insert into hz_application_trans_gt(app_id,party_id) select 515, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 515 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
 xx 
 where (nvl(STATUS, 'A') in ('A','I'))
 and  to_char(xx.PARTY_SITE_ID)
 in (select /*+ parallel(yy)*/ yy.QUALIFIER_ATTR_VALUE from OKS_QUALIFIERS
 yy 
 where (qualifier_context = 'ASOPARTYINFO'  AND qualifier_attribute IN ('QUALIFIER_ATTRIBUTE10','QUALIFIER_ATTRIBUTE11')  OR qualifier_context = 'CUSTOMER' AND qualifier_attribute IN ('QUALIFIER_ATTRIBUTE17', 'QUALIFIER_ATTRIBUTE18'))));

Line: 4857


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
 xx 
 where (nvl(STATUS, 'A') in ('A','I'))
 and  to_char(xx.PARTY_SITE_ID)
 in (select /*+ parallel(yy)*/ yy.QUALIFIER_ATTR_VALUE from OKS_QUALIFIERS
 yy 
 where (qualifier_context = 'ASOPARTYINFO'  AND qualifier_attribute IN ('QUALIFIER_ATTRIBUTE10','QUALIFIER_ATTRIBUTE11')  OR qualifier_context = 'CUSTOMER' AND qualifier_attribute IN ('QUALIFIER_ATTRIBUTE17', 'QUALIFIER_ATTRIBUTE18'))));

Line: 4869


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 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.BILL_TO_PARTY_ID from CS_ESTIMATE_DETAILS xx 
 );

Line: 4874


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.BILL_TO_PARTY_ID from CS_ESTIMATE_DETAILS xx 
 );

Line: 4881


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 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.SHIP_TO_PARTY_ID from CS_ESTIMATE_DETAILS xx 
 );

Line: 4886


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.SHIP_TO_PARTY_ID from CS_ESTIMATE_DETAILS xx 
 );

Line: 4893


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 

 temp.party_id  in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
 xx 
 where (nvl(STATUS, 'A') in ('A','I'))
 and  xx.PARTY_SITE_ID 
 in (select /*+ parallel(yy)*/ yy.SITE_ID from CS_INCIDENTS_ALL_B
 yy 
));

Line: 4903


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
 xx 
 where (nvl(STATUS, 'A') in ('A','I'))
 and  xx.PARTY_SITE_ID 
 in (select /*+ parallel(yy)*/ yy.SITE_ID from CS_INCIDENTS_ALL_B
 yy 
));

Line: 4915


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 

 temp.party_id  in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
 xx 
 where (nvl(STATUS, 'A') in ('A','I'))
 and  xx.PARTY_SITE_ID 
 in (select /*+ parallel(yy)*/ yy.SITE_ID from CS_INCIDENTS_AUDIT_B
 yy 
));

Line: 4925


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
 xx 
 where (nvl(STATUS, 'A') in ('A','I'))
 and  xx.PARTY_SITE_ID 
 in (select /*+ parallel(yy)*/ yy.SITE_ID from CS_INCIDENTS_AUDIT_B
 yy 
));

Line: 4937


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 

 temp.party_id  in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
 xx 
 where (nvl(STATUS, 'A') in ('A','I'))
 and  xx.PARTY_SITE_ID 
 in (select /*+ parallel(yy)*/ yy.BILL_TO_SITE_ID from CS_INCIDENTS_ALL_B
 yy 
));

Line: 4947


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
 xx 
 where (nvl(STATUS, 'A') in ('A','I'))
 and  xx.PARTY_SITE_ID 
 in (select /*+ parallel(yy)*/ yy.BILL_TO_SITE_ID from CS_INCIDENTS_ALL_B
 yy 
));

Line: 4959


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 

 temp.party_id  in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
 xx 
 where (nvl(STATUS, 'A') in ('A','I'))
 and  xx.PARTY_SITE_ID 
 in (select /*+ parallel(yy)*/ yy.SHIP_TO_SITE_ID from CS_INCIDENTS_ALL_B
 yy 
));

Line: 4969


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
 xx 
 where (nvl(STATUS, 'A') in ('A','I'))
 and  xx.PARTY_SITE_ID 
 in (select /*+ parallel(yy)*/ yy.SHIP_TO_SITE_ID from CS_INCIDENTS_ALL_B
 yy 
));

Line: 4981


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 

 temp.party_id  in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
 xx 
 where (nvl(STATUS, 'A') in ('A','I'))
 and  xx.PARTY_SITE_ID 
 in (select /*+ parallel(yy)*/ yy.INSTALL_SITE_ID from CS_INCIDENTS_ALL_B
 yy 
));

Line: 4991


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
 xx 
 where (nvl(STATUS, 'A') in ('A','I'))
 and  xx.PARTY_SITE_ID 
 in (select /*+ parallel(yy)*/ yy.INSTALL_SITE_ID from CS_INCIDENTS_ALL_B
 yy 
));

Line: 5003


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 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.BILL_TO_CONTACT_ID from CS_INCIDENTS_AUDIT_B xx 
 );

Line: 5008


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.BILL_TO_CONTACT_ID from CS_INCIDENTS_AUDIT_B xx 
 );

Line: 5015


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 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.BILL_TO_PARTY_ID from CS_INCIDENTS_ALL_B xx 
 );

Line: 5020


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.BILL_TO_PARTY_ID from CS_INCIDENTS_ALL_B xx 
 );

Line: 5027


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 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.SHIP_TO_PARTY_ID from CS_INCIDENTS_ALL_B xx 
 );

Line: 5032


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.SHIP_TO_PARTY_ID from CS_INCIDENTS_ALL_B xx 
 );

Line: 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 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.VALUE_OBJECT_ID from CS_CHG_SUB_RESTRICTIONS xx 
 );

Line: 5044


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.VALUE_OBJECT_ID from CS_CHG_SUB_RESTRICTIONS xx 
 );

Line: 5051


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 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.BILL_TO_CONTACT_ID from CS_INCIDENTS_ALL_B xx 
 );

Line: 5056


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.BILL_TO_CONTACT_ID from CS_INCIDENTS_ALL_B xx 
 );

Line: 5063


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 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.SHIP_TO_CONTACT_ID from CS_INCIDENTS_ALL_B xx 
 );

Line: 5068


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.SHIP_TO_CONTACT_ID from CS_INCIDENTS_ALL_B xx 
 );

Line: 5075


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 

 temp.party_id  in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
 xx 
 where (nvl(STATUS, 'A') in ('A','I'))
 and  xx.PARTY_SITE_ID 
 in (select /*+ parallel(yy)*/ yy.CUSTOMER_SITE_ID from CS_INCIDENTS_ALL_B
 yy 
));

Line: 5085


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
 xx 
 where (nvl(STATUS, 'A') in ('A','I'))
 and  xx.PARTY_SITE_ID 
 in (select /*+ parallel(yy)*/ yy.CUSTOMER_SITE_ID from CS_INCIDENTS_ALL_B
 yy 
));

Line: 5097


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 

 temp.party_id  in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
 xx 
 where (nvl(STATUS, 'A') in ('A','I'))
 and  xx.PARTY_SITE_ID 
 in (select /*+ parallel(yy)*/ yy.INSTALL_SITE_USE_ID from CS_INCIDENTS_ALL_B
 yy 
));

Line: 5107


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
 xx 
 where (nvl(STATUS, 'A') in ('A','I'))
 and  xx.PARTY_SITE_ID 
 in (select /*+ parallel(yy)*/ yy.INSTALL_SITE_USE_ID from CS_INCIDENTS_ALL_B
 yy 
));

Line: 5119


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 

 temp.party_id  in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
 xx 
 where (nvl(STATUS, 'A') in ('A','I'))
 and  xx.PARTY_SITE_ID 
 in (select /*+ parallel(yy)*/ yy.INCIDENT_LOCATION_ID from CS_INCIDENTS_ALL_B
 yy 
));

Line: 5129


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
 xx 
 where (nvl(STATUS, 'A') in ('A','I'))
 and  xx.PARTY_SITE_ID 
 in (select /*+ parallel(yy)*/ yy.INCIDENT_LOCATION_ID from CS_INCIDENTS_ALL_B
 yy 
));

Line: 5141


insert into hz_application_trans_gt(app_id,party_id) select 174, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 174 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
 xx 
 where (nvl(STATUS, 'A') in ('A','I'))
 and  xx.PARTY_SITE_ID 
 in (select /*+ parallel(yy)*/ yy.PARTY_SITE_ID from ECX_TP_HEADERS
 yy 
));

Line: 5151


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
 xx 
 where (nvl(STATUS, 'A') in ('A','I'))
 and  xx.PARTY_SITE_ID 
 in (select /*+ parallel(yy)*/ yy.PARTY_SITE_ID from ECX_TP_HEADERS
 yy 
));

Line: 5163


insert into hz_application_trans_gt(app_id,party_id) select 204, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 204 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.ISSUING_AUTHORITY_ID from XLE_REGISTRATIONS xx 
 );

Line: 5168


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.ISSUING_AUTHORITY_ID from XLE_REGISTRATIONS xx 
 );

Line: 5175


insert into hz_application_trans_gt(app_id,party_id) select 204, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 204 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.AUTHORITY_ID from XLE_REG_FUNCTIONS xx 
 );

Line: 5180


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.AUTHORITY_ID from XLE_REG_FUNCTIONS xx 
 );

Line: 5187


insert into hz_application_trans_gt(app_id,party_id) select 204, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 204 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
 xx 
 where (nvl(STATUS, 'A') in ('A','I'))
 and  xx.PARTY_SITE_ID 
 in (select /*+ parallel(yy)*/ yy.ISSUING_AUTHORITY_SITE_ID from XLE_REGISTRATIONS
 yy 
));

Line: 5197


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
 xx 
 where (nvl(STATUS, 'A') in ('A','I'))
 and  xx.PARTY_SITE_ID 
 in (select /*+ parallel(yy)*/ yy.ISSUING_AUTHORITY_SITE_ID from XLE_REGISTRATIONS
 yy 
));

Line: 5209


insert into hz_application_trans_gt(app_id,party_id) select 204, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 204 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
 xx 
 where (nvl(STATUS, 'A') in ('A','I'))
 and  xx.PARTY_SITE_ID 
 in (select /*+ parallel(yy)*/ yy.AUTHORITY_SITE_ID from XLE_REG_FUNCTIONS
 yy 
));

Line: 5219


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
 xx 
 where (nvl(STATUS, 'A') in ('A','I'))
 and  xx.PARTY_SITE_ID 
 in (select /*+ parallel(yy)*/ yy.AUTHORITY_SITE_ID from XLE_REG_FUNCTIONS
 yy 
));

Line: 5231


insert into hz_application_trans_gt(app_id,party_id) select 666, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 666 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.PARTY_ID from IBW_PAGE_VIEWS xx 
 );

Line: 5236


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.PARTY_ID from IBW_PAGE_VIEWS xx 
 );

Line: 5243


insert into hz_application_trans_gt(app_id,party_id) select 666, temp.party_id from hz_purge_gt temp  where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 666 and appl.party_id=temp.party_id) and 

 temp.party_id  in (select /*+ parallel(xx)*/ xx.PARTY_RELATIONSHIP_ID from IBW_PAGE_VIEWS xx 
 );

Line: 5248


delete /*+ parallel(temp) */ from hz_purge_gt temp where 
 temp.party_id  in (select /*+ parallel(xx)*/ xx.PARTY_RELATIONSHIP_ID from IBW_PAGE_VIEWS xx 
 );

Line: 5253


delete from hz_purge_gt temp where temp.party_id in (select appl.party_id from hz_application_trans_gt appl) ;