APPS.AP_APXINDTL_XMLP_PKG SQL Statements

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

Line: 9

  SELECT  c.precision,
          c.minimum_accountable_unit,
          c.description
  INTO    prec,
          min_au,
          descr
  FROM    ap_system_parameters p,
          fnd_currencies_vl c
  WHERE   p.base_currency_code  = c.currency_code;

Line: 46

   SELECT  ly.meaning,
           ln.meaning,
           la.displayed_field
   INTO    nls_yes,  nls_no,  nls_all
   FROM    fnd_lookups ly,  fnd_lookups ln,  ap_lookup_codes la
   WHERE   ly.lookup_type = 'YES_NO'
     AND   ly.lookup_code = 'Y'
     AND   ln.lookup_type = 'YES_NO'
     AND   ln.lookup_code = 'N'
     AND   la.lookup_type = 'NLS REPORT PARAMETER'
     AND   la.lookup_code = 'ALL';

Line: 132

  SELECT  gl.name,
          gl.chart_of_accounts_id,
          p.base_currency_code
  INTO    l_name,
          l_chart_of_accounts_id,
          l_base_curr_code
  FROM    gl_sets_of_books gl, ap_system_parameters p
  WHERE   gl.set_of_books_id = l_sob_id;

Line: 160

  SELECT  plc.displayed_field
  INTO    l_nls_vndr_type_lkup_code
  FROM    po_lookup_codes plc
  WHERE   plc.lookup_type = 'VENDOR TYPE'
  AND     plc.lookup_code = p_vendor_type_lookup_code;