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?