APPS.OTA_LP_NOTIFY_SS dependencies on HZ_CUST_ACCOUNTS

Line 131: HZ_CUST_ACCOUNTS role_acct

127: FROM HZ_CUST_ACCOUNT_ROLES acct_role,
128: HZ_PARTIES party,
129: HZ_RELATIONSHIPS rel,
130: HZ_ORG_CONTACTS org_cont,
131: HZ_CUST_ACCOUNTS role_acct
132: WHERE acct_role.party_id = rel.party_id
133: and acct_role.role_type = 'CONTACT'
134: and org_cont.party_relationship_id = rel.relationship_id
135: and rel.subject_id = party.party_id