The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT bc.book_type_code
FROM fa_books bks,
fa_book_controls bc
WHERE bks.book_type_code = bc.distribution_source_book
AND bks.book_type_code = bc.book_type_code
AND bks.asset_id = p_asset_id
AND bks.date_ineffective is null;
select parent_hierarchy_id
from fa_asset_hierarchy
where asset_id = px_asset_hdr_rec.asset_id;
select greatest(calendar_period_open_date,
least(sysdate, calendar_period_close_date))
from fa_deprn_periods
where book_type_code = px_asset_hdr_rec.book_type_code
and period_close_date is null;
select count(book_type_code)
into l_num_dummy
from fa_books b
where asset_id = px_asset_hdr_rec.asset_id
and date_ineffective is null;