11.5.10 AP Invoice Approval AME using PO Hierarchy

Hello Oracle Gurus

One person is capture an AP invoice so the record is update in the create by field, now I need to populate his supervisor name into the field

INV_SUM_FOLDER.REQUESTER_NAME

I have the following SQL to get the supervisor.

select fndu.user_name, pecx.full_name

From apps.FND_USER fndu, apps.per_employees_current_x pecx,

(

SELECT PERA.SUPERVISOR_ID --, fndu.user_name, pecx.full_name

FROM

apps.PER_ASSIGNMENTS_F PERA

WHERE EXISTS

(SELECT '1' FROM

apps.PER_PEOPLE_F PERF,

apps.PER_ASSIGNMENTS_F PERA1 WHERE TRUNC(SYSDATE) BETWEEN