APPS.JG_ZZ_COMMON_PKG dependencies on HZ_RELATIONSHIPS

Line 318: ,HZ_RELATIONSHIPS REL

314: CURSOR lc_contact_phone(cp_party_id in number) IS
315: SELECT per.party_name
316: ,per.primary_phone_number
317: FROM HZ_PARTIES HP
318: ,HZ_RELATIONSHIPS REL
319: ,HZ_PARTIES PER
320: WHERE HP.PARTY_ID = cp_party_id
321: AND rel.object_id = HP.PARTY_ID
322: AND rel.subject_id = per.party_id