I used tree_ancestor_p several months ago for bcms.  I am revisting the procs.  So I figured to change if needed.

Basically its used in the tree_X calls.  like tree_folders call which give you the subfolders.  I think you can go about using tree_ancestor_p or using some sort of between query.

Is tree_ancestor_p a good plsql?  It makes the query looks cleaner and more readable at first glance.  Performance seems to be ok.  What do you guys think?