DBA Data[Home] [Help]

APPS.PO_POXRQCRQ_XMLP_PKG dependencies on PO_LOOKUP_CODES

Line 9: l_sort po_lookup_codes.displayed_field%type ;

5: begin
6:
7: declare
8:
9: l_sort po_lookup_codes.displayed_field%type ;
10: begin
11:
12: QTY_PRECISION:=PO_common_xmlp_pkg.GET_PRECISION(P_QTY_PRECISION);
13: if P_orderby is not null then

Line 17: from po_lookup_codes

13: if P_orderby is not null then
14:
15: select displayed_field
16: into l_sort
17: from po_lookup_codes
18: where lookup_code = P_orderby
19: and lookup_type = 'SRS ORDER BY';
20:
21: P_orderby_displayed := l_sort ;