APPS.EDR_ISIGN_TEMPLATE_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 38

     	   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';

Line: 66

     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');

Line: 117

        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;