APPS.JTF_FM_QUERY_LINK_PKG SQL Statements

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

Line: 108

select attachment_used_by_id
from jtf_fm_amv_attach_vl
where attachment_used_by_id = p_content_id;

Line: 113

select query_id
from jtf_fm_queries_all
where query_id = p_query_id;

Line: 118

select query_id, mes_doc_id
from jtf_fm_query_mes
where query_id = p_query_id
and mes_doc_id = p_content_id;

Line: 188

     INSERT INTO jtf_fm_query_mes (
     mes_doc_id,
     query_id,
     LAST_UPDATE_DATE,
     LAST_UPDATED_BY,
     LAST_UPDATE_LOGIN,
     CREATION_DATE,
     CREATED_BY
     ) values (
     p_content_id,
     p_query_id,
     sysdate,
     FND_GLOBAL.USER_ID,
     FND_GLOBAL.LOGIN_ID,
     sysdate,
     FND_GLOBAL.USER_ID
     );

Line: 301

select attachment_used_by_id
from jtf_fm_amv_attach_vl
where attachment_used_by_id = p_content_id;

Line: 306

select query_id
from jtf_fm_queries_all
where query_id = p_query_id;

Line: 311

select query_id, mes_doc_id
from jtf_fm_query_mes
where query_id = p_query_id
and mes_doc_id = p_content_id;

Line: 355

     DELETE FROM jtf_fm_query_mes
     WHERE mes_doc_id = p_content_id
     and query_id  = p_query_id;