APPS.AR_ARXINVAD_XMLP_PKG SQL Statements

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

Line: 18

   SELECT ds.name,
          lu.meaning
   INTO   l_sequence_name,
          l_sequence_method
   FROM   fnd_document_sequences ds,
          fnd_lookups lu
   WHERE  ds.doc_sequence_id = p_sequence_id
   AND    lu.lookup_type = 'SEQUENCE_METHOD'
   AND    lu.LOOKUP_CODE = ds.type;

Line: 90

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

  select SUBSTR(meaning, 1, 30)
  into   status
  from   fnd_lookups
  where  lookup_type='SEQ_DOCUMENT_STATUS'
  and    lookup_code='E';

Line: 117

function C_deletedFormula return VARCHAR2 is
begin
DECLARE
  status VARCHAR2(30);

Line: 122

  select SUBSTR(meaning, 1, 30)
  into   status
  from   fnd_lookups
  where  lookup_type = 'SEQ_DOCUMENT_STATUS'
  and    lookup_code = 'D';

Line: 152

  select SUBSTR(meaning, 1, 30)
  into   status
  from   fnd_lookups
  where  lookup_type = 'SEQ_DOCUMENT_STATUS'
  and    lookup_code = 'N';

Line: 167

  SELECT  g.currency_code,
          c.precision,
          c.minimum_accountable_unit,
          c.description
  INTO    base_curr,
          prec,
          min_au,
          descr
  FROM    ar_system_parameters p,
          gl_sets_of_books g,
          fnd_currencies_vl c
  WHERE        p.set_of_books_id = g.set_of_books_id
        AND    g.currency_code  = c.currency_code;

Line: 192

  SELECT  meaning
  INTO    l_report_type
  FROM    ar_lookups
  WHERE   LOOKUP_TYPE = 'AUDIT_REPORT_TYPE'
  AND     LOOKUP_CODE = p_type;