DBA Data[Home] [Help]

APPS.PO_POXDETIT_XMLP_PKG dependencies on PO_LOOKUP_CODES

Line 10: l_active_inactive po_lookup_codes.displayed_field%type ;

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

Line 16: from po_lookup_codes

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 ;