APPS.OTA_LP_NOTIFY_SS dependencies on HZ_RELATIONSHIPS

Line 130: HZ_RELATIONSHIPS rel,

126: CURSOR csr_get_contact_name IS
127: SELECT PARTY.party_name contact_name
128: FROM HZ_CUST_ACCOUNT_ROLES acct_role,
129: HZ_PARTIES party,
130: HZ_RELATIONSHIPS rel,
131: HZ_ORG_CONTACTS org_cont,
132: HZ_CUST_ACCOUNTS role_acct
133: WHERE acct_role.party_id = rel.party_id
134: and acct_role.role_type = 'CONTACT'