APPS.IEM_SENDMAIL_PVT dependencies on FND_LOBS

Line 47: FROM jtf_amv_items_tl b ,jtf_amv_attachments a ,fnd_lobs fl

43:
44: l_val2:=l_tval||'(187)';
45: SELECT fl.file_id
46: INTO l_file_id
47: FROM jtf_amv_items_tl b ,jtf_amv_attachments a ,fnd_lobs fl
48: WHERE b.item_id = a.attachment_used_by_id
49: and a.attachment_used_by='ITEM'
50: AND a.file_id = fl.file_id
51: AND b.item_id=p_template_id

Line 56: from fnd_lobs

52: AND b.language=USERENV('LANG')
53: and rownum=1;
54: -- Store all the merge fields present in the templates
55: select file_data into v_data
56: from fnd_lobs
57: where file_id=l_file_id;
58: l_occur:=1;
59: l_mergetbl.delete; --To store all the merge fields
60: l_mindex:=1; --Index to store all the merge