APPS.IEM_SENDMAIL_PVT SQL Statements

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

Line: 8

	cursor c1 is select lookup_code,meaning
	from fnd_lookups
	where enabled_flag = 'Y'
	AND NVL(start_date_active, SYSDATE) <= SYSDATE
	AND NVL(end_date_active,SYSDATE) >= SYSDATE
	AND lookup_type ='IEM_MERGE_FIELDS'
	ANd lookup_code like 'ACK%';

Line: 45

	SELECT fl.file_id
	INTO l_file_id
	FROM jtf_amv_items_tl b ,jtf_amv_attachments a ,fnd_lobs fl
	WHERE b.item_id = a.attachment_used_by_id
	and a.attachment_used_by='ITEM'
	AND a.file_id = fl.file_id
	AND b.item_id=p_template_id
	AND b.language=USERENV('LANG')
	and rownum=1;

Line: 55

	select file_data into v_data
	from fnd_lobs
	where file_id=l_file_id;

Line: 59

	 l_mergetbl.delete;		--To store all the merge fields

Line: 69

	execute immediate 'select '||l_val1||' from dual ' into l_string1;

Line: 70

	execute immediate 'select '||l_val2||' from dual ' into l_string2;