[Home] [Help]
16: select decode(entity_name,'HZ_PARTY_RELATIONSHIPS','HZ_RELATIONSHIPS',entity_name) entity_name, fk_column_name, decode(entity_name,'HZ_PARTY_RELATIONSHIPS','RELATIONSHIP_ID',pk_column_name) pk_column_name,
17: decode(entity_name,'HZ_PARTY_RELATIONSHIPS', join_clause || ' AND subject_table_name = ''HZ_PARTIES'' AND object_table_name = ''HZ_PARTIES''
18: AND directional_flag = ''F''', join_clause) join_clause, parent_entity_name,fk_data_type
19: from hz_merge_dictionary where parent_entity_name like 'HZ_%' and dict_application_id = app_id
20: and fk_column_name IS NOT NULL and entity_name not in ('AS_CHANGED_ACCOUNTS_ALL','POS_PARTIES_V','POS_PARTY_SITES_V','WSH_LOCATION_OWNERS','ZX_PARTY_TAX_PROFILE','CE_BANKS_MERGE_V','CE_BANK_BRANCHES_MERGE_V','WSH_SUPPLIER_SF_SITES_V')
21: and nvl(validate_purge_flag,'Y') <> 'N'; --5125968
22:
23: cursor x4(app_id number) is --4500011
24: select decode(entity_name,'HZ_PARTY_RELATIONSHIPS','HZ_RELATIONSHIPS',entity_name) entity_name, fk_column_name,
796: from hz_purge_candidates
797: where batch_id=batchid and status='IDENTIFIED')
798: and wlo.owner_party_id <> -1;
799:
800: Delete from zx_party_tax_profile PTP
801: where ptp.party_type_code = 'THIRD_PARTY'
802: and ptp.party_id in (select candidate_party_id
803: from hz_purge_candidates
804: where batch_id=batchid and status='IDENTIFIED')
809: from zx_exemptions ex
810: where ptp.party_tax_profile_id = ex.party_tax_profile_id)
811: and not exists (Select 'x'
812: from ZX_REPORT_CODES_ASSOC assoc
813: where assoc.entity_code = 'ZX_PARTY_TAX_PROFILE'
814: and assoc.ENTITY_ID = ptp.party_tax_profile_id)
815: and not exists (Select 'x'
816: from hz_code_assignments HCA
817: where HCA.OWNER_TABLE_NAME = 'ZX_PARTY_TAX_PROFILE'
813: where assoc.entity_code = 'ZX_PARTY_TAX_PROFILE'
814: and assoc.ENTITY_ID = ptp.party_tax_profile_id)
815: and not exists (Select 'x'
816: from hz_code_assignments HCA
817: where HCA.OWNER_TABLE_NAME = 'ZX_PARTY_TAX_PROFILE'
818: AND HCA.OWNER_TABLE_ID = PTP.PARTY_TAX_PROFILE_ID);
819:
820: DELETE from HZ_PARTIES where party_id in
821: (select candidate_party_id from hz_purge_candidates where batch_id=batchid and status='IDENTIFIED');
1050: select 'x'
1051: from wsh_location_owners wlo1
1052: where wlo1.wsh_location_id = wlo.wsh_location_id and wlo1.owner_party_id = -1);
1053:
1054: Delete from zx_party_tax_profile PTP
1055: where ptp.party_type_code = 'THIRD_PARTY'
1056: and ptp.party_id = p_party_id
1057: and not exists (Select 'x'
1058: from zx_registrations reg
1061: from zx_exemptions ex
1062: where ptp.party_tax_profile_id = ex.party_tax_profile_id)
1063: and not exists (Select 'x'
1064: from ZX_REPORT_CODES_ASSOC assoc
1065: where assoc.entity_code = 'ZX_PARTY_TAX_PROFILE'
1066: and assoc.ENTITY_ID = ptp.party_tax_profile_id)
1067: and not exists (Select 'x'
1068: from hz_code_assignments HCA
1069: where HCA.OWNER_TABLE_NAME = 'ZX_PARTY_TAX_PROFILE'
1065: where assoc.entity_code = 'ZX_PARTY_TAX_PROFILE'
1066: and assoc.ENTITY_ID = ptp.party_tax_profile_id)
1067: and not exists (Select 'x'
1068: from hz_code_assignments HCA
1069: where HCA.OWNER_TABLE_NAME = 'ZX_PARTY_TAX_PROFILE'
1070: AND HCA.OWNER_TABLE_ID = PTP.PARTY_TAX_PROFILE_ID);
1071:
1072: DELETE from HZ_PARTIES where party_id = p_party_id;
1073: