APPS.AP_APXT7INE_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: 70

   SELECT  ly.meaning,
           ln.meaning,
           l1.displayed_field,
           l2.displayed_field,
           l3.displayed_field
   INTO    nls_yes,
	   nls_no,
	   nls_all,
	   nls_void,
	   nls_na
   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 TRANSLATION'
     AND   l2.lookup_code = 'VOID'
     AND   l3.lookup_type = 'NLS REPORT PARAMETER'
     AND   l3.lookup_code = 'NA';

Line: 172

  SELECT nvl(combined_filing_flag,'N')
  INTO l_combined_flag
  FROM ap_system_parameters;

Line: 227

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

	SELECT  fnd.application_column_name
        INTO    p_balancing_segment_column
        FROM    fnd_segment_attribute_values fnd,
                gl_sets_of_books gl
        WHERE   fnd.attribute_value='Y'
        AND     fnd.segment_attribute_type = 'GL_BALANCING'
        AND     fnd.id_flex_num = gl.chart_of_accounts_id
        AND     fnd.id_flex_code = 'GL#'
        AND     gl.set_of_books_id = p_set_of_books_id;

Line: 293

	SELECT  entity_name
        INTO    p_entity_name
        FROM    ap_reporting_entities
        WHERE   tax_entity_id = p_rep_entity_id;