APPS.AP_APXINROH_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: 76

   SELECT  ly.meaning,
           ln.meaning,
           l1.displayed_field,
           l2.displayed_field,
           l3.displayed_field
   INTO    nls_yes,  nls_no,  nls_all, nls_na, nls_no_desc
   FROM    fnd_lookups ly,  fnd_lookups ln,
	   ap_lookup_codes l1, ap_lookup_codes l2,
	   ap_lookup_codes l3
   WHERE   ly.lookup_type = 'YES_NO'
     AND   ly.lookup_code = 'Y'
     AND   ln.lookup_type = 'YES_NO'
     AND   ln.lookup_code = 'N'
     AND   l1.lookup_type = 'NLS REPORT PARAMETER'
     AND   l1.lookup_code = 'ALL'
     AND   l2.lookup_type = 'NLS REPORT PARAMETER'
     AND   l2.lookup_code = 'NA'
     AND   l3.lookup_type = 'NLS TRANSLATION'
     AND   l3.lookup_code = 'NO DESCRIPTION';

Line: 226

            SELECT sort_by_alternate_field
    INTO SORT_BY_ALTERNATE
    FROM AP_SYSTEM_PARAMETERS;

Line: 277

  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: 415

       SELECT party_name
       INTO  l_party_name
       FROM  hz_parties
       WHERE party_id = p_party_id;

Line: 424

       SELECT displayed_field
         INTO l_order_by
         FROM ap_lookup_codes
        WHERE lookup_type = 'RPT ORDER BY'
          AND lookup_code = p_order_by;

Line: 432

       SELECT meaning
         INTO l_hold_period_option
         FROM fnd_lookups
        WHERE lookup_type = 'YES_NO'
          AND lookup_code = p_subtotal_flag;

Line: 440

        SELECT displayed_field
         INTO l_due_or_discount
         FROM ap_lookup_codes
        WHERE lookup_type = 'DATE RANGE'
          AND lookup_code = p_date_par;

Line: 448

        SELECT meaning
         INTO l_include_hold_desc
         FROM fnd_lookups
        WHERE lookup_type = 'YES_NO'
          AND lookup_code = p_hold_desc_flag;