APPS.XLA_DRILLDOWN_PKG SQL Statements

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

Line: 50

     SELECT gl_je_source
       FROM fa_book_controls bc,
       gl_je_headers jeh
      WHERE jeh.je_header_id = c_jeh_id
   AND bc.set_of_books_id = jeh.ledger_id
         AND bc.gl_je_source = c_je_source
         AND c_je_category IN (
          bc.JE_RETIREMENT_CATEGORY
         ,bc.JE_RECLASS_CATEGORY
         ,bc.JE_ADDITION_CATEGORY
         ,bc.JE_ADJUSTMENT_CATEGORY
         ,bc.JE_REVAL_CATEGORY
         ,bc.JE_TRANSFER_CATEGORY
         ,bc.JE_CIP_ADJUSTMENT_CATEGORY
         ,bc.JE_CIP_ADDITION_CATEGORY
         ,bc.JE_CIP_RECLASS_CATEGORY
         ,bc.JE_CIP_RETIREMENT_CATEGORY
         ,bc.JE_CIP_REVAL_CATEGORY
         ,bc.JE_CIP_TRANSFER_CATEGORY  )
   AND ROWNUM = 1;

Line: 136

  SELECT application_id, je_source_name
    FROM xla_subledgers
   WHERE je_source_name = p_je_source;

Line: 142

  SELECT je_from_sla_flag
    FROM gl_je_headers
   WHERE je_header_id = p_je_header_id;

Line: 293

  SELECT reference_6, reference_10 from gl_je_lines
   WHERE je_header_id = c_je_header_id
     AND je_line_num  = c_je_line_num;

Line: 301

  SELECT application_id
    FROM xla_subledgers
   WHERE je_source_name = p_je_source;

Line: 326

   SELECT count(*) into l_count FROM dual
   where exists (select 1 from xla_ae_lines ael,gl_import_references gir
                 where ael.gl_sl_link_id = gir.gl_sl_link_id
		 and   ael.gl_sl_link_table = gir.gl_sl_link_table
		 and   gir.je_header_id = p_je_header_id
		 and   gir.je_line_num = p_je_line_num); --included je_line_num join condition to imporve the performance

Line: 337

      SELECT je_from_sla_flag INTO l_je_from_sla_flag FROM gl_je_headers
      WHERE je_header_id = p_je_header_id;