DBA Data[Home] [Help]

APPS.HZ_ORG_CONTACT_BO_PUB dependencies on HZ_RELATIONSHIPS

Line 931: FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS rel, HZ_PARTIES p

927:
928: CURSOR get_ovn(l_oc_id NUMBER) IS
929: SELECT oc.object_version_number, rel.object_version_number, p.object_version_number,
930: p.party_id, rel.object_id, rel.subject_id
931: FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS rel, HZ_PARTIES p
932: WHERE oc.org_contact_id = l_oc_id
933: AND oc.party_relationship_id = rel.relationship_id
934: AND rel.party_id = p.party_id
935: AND rel.subject_type = 'PERSON'