APPS.HZ_PURGE_GEN dependencies on PV_LEAD_ASSIGNMENTS

Line 60: or exists (select 'Y' from PV_LEAD_ASSIGNMENTS xx where xx.PARTNER_ID = temp.party_id

56:
57: or exists (select 'Y' from PV_ENTY_ATTR_VALUES xx where xx.ENTITY_ID = temp.party_id
58: )
59:
60: or exists (select 'Y' from PV_LEAD_ASSIGNMENTS xx where xx.PARTNER_ID = temp.party_id
61: )
62:
63: or exists (select 'Y' from PV_ASSIGNMENT_LOGS xx where xx.PARTNER_ID = temp.party_id
64: )

Line 144: or exists (select 'Y' from PV_LEAD_ASSIGNMENTS xx where xx.RELATED_PARTY_ID = temp.party_id

140:
141: or exists (select 'Y' from PV_REFERRALS_B xx where xx.CUSTOMER_CONTACT_PARTY_ID = temp.party_id
142: )
143:
144: or exists (select 'Y' from PV_LEAD_ASSIGNMENTS xx where xx.RELATED_PARTY_ID = temp.party_id
145: )
146:
147: or exists (select 'Y' from PV_PARTNER_ACCESSES xx where xx.PARTNER_ID = temp.party_id
148: );

Line 159: or exists (select 'Y' from PV_LEAD_ASSIGNMENTS xx where xx.PARTNER_ID = temp.party_id

155:
156: or exists (select 'Y' from PV_ENTY_ATTR_VALUES xx where xx.ENTITY_ID = temp.party_id
157: )
158:
159: or exists (select 'Y' from PV_LEAD_ASSIGNMENTS xx where xx.PARTNER_ID = temp.party_id
160: )
161:
162: or exists (select 'Y' from PV_ASSIGNMENT_LOGS xx where xx.PARTNER_ID = temp.party_id
163: )

Line 243: or exists (select 'Y' from PV_LEAD_ASSIGNMENTS xx where xx.RELATED_PARTY_ID = temp.party_id

239:
240: or exists (select 'Y' from PV_REFERRALS_B xx where xx.CUSTOMER_CONTACT_PARTY_ID = temp.party_id
241: )
242:
243: or exists (select 'Y' from PV_LEAD_ASSIGNMENTS xx where xx.RELATED_PARTY_ID = temp.party_id
244: )
245:
246: or exists (select 'Y' from PV_PARTNER_ACCESSES xx where xx.PARTNER_ID = temp.party_id
247: );