APPS.AP_APXINDIA_XMLP_PKG SQL Statements

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

Line: 48

   SELECT  al.displayed_field
   INTO    nls_all
   FROM    ap_lookup_codes al
   WHERE   al.lookup_type = 'NLS REPORT PARAMETER'
     AND   al.lookup_code = 'ALL';

Line: 70

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

Line: 91

  SELECT  substr(g.name,1,30), to_char(sysdate-1, 'DD-MON-RR')
  INTO    c_name, test_date
  FROM    gl_sets_of_books g, ap_system_parameters P
  WHERE   g.set_of_books_id   =  P.set_of_books_id;

Line: 142

SELECT vendor_name
INTO   ven_name
FROM   po_vendors
WHERE  vendor_id = to_number(ven_id);