The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
status , fnd_document_id, file_id
INTO
l_status , l_fnd_document_id, l_file_id_template
FROM
edr_files_b
WHERE
file_name = p_style_sheet
AND
version_label = p_style_sheet_ver
AND
attribute_category = 'EDR_EREC_TEMPLATE';
SELECT fnl.FILE_DATA into x_ss_blob
FROM
fnd_lobs fnl,
fnd_attached_documents fnddoc,
fnd_documents_vl fndt
WHERE fnddoc.ENTITY_NAME = 'EDR_XSLFO_TEMPLATE'
AND fnddoc.pk1_value = to_Char(l_file_id_template)
AND fnddoc.document_id = fndt.document_id
AND fndt.media_id = fnl.file_id
AND fnddoc.document_id =(select max(document_id)
from
fnd_attached_documents
where pk1_value = to_char(l_file_id_template)
and entity_name = 'EDR_XSLFO_TEMPLATE');
select fl.file_data, isign_files.ORIGINAL_FILE_NAME, isign_files.FILE_NAME
into l_file_data, l_file_name, l_display_name
from
fnd_lobs fl, fnd_documents_vl fdt, edr_files_b isign_files
where
isign_files.file_id = to_number(p_event_key,'999999999999.999999')
and fdt.document_id = isign_files.fnd_document_id
and fl.file_id = fdt.media_id;