APPS.AP_APXMTDCR_XMLP_PKG SQL Statements

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

Line: 60

  SELECT  p.base_currency_code,
          c.precision,
          c.minimum_accountable_unit
  INTO    l_base_curr,
          l_prec,
          l_min_au
  FROM    ap_system_parameters p,
          fnd_currencies_vl c
  WHERE   p.base_currency_code  = c.currency_code;

Line: 91

  SELECT  substr(name,1,30),
          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: 125

      SELECT  ly.meaning,
	      la.displayed_field,
              lnep.displayed_field
      INTO    l_nls_yes, l_nls_all, l_nls_none_ep
      FROM    fnd_lookups ly, ap_lookup_codes la, ap_lookup_codes lnep
      WHERE   ly.lookup_type = 'YES_NO'
        AND   ly.lookup_code = 'Y'
	AND   la.lookup_type = 'NLS REPORT PARAMETER'
	AND   la.lookup_code = 'ALL'
        AND   lnep.lookup_type = 'NLS TRANSLATION'
        AND   lnep.lookup_code = 'NONE ELECTRONIC PAYMENT';

Line: 152

	SELECT  displayed_field
	INTO    l_payment_type
	FROM    ap_lookup_codes
	WHERE   lookup_code = P_PAYMENT_TYPE
	AND     lookup_type = 'PAYMENT TYPE';

Line: 164

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

Line: 191

      SELECT '*  '||description
      INTO   l_nls_void_payment_not_incl
      FROM   ap_lookup_codes
      WHERE  lookup_type = 'NLS REPORT PARAMETER'
        AND  lookup_code = 'VOID PAYMENT NOT INCLUDED';

Line: 213

   SELECT c1.currency_code, c1.name, c2.name
   INTO   l_currency, l_currency_name,
          l_pay_currency_name
   FROM   fnd_currencies_vl c1, fnd_currencies_vl c2
   WHERE  c1.currency_code = currency_code_1
     AND  c2.currency_code = pay_currency_code;

Line: 249

   SELECT c.name
   INTO  l_currency_desc
   FROM fnd_currencies_vl c
   WHERE  c.currency_code = c_currency_code;

Line: 265

   SELECT c.name
   INTO  l_currency_desc
   FROM fnd_currencies_vl c
   WHERE  c.currency_code = c_pay_currency_code ;