AME APINV - Generating a Approval Group based on PO Limits...

Hi,

I'm looking to setup Invoice Approval in R12.1.3.  I would like to generate a custom Approval List based on the Hierarchy and PO spend limits.  

My requirements is to return all managers up and including the person with sufficient authority for the requester of the Invoice. 

There may be better ways of doing this, and I am open to suggestions. 

But this is what I have so far.  I developed the following select using the "connect by nocycle prior":

SELECT 'person_id:'||person

  FROM ap_invoices_all apinv,

       ( SELECT papf.person_id person,

paaf.supervisor_id manager,

papf