APPS.PO_POXPODDR_XMLP_PKG SQL Statements

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

Line: 29

     SELECT displayed_field
     INTO l_sort
     FROM po_lookup_codes
     WHERE lookup_code = P_ORDERBY
     AND lookup_type = 'SRS ORDER BY';

Line: 47

      SELECT meaning
      INTO l_yes_no
      FROM fnd_lookups
      WHERE lookup_type = 'YES_NO'
      AND lookup_code = P_FAILED_FUNDS;

Line: 68

function select_failed_f return character is
begin
    if P_failed_funds = 'Y' then
       return(',pol.po_header_id, gl1.description Description1');

Line: 214

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

Line: 227

  select set_of_books_id
  into l_sysparam_sob_id
  from financials_system_parameters;

Line: 263

    SELECT  psp.manual_po_num_type
    into    P_po_num_type
    FROM    po_system_parameters psp;