The following lines contain the word 'select', 'insert', 'update' or 'delete':
select profile_option_id, application_id
from fnd_profile_options
where profile_option_name = upper(pname)
and start_date_active <= sysdate
and nvl(end_date_active, sysdate) >= sysdate;
select profile_option_value
from fnd_profile_option_values
where profile_option_id = pid
and application_id = aid
and level_id = lid
and level_value = lval;
l_temp := 'select upper(sql_validation) from fnd_profile_options where profile_option_name = UPPER(:name)';
l_stmt := 'SELECT LOOKUP_CODE, MEANING FROM (' || l_sql ||
') WHERE LOOKUP_CODE = :val';
p_attribute_values.delete;
select min(para.value) into l_parallel
from v$parameter para
where para.name in ('cpu_count','parallel_max_servers');
SELECT current_date_id into l_date FROM bis_system_date;