one of the documented procedures in this installation of the ACS
im_select_row_range   sql   firstrow   lastrow
What it does:
a tcl proc curtisg wrote to return a sql query that will only contain rows firstrow - lastrow
Defined in: /web/philip/tcl/intranet-defs.tcl

Source code:

    return "select im_select_row_range_y.*
              from (select im_select_row_range_x.*, rownum fake_rownum 
                      from ($sql) im_select_row_range_x
                     where rownum <= $lastrow) im_select_row_range_y
             where fake_rownum >= $firstrow"