The following lines contain the word 'select', 'insert', 'update' or 'delete':
select a.file_name, b.description, a.file_id
into l_filename, l_description, l_fileid
from
jtf_amv_attachments a,
jtf_amv_items_vl b,
ibe_dsp_lgl_phys_map c
where
c.item_id = l_logid and
c.msite_id = p_siteid and
c.language_code = p_langcode and
c.item_id = b.item_id and
c.attachment_id = a.attachment_id and
a.application_id = 671 and
b.application_id = 671;
select a.file_name, b.description, a.file_id
into l_filename, l_description, l_fileid
from
jtf_amv_attachments a,
jtf_amv_items_vl b,
ibe_dsp_lgl_phys_map c
where
c.item_id = l_logid and
c.default_site = 'Y' and
c.language_code = p_langcode and
c.default_language = 'N' and
c.attachment_id = a.attachment_id and
c.item_id = b.item_id and
a.application_id = 671 and
b.application_id = 671;
select a.file_name, b.description, a.file_id
into l_filename, l_description, l_fileid
from
jtf_amv_attachments a,
jtf_amv_items_vl b,
ibe_dsp_lgl_phys_map c
where
c.item_id = l_logid and
c.msite_id = p_siteid and
c.default_site = 'N' and
c.default_language = 'Y' and
c.attachment_id = a.attachment_id and
c.item_id = b.item_id and
a.application_id = 671 and
b.application_id = 671;
select a.file_name, b.description, a.file_id
into l_filename, l_description, l_fileid
from
jtf_amv_attachments a,
jtf_amv_items_vl b,
ibe_dsp_lgl_phys_map c
where
c.item_id = l_logid and
c.default_site = 'Y' and
c.default_language = 'Y' and
c.attachment_id = a.attachment_id and
c.item_id = b.item_id and
a.application_id = 671 and
b.application_id = 671;
select a.file_name, b.description, a.file_id
into l_filename, l_description, l_fileid
from
jtf_amv_attachments a,
jtf_amv_items_vl b,
ibe_dsp_lgl_phys_map c
where
b.access_name = l_accessname and
c.msite_id = p_siteid and
c.language_code = p_langcode and
c.item_id = b.item_id and
c.attachment_id = a.attachment_id and
a.application_id = 671 and
b.application_id = 671;
select a.file_name, b.description, a.file_id
into l_filename, l_description, l_fileid
from
jtf_amv_attachments a,
jtf_amv_items_vl b,
ibe_dsp_lgl_phys_map c
where
b.access_name = l_accessname and
c.default_site = 'Y' and
c.language_code = p_langcode and
c.default_language = 'N' and
c.attachment_id = a.attachment_id and
c.item_id = b.item_id and
a.application_id = 671 and
b.application_id = 671;
select a.file_name, b.description, a.file_id
into l_filename, l_description, l_fileid
from
jtf_amv_attachments a,
jtf_amv_items_vl b,
ibe_dsp_lgl_phys_map c
where
b.access_name = l_accessname and
c.msite_id = p_siteid and
c.default_site = 'N' and
c.default_language = 'Y' and
c.attachment_id = a.attachment_id and
c.item_id = b.item_id and
a.application_id = 671 and
b.application_id = 671;
select a.file_name, b.description, a.file_id
into l_filename, l_description, l_fileid
from
jtf_amv_attachments a,
jtf_amv_items_vl b,
ibe_dsp_lgl_phys_map c
where
b.access_name = l_accessname and
c.default_site = 'Y' and
c.default_language = 'Y' and
c.attachment_id = a.attachment_id and
c.item_id = b.item_id and
a.application_id = 671 and
b.application_id = 671;