DBA Data[Home] [Help]

APPS.PO_POXRQDDR_XMLP_PKG SQL Statements

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

Line: 25

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

function select_failed_f return character is
begin
     if P_failed_funds = 'Y' then
         return(',prl.requisition_header_id, gl1.description Description1');     else
Line: 110

   select gsb.chart_of_accounts_id
   into l_p_chart_of_accounts_id
   from gl_sets_of_books gsb,
        financials_system_parameters fsp
   where gsb.set_of_books_id = fsp.set_of_books_id;
Line: 128

  select psp.manual_req_num_type
                into numbering_type
                from po_system_parameters psp;