Hierarchy of AE called within AE 
How to get the order of peoplesoft App Engine execution sequence 

e.g for GL_JEDIT it goes upto 12 level deeper 

Select 
ae1.ae_level, 
ae1.AE_section_ORDER, 
ae1.stmt_tree,ae.descr, ae.DESCRLONG from PSAEAPPLDEFN AE, ( 
select SYS_CONNECT_BY_PATH(A.AE_DO_APPL_ID||':'||AE_DO_SE CTION,'->') as stmt_tree,a.AE_DO_APPL_ID 
,a.AE_SEQ_NUM as AE_section_ORDER 
,level AS ae_level 
from PSAESTEPDEFN a 
where AE_DO_APPL_ID <> ' ' 
start with AE_APPLID= 'GL_JEDIT' 
connect by NOCYCLE prior AE_DO_APPL_ID=AE_APPLID ) AE1 
where ae.AE_APPLID=ae1.AE_DO_APPL_ID 
ORDER BY ae_level ,ae1.AE_section_ORDER

Read More:http://peoplesoft.ittoolbox.com/groups/technical-functional/peoplet...