APPS.OTA_LP_NOTIFY_SS dependencies on HZ_ORG_CONTACTS

Line 131: HZ_ORG_CONTACTS org_cont,

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'
135: and org_cont.party_relationship_id = rel.relationship_id