[Home] [Help]
11: function BeforeReport return boolean is
12: begin
13:
14: declare
15: l_sort po_lookup_codes.displayed_field%type ;
16: begin
17:
18: if P_ORDERBY is not null then
19:
18: if P_ORDERBY is not null then
19:
20: select displayed_field
21: into l_sort
22: from po_lookup_codes
23: where lookup_code = P_orderby
24: and lookup_type = 'SRS ORDER BY';
25:
26: P_ORDERBY_DISP := l_sort ;