How to send contract approval to a team member captured in parties' section of contract

Summary:

We have requirement to send the contract approval to the team member (under Customer section) which is captured under Parties section of the contract and we actually trying to achieve it using SQL query builder from BPM contract Approval rules, but we are facing errors. If anyone implement the same requirement in any of your project. Please help us with your inputs on how to achieve it.

Content (required):

Contract Approval Rules using BPM Composer.

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):