DBA Data[Home] [Help]

APPS.HZ_PURGE_GEN dependencies on CS_HZ_SR_CONTACT_POINTS

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

2705:
2706: exists (select 'Y' from CS_INCIDENTS_ALL_B xx where xx.CUSTOMER_ID = temp.party_id
2707: )
2708:
2709: or exists (select 'Y' from CS_HZ_SR_CONTACT_POINTS xx where xx.PARTY_ID = temp.party_id
2710: and (CONTACT_TYPE <> 'EMPLOYEE'))
2711:
2712: or exists (select 'Y' from HZ_PARTY_SITES
2713: xx where xx.PARTY_ID = temp.party_id

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

2730:
2731: exists (select 'Y' from CS_INCIDENTS_ALL_B xx where xx.CUSTOMER_ID = temp.party_id
2732: )
2733:
2734: or exists (select 'Y' from CS_HZ_SR_CONTACT_POINTS xx where xx.PARTY_ID = temp.party_id
2735: and (CONTACT_TYPE <> 'EMPLOYEE'))
2736:
2737: or exists (select 'Y' from HZ_PARTY_SITES
2738: xx where xx.PARTY_ID = temp.party_id