AME Approver Groups - Function To Return Multiple Group Members

 Title: AME Approver Groups - Function To Return Multiple Group Members 
Version: 1
Created on: March 31, 2011 11:01 PM by User26089
Last Modified: March 31, 2011 11:01 PM by User26089
Viewed: 7 times 

On behalf of David

Hi,

I'm working on Requisition approvals in AME, using the ‘approval group chain of authority’ Action Type. I’m trying to create an Approver Group with multiple group members, with the list of members created dynamically via sql. The list of approvers is complex so I have written a function to return them, but the AME Approver Group screen only seems to accept a function which returns one group member. I know you can structure the query to select multiple records from a table but this doesn’t help as I need to use PLSQL to derive the group members.