APPS.ONT_ITM_PKG dependencies on HZ_RELATIONSHIPS

Line 139: HZ_RELATIONSHIPS REL,

135: SELECT PARTY.PARTY_NAME INTO x_contact_name
136: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
137: HZ_PARTIES PARTY,
138: HZ_CUST_ACCOUNTS ACCT,
139: HZ_RELATIONSHIPS REL,
140: HZ_PARTIES REL_PARTY
141: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_contact_id
142: AND ACCT_ROLE.PARTY_ID = REL.PARTY_ID
143: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'