APPS.FA_FASRCOST_XMLP_PKG SQL Statements

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

Line: 16

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

  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;

Line: 63

  SELECT period_counter,
         period_open_date,
         nvl(period_close_date, sysdate),
         fiscal_year
  INTO   l_period_PC,
         l_period_POD,
         l_period_PCD,
         l_period_FY
  FROM   FA_DEPRN_PERIODS
  WHERE  book_type_code = P_BOOK
  AND    period_name    = P_PERIOD1;

Line: 96

  Select deprn_calendar
  into   tax_calendar
  from fa_book_controls
--  where book_type_code = book_type_code;

Line: 102

  select deprn_calendar
  into corp_calendar
  from fa_book_controls
  --where book_type_code = distribution_source_book;

Line: 110

         SELECT period_counter,
         period_open_date,
         nvl(period_close_date, sysdate)
     INTO   l_period_PC,
         l_period_POD,
         l_period_PCD
     FROM   FA_DEPRN_PERIODS
     --WHERE  book_type_code = Distribution_Source_Book
     WHERE  book_type_code = chg_distribution_source_book
     AND    period_name    = P_PERIOD1;

Line: 124

     SELECT period_counter,
         period_open_date,
         nvl(period_close_date, sysdate)
     INTO   l_period_PC,
         l_period_POD,
         l_period_PCD
     FROM   FA_DEPRN_PERIODS
     --WHERE  book_type_code = Distribution_Source_Book
     WHERE  book_type_code = chg_distribution_source_book
     AND    Period1_PCD BETWEEN PERIOD_OPEN_DATE AND
	NVL(PERIOD_CLOSE_DATE, Period1_PCD);