DBA Data[Home] [Help]

APPS.HZ_PURGE_GEN dependencies on CS_HZ_SR_CONTACT_POINTS

Line 2802: or exists (select 'Y' from CS_HZ_SR_CONTACT_POINTS xx where xx.PARTY_ID = temp.party_id

2798:
2799: exists (select 'Y' from CS_INCIDENTS_ALL_B xx where xx.CUSTOMER_ID = temp.party_id
2800: )
2801:
2802: or exists (select 'Y' from CS_HZ_SR_CONTACT_POINTS xx where xx.PARTY_ID = temp.party_id
2803: and (CONTACT_TYPE <> 'EMPLOYEE'))
2804:
2805: or exists (select 'Y' from HZ_PARTY_SITES
2806: xx where xx.PARTY_ID = temp.party_id

Line 2827: or exists (select 'Y' from CS_HZ_SR_CONTACT_POINTS xx where xx.PARTY_ID = temp.party_id

2823:
2824: exists (select 'Y' from CS_INCIDENTS_ALL_B xx where xx.CUSTOMER_ID = temp.party_id
2825: )
2826:
2827: or exists (select 'Y' from CS_HZ_SR_CONTACT_POINTS xx where xx.PARTY_ID = temp.party_id
2828: and (CONTACT_TYPE <> 'EMPLOYEE'))
2829:
2830: or exists (select 'Y' from HZ_PARTY_SITES
2831: xx where xx.PARTY_ID = temp.party_id