APPS.FA_FAS540_XMLP_PKG SQL Statements

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

Line: 22

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

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

        SELECT bc.book_type_code,
               bc.accounting_flex_structure,
               bc.distribution_source_book,
               bc.fiscal_year_name,
               sob.currency_code,
               cur.precision
        INTO   l_book,
               l_accounting_flex_structure,
               l_dist_book,
               l_fiscal_year_name,
               l_currency_code,
               l_precision
        FROM   fa_book_controls bc,
               gl_sets_of_books sob,
               fnd_currencies cur
        WHERE  bc.book_type_code = P_BOOK
        AND    bc.date_ineffective is null
        AND    bc.set_of_books_id = sob.set_of_books_id
        AND    sob.currency_code = cur.currency_code;

Line: 85

         select period_name,
                period_counter
         into l_period_name,
              l_period_counter
         from fa_deprn_periods
         where book_type_code = P_BOOK
         and   period_name = P_PERIOD1;

Line: 102

        select period_name,
               period_counter
        into   l_period_name,
               l_period_counter
        from fa_deprn_periods
        where book_type_code = P_BOOK
        and   period_name = P_PERIOD2;