APPS.HZ_PURGE_GEN dependencies on PV_PARTNER_ACCESSES
Line 147: or exists (select 'Y' from PV_PARTNER_ACCESSES xx where xx.PARTNER_ID = temp.party_id
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: );
149: else
150: delete from hz_purge_gt temp where
151:
Line 246: or exists (select 'Y' from PV_PARTNER_ACCESSES xx where xx.PARTNER_ID = temp.party_id
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: );
248: end if;
249:
250: