The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT bc.book_type_code,
bc.accounting_flex_structure,
bc.distribution_source_book,
sob.currency_code,
cur.precision
INTO l_book,
l_accounting_flex_Structure,
l_distribution_source_book,
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 sob.set_of_books_id = bc.set_of_books_id
AND sob.currency_code = cur.currency_code;
SELECT period_name,
period_open_date
INTO l_period_name,
l_period_POD
FROM FA_DEPRN_PERIODS
WHERE book_type_code = P_BOOK
AND period_name = P_PERIOD1;
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;
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;
SELECT period_name,
nvl(period_close_date, sysdate)
INTO l_period_name,
l_period_PCD
FROM FA_DEPRN_PERIODS
WHERE book_type_code = P_BOOK
AND period_name = P_PERIOD2;
select meaning
into l_meaning
from fa_lookups
where lookup_type = 'ASSET TYPE'
and lookup_code = 'CIP';
select meaning
into l_meaning
from fa_lookups
where lookup_type = 'ASSET TYPE'
and lookup_code = 'CAPITALIZED';
select meaning
into l_meaning
from FA_LOOKUPS
where lookup_type = 'ASSET TYPE'
and lookup_code = 'EXPENSED';