AME Related PL/SQL script issue

   Hi Folks,

We have following requirement.

When user submits Template-1 related expense report system need to forward to default approver (Employee level supervisor). 

When User Submits Template-2 related expense report system need to forward to  default approver,  once approver approved the Expense report, system need to root the next level approver based on amount limit.

I have done following setups.

Created Action type  as follow.

Name: XX APPROVER

Handler: XX APPROVER

Rule Type: Chain of Authority

Description: XX APPROVER

Allowed Approver types: HR People

Dynamic Action description: Query Generated

Action Description Query: SELECT ppf.full_name employee, ppf2.full_name supervisor