APPS.PO_POXACTPO_XMLP_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 23

    select displayed_field
    into l_po_type
    from po_lookup_codes
    where lookup_code = P_type
    and lookup_type = 'PO TYPE';

Line: 39

    select displayed_field
    into l_sort
    from po_lookup_codes
    where lookup_code = P_orderby
    and lookup_type = 'SRS ORDER BY';

Line: 113

 select decode(mrc_sob_type_code,'R','R','P'),currency_code
 into p_mrcsobtype,p_base_currency
from gl_sets_of_books
 where set_of_books_id = p_ca_set_of_books_id;

Line: 127

  select set_of_books_id
  into l_sysparam_sob_id
  from financials_system_parameters;