DBA Data[Home] [Help]

APPS.HZ_MERGE_UTIL dependencies on HZ_ORG_CONTACTS

Line 325: FROM HZ_RELATIONSHIPS pr, HZ_ORG_CONTACTS oc, --4500011

321: RETURN VARCHAR2 IS
322:
323: CURSOR c_get_desc IS
324: SELECT p1.party_name
325: FROM HZ_RELATIONSHIPS pr, HZ_ORG_CONTACTS oc, --4500011
326: HZ_PARTIES p1
327: WHERE p1.party_id = pr.subject_id
328: AND oc.party_relationship_id = pr.relationship_id
329: AND oc.org_contact_id = p_org_contact_id

Line 359: FROM hz_org_contacts

355: RETURN NUMBER IS
356:
357: CURSOR org_cont IS
358: SELECT org_contact_id
359: FROM hz_org_contacts
360: WHERE party_relationship_id = p_party_relationship_id;
361:
362: l_org_cont_id NUMBER;
363: