How to set up a FYI notification for negotiation team members when the negotiation is approved?

Summary:

Need to send automatically an FYI notification to the Negotiation team members when the negotiation is approved.

Content (please ensure you mask any confidential information):

I have tried with SQL in the NegApprovalStatusFYI and NegotiationApproval tasks in BPM but it didn't work:

orcl:query-database(concat('select pu.username from fusion.pon_neg_team_members pntm, fusion.per_users pu where pntm.person_id = pu.person_id and pntm.auction_header_id=',/task:task/task:payload/task:AuctionHeaderId), true(), true(),'jdbc/ApplicationDBDS')

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

23D