APPS.JG_ZZ_COMMON_PKG dependencies on HZ_RELATIONSHIPS

Line 307: ,HZ_RELATIONSHIPS REL

303: CURSOR lc_contact_phone(cp_party_id in number) IS
304: SELECT per.party_name
305: ,per.primary_phone_number
306: FROM HZ_PARTIES HP
307: ,HZ_RELATIONSHIPS REL
308: ,HZ_PARTIES PER
309: WHERE HP.PARTY_ID = cp_party_id
310: AND rel.object_id = HP.PARTY_ID
311: AND rel.subject_id = per.party_id