APPS.HZ_PURGE dependencies on ZX_REGISTRATIONS

Line 806: from zx_registrations reg

802: and ptp.party_id in (select candidate_party_id
803: from hz_purge_candidates
804: where batch_id=batchid and status='IDENTIFIED')
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)

Line 1058: from zx_registrations reg

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
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)