6: function BeforeReport return boolean is
7: begin
8:
9: declare
10: l_active_inactive po_lookup_codes.displayed_field%type ;
11: begin
12: if P_active_inactive is not null then
13:
14: select displayed_field
12: if P_active_inactive is not null then
13:
14: select displayed_field
15: into l_active_inactive
16: from po_lookup_codes
17: where lookup_code = P_active_inactive
18: and lookup_type = 'ACTIVE_INACTIVE';
19:
20: P_act_inact_disp := l_active_inactive ;