APPS.CSI_INSTANCE_PARTIES_VLD_PVT dependencies on HZ_ORG_CONTACTS

Line 382: , hz_org_contacts c

378: CURSOR C2 (i_contact_id IN NUMBER ,
379: i_party_id IN NUMBER ) IS
380: SELECT 'x'
381: FROM hz_relationships r
382: , hz_org_contacts c
383: , ar_lookups l
384: WHERE (r.object_id = i_party_id
385: OR
386: r.object_id IN (SELECT DISTINCT ha.party_id