APPS.FA_FAS460_XMLP_PKG SQL Statements

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

Line: 24

         select bc.book_type_code,
                bc.accounting_flex_structure,
                sob.currency_code,
                cur.precision,
		dp.period_counter
         into   l_book,
                l_accounting_flex_structure,
                l_currency_code,
                l_precision,
		l_per_ctr
         from fa_book_controls bc,
              gl_sets_of_books sob,
              fnd_currencies cur,
		fa_deprn_periods dp
         where bc.book_type_code = P_BOOK
         and   bc.date_ineffective is null
         and   sob.set_of_books_id = bc.set_of_books_id
         and   sob.currency_code = cur.currency_code
	and 	dp.book_type_code = P_BOOK
	and	P_END_DATE_ACQ between
 	  dp.period_open_date and 				 nvl(dp.period_close_date, P_END_DATE_ACQ+1);

Line: 66

  SELECT cr.concurrent_program_id
  INTO l_conc_program_id
  FROM FND_CONCURRENT_REQUESTS cr
  WHERE cr.program_application_id = 140
  AND   cr.request_id = P_CONC_REQUEST_ID;

Line: 71

  SELECT cp.user_concurrent_program_name
  INTO   l_report_name
  FROM    FND_CONCURRENT_PROGRAMS_VL cp
  WHERE
      cp.concurrent_program_id= l_conc_program_id
  and cp.application_id = 140;