The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT sob.currency_code,
c.precision,
c.minimum_accountable_unit,
c.description
INTO base_curr,
prec,
min_au,
descr
FROM fnd_currencies_vl c,
fa_book_controls bc,
gl_sets_of_books sob
WHERE bc.book_type_code = P_ASSET_BOOK_TYPE
AND sob.set_of_books_id = bc.set_of_books_id
AND c.currency_code = sob.currency_code ;
SELECT ly.meaning,
ln.meaning,
l1.displayed_field,
l2.displayed_field,
l3.displayed_field
INTO nls_yes,
nls_no,
nls_all,
nls_void,
nls_na
FROM fnd_lookups ly,
fnd_lookups ln,
ap_lookup_codes l1,
ap_lookup_codes l2,
ap_lookup_codes l3
WHERE ly.lookup_type = 'YES_NO'
AND ly.lookup_code = 'Y'
AND ln.lookup_type = 'YES_NO'
AND ln.lookup_code = 'N'
AND l1.lookup_type = 'NLS REPORT PARAMETER'
AND l1.lookup_code = 'ALL'
AND l2.lookup_type = 'NLS TRANSLATION'
AND l2.lookup_code = 'VOID'
AND l3.lookup_type = 'NLS REPORT PARAMETER'
AND l3.lookup_code = 'NA';
SELECT DECODE(NVL(TO_CHAR(period_close_date), 'NULL'), 'NULL', 'Open', 'Closed')
INTO C_Last_Open
FROM fa_deprn_periods
WHERE book_type_code = P_ASSET_BOOK_TYPE
AND period_name = P_PERIOD_END_NAME;
SELECT name,
chart_of_accounts_id
INTO l_name,
l_chart_of_accounts_id
FROM gl_sets_of_books
WHERE set_of_books_id = l_sob_id;