My purpose for asking this question is to speed up the report. After running a trace. I see there are 6 program units that return values base on the input prior to getting the counts and generating the page layout. My question is could I speed this up
by removing the plsql and replacing it in the sql with a decode?