The following lines contain the word 'select', 'insert', 'update' or 'delete':
select asset_name
from pa_project_assets
where project_id = x_project_id
AND asset_name = x_asset_name
AND (x_ROWID IS NULL OR x_ROWID <> pa_project_assets.ROWID);
select asset_number
from pa_project_assets
where asset_number = x_asset_number
AND (x_ROWID IS NULL OR x_ROWID <> pa_project_assets.ROWID);
select project_asset_id
from pa_project_asset_lines
where project_asset_id = x_project_asset_id;
select distinct faa.asset_number
from fa_additions faa,
fa_asset_invoices fai,
pa_project_asset_lines ppal
where
ppal.project_asset_id = pa_asset_id AND
ppal.project_asset_line_id = fai.project_asset_line_id AND
fai.asset_id = faa.asset_id;
SELECT location_flex_structure
INTO x_dummy
FROM fa_system_controls;