DBA Data[Home] [Help]

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: