APPS.AP_APXINRIR_XMLP_PKG SQL Statements

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

Line: 124

    SELECT sort_by_alternate_field
    INTO SORT_BY_ALTERNATE
    FROM AP_SYSTEM_PARAMETERS;

Line: 165

      SELECT ap_system_parameters.batch_control_flag
      INTO   l_batch_flag
      FROM   ap_system_parameters;

Line: 174

     SELECT nvl(sla_ledger_cash_basis_flag, 'N')
     INTO   l_cash_basis_flag
     FROM   gl_sets_of_books sob,
            ap_system_parameters asp
     WHERE  asp.set_of_books_id = sob.set_of_books_id;

Line: 192

         SELECT ap_batches.batch_id
         INTO   l_batchid
         FROM   ap_batches
         where  batch_name = p_batch;

Line: 202

      SELECT decode(p_entry_person,null,'',fnd_user.user_id)
      INTO   l_userid
      FROM   fnd_user
      WHERE  user_name = decode(p_entry_person,null,user_name,p_entry_person);

Line: 225

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

  select set_of_books_id
  into l_sob_id
  from ap_system_parameters;

Line: 259

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

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

         SELECT  start_date, end_date
         INTO    l_start_date, l_end_date
         FROM    gl_period_statuses
         WHERE   period_name = P_ACCOUNTING_PERIOD
           AND   set_of_books_id = P_SOB_ID
           AND     application_id = 200
           AND NVL(adjustment_period_flag, 'N') = 'N';

Line: 546

     Select vendor_name
       into l_supplier_name
       from po_vendors
       where vendor_id = p_vendor_id;

Line: 559

     Select displayed_field
       into l_invoice_type
       from ap_lookup_codes
       where lookup_code = p_invoice_type
       and   lookup_type = 'INVOICE TYPE'
       and   nvl(inactive_date, sysdate+1) > sysdate;