APPS.EDR_FILE_UTIL_PUB SQL Statements

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

Line: 8

	select file_name into x_file_name
	from edr_files_b
	where file_id = p_file_id;

Line: 19

	select version_label into x_version_label
	from edr_files_b
	where file_id = p_file_id;

Line: 30

	select attribute_category into x_category_name
	from edr_files_b
	where file_id = p_file_id;

Line: 41

	SELECT A.USER_NAME into x_author_name
	FROM FND_USER A, EDR_FILES_B B
	WHERE A.USER_ID = B.CREATED_BY
	AND B.FILE_ID = p_file_id;

Line: 55

	l_str := 'select ' || p_attribute_col || ' from edr_files_b where file_id = ' || p_file_id;

Line: 65

	select a.file_data into x_file_data
	from 	fnd_lobs a,
		fnd_documents_vl b,
		edr_files_vl c
	where a.file_id = b.media_id
	and b.document_id = c.fnd_document_id
	and c.file_id = p_file_id;