APPS.AP_APXVCHCR_XMLP_PKG SQL Statements

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

Line: 14

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

Line: 78

   SELECT  ly.meaning,
           ln.meaning,
           la.displayed_field,
           lanep.displayed_field
   INTO    nls_yes,  nls_no,  nls_all, nls_none_ep
   FROM    fnd_lookups ly,  fnd_lookups ln,  ap_lookup_codes la,
           ap_lookup_codes lanep
   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'
     AND   lanep.lookup_type = 'NLS TRANSLATION'
     AND   lanep.lookup_code = 'NONE ELECTRONIC PAYMENT';

Line: 102

   SELECT meaning
   INTO   l_nls_display_supp_address
   FROM   fnd_lookups
   WHERE  lookup_type = 'YES_NO'
   AND    lookup_code = P_ADDRS_OPTION;

Line: 111

   SELECT meaning
   INTO   l_nls_zero_amt_option
   FROM   fnd_lookups
   WHERE  lookup_type = 'YES_NO'
   AND    lookup_code = P_INCLUDE_ZEROS;

Line: 295

  SELECT  name,
          chart_of_accounts_id
  INTO    l_name,
          l_chart_of_accounts_id
  FROM    gl_sets_of_books
  WHERE   set_of_books_id = l_sob_id;

Line: 348

select c2.name
into   l_pay_curr_name
from   FND_CURRENCIES_VL c2
where  c2.currency_code = C_PAY_CURR_CODE;

Line: 363

  select c1.name
  into   l_bank_curr_name
  from   FND_CURRENCIES_VL c1
  where  c1.currency_code = C_BANK_CURR_CODE;

Line: 391

  SELECT  displayed_field
  INTO    l_displayed_field
  FROM    ap_lookup_codes
  WHERE   lookup_type  = 'CHECK OR VOID'
  AND     lookup_code = P_DATE_OPTION;