The following lines contain the word 'select', 'insert', 'update' or 'delete':
Select file_data Into p_pdf_blob
From fnd_lobs
Where file_id = (select file_id from per_gb_xdo_templates
where file_id=p_template_id and
fnd_date.canonical_to_date(p_year) between EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE);
SELECT value
INTO l_audit_log_dir
FROM v$parameter
WHERE LOWER(name) = 'utl_file_dir';
SELECT value
INTO l_audit_log_dir
FROM v$parameter
WHERE LOWER(name) = 'utl_file_dir';