APPS.AP_APXPPREM_XMLP_PKG SQL Statements

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

Line: 17

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

Line: 71

      C_START_DATE_PREDICATE := 'and aipp.last_update_date >= '''||to_char(P_START_DATE)||'''';

Line: 77

      C_END_DATE_PREDICATE := 'and aipp.last_update_date <= '''
		||to_char(P_END_DATE)||'''';

Line: 135

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

    select substr(userenv('LANGUAGE'),1,instr(userenv('LANGUAGE'),'_')-1)
  into   session_language
  from   dual;

Line: 348

    select nls_language
  into   base_language
  from   fnd_languages
  where  installed_flag = 'B';