11.5.10 AP How to avoid Self Approval in AME

Hello

I have enable AME for invoice Dynamic Approval, hence the user who capture the invoice is able to assign himself as an approver.

I have create the following attribute to avoid self approval, however it works fine only for one user.

Numeric Attribute called "Avoid Self-Approval"

SELECT DECODE((select requester_id from apps.ap_invoices_all where invoice_id =:transactionId),

(SELECT NVL(c.employee_id, -999) FROM fnd_user c WHERE c.user_name in ('USER')), 1, 0) FROM DUAL

I will have around 200 users which will be able to capture invoices, but I need to avoid self-approval.

The following attribute does not work.