805: and not exists (Select 'x'
806: from zx_registrations reg
807: where ptp.party_tax_profile_id = reg.party_tax_profile_id)
808: and not exists (Select 'x'
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'
1057: and not exists (Select 'x'
1058: from zx_registrations reg
1059: where ptp.party_tax_profile_id = reg.party_tax_profile_id)
1060: and not exists (Select 'x'
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'