The following lines contain the word 'select', 'insert', 'update' or 'delete':
select count(*) into print_flag
from rg_report_parameters
where parameter_set_id = pset_id
and data_type = dtl_type;
select count(*) into print_flag
from rg_report_parameters
where parameter_set_id = pset_id
and data_type in ('B','E','C');
SELECT chart_of_accounts_id INTO COA_ID
FROM gl_access_sets WHERE access_set_id = P_ACCESS_SET_ID;
select short_name
from gl_ledgers
where gl_ledgers.ledger_id (+) = to_number(substr(segment,0, instr(segment,P_DELIMITER,1,1) -1) );