The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT 1 FROM dual WHERE exists (
SELECT attachment_used_by_id FROM JTF_AMV_ATTACHMENTS
WHERE attachment_id = p_attachment_id);
SELECT 1 FROM dual WHERE exists (
SELECT attachment_used_by_id FROM JTF_AMV_ATTACHMENTS
WHERE attachment_id = p_attachment_id
AND object_version_number=p_object_version_number);
SELECT attachment_used_by_id FROM JTF_AMV_ATTACHMENTS
WHERE attachment_id = p_attachment_id;
SELECT context_type_code FROM JTF_DSP_CONTEXT_B WHERE
context_id = p_context_id ;
SELECT 1 from dual where exists(
SELECT context_id FROM JTF_DSP_CONTEXT_B WHERE
context_id = p_context_id and context_type_code = p_context_type);
SELECT 1 from dual where exists(
SELECT context_id FROM JTF_DSP_CONTEXT_B WHERE
context_id = p_context_id and context_type_code = p_context_type
and object_version_number = p_object_version_number);
select count(*) from FND_LOOKUP_VALUES_VL WHERE
lookup_type = 'JTF_AMV_DELV_TYPE_CODE' and
lookup_code = p_context_type and
enabled_flag = 'Y';
select 1 from dual where exists (
select lookup_code from FND_LOOKUP_VALUES_VL WHERE
lookup_type = 'IBE_RELATIONSHIP_RULE_OBJ_TYPE' and
lookup_code = p_object_type and
lookup_code <> 'N' and
enabled_flag = 'Y');
SELECT 1 from dual where exists(
SELECT access_name FROM JTF_DSP_CONTEXT_B WHERE
access_name = p_context_accessname );
SELECT 1 from dual where exists(
SELECT access_name FROM JTF_DSP_CONTEXT_B WHERE
access_name = p_context_accessname and
context_id <> p_context_id );
SELECT 1 from dual where exists (select tpl_ctg_id from jtf_dsp_tpl_ctg where
category_id = p_category_id and item_id = p_template_id);
SELECT 1 from dual where exists (
select category_id from mtl_categories where category_id=p_category_id);
SELECT 1 from dual where exists (
select distinct inventory_item_id from mtl_system_items
where inventory_item_id = p_item_id);
SELECT 1 from dual where exists (
select section_id from jtf_dsp_sections_b where
section_id = p_section_id);
SELECT 1 from dual where exists (
select section_id from jtf_dsp_sections_b where
section_id = p_section_id );
select 1 from dual where exists (
SELECT item_id FROM JTF_AMV_ITEMS_B
WHERE item_id = p_deliverable_id and
deliverable_type_code = p_item_type );
select 1 from dual where exists (
SELECT item_id FROM JTF_AMV_ITEMS_B
WHERE item_id = p_deliverable_id and
deliverable_type_code = p_item_type and
applicable_to_code = p_applicable_to);
select 1 from dual where exists (
SELECT item_id FROM JTF_AMV_ITEMS_B
WHERE item_id = p_deliverable_id);
select 1 from dual where exists (
SELECT item_id FROM JTF_AMV_ITEMS_B
WHERE item_id = p_deliverable_id and
object_version_number = p_object_version_number);
SELECT 1 from dual where exists (
SELECT obj_lgl_ctnt_id FROM JTF_DSP_OBJ_LGL_CTNT
WHERE obj_lgl_ctnt_id = p_lgl_ctnt_id);
SELECT 1 from dual where exists (
select obj_lgl_ctnt_id FROM JTF_DSP_OBJ_LGL_CTNT
WHERE obj_lgl_ctnt_id = p_lgl_ctnt_id and
object_version_number = p_object_version_number);
SELECT 1 FROM dual WHERE EXISTS (
SELECT file_name FROM JTF_AMV_ATTACHMENTS
WHERE file_name = p_file_name);
SELECT 1 FROM dual WHERE EXISTS (
SELECT file_name FROM JTF_AMV_ATTACHMENTS
WHERE file_name = p_file_name and attachment_id <> p_attachment_id);
SELECT 1 from dual where exists (
SELECT msite_id FROM JTF_MSITES_B where msite_id = p_msite_id);
select 1 from dual where exists (
SELECT msite_id FROM JTF_MSITES_B
WHERE msite_id = p_msite_id
and object_version_number = p_object_version_number);
SELECT 1 from dual where exists (
SELECT lgl_phys_map_id FROM JTF_DSP_LGL_PHYS_MAP
where lgl_phys_map_id = p_lgl_phys_map_id);
SELECT 1 FROM dual WHERE EXISTS (
SELECT access_name FROM JTF_AMV_ITEMS_B
WHERE access_name = p_access_name);
SELECT 1 FROM dual WHERE EXISTS (
SELECT access_name FROM JTF_AMV_ITEMS_B
WHERE access_name = p_access_name AND item_id <> p_item_id);
-- update
OPEN deliverable_accessname_cur(p_deliverable_id, p_access_name);
SELECT 1 from dual where exists (
SELECT b.language_code FROM
JTF_MSITES_B A, JTF_MSITE_LANGUAGES B where
A.msite_id = p_msite_id and
B.msite_id = A.msite_id and
-- A.end_date_active is null AND
B.language_code = p_language_code );
SELECT 1 from dual where exists
(SELECT A.ITEM_ID from JTF_DSP_TPL_CTG A, MTL_ITEM_CATEGORIES B where
B.INVENTORY_ITEM_ID = p_item_id and
B.CATEGORY_ID = A.CATEGORY_ID AND
A.ITEM_ID= p_deliverable_id );
SELECT 1 from dual where exists
(SELECT ITEM_ID from JTF_DSP_TPL_CTG where category_id = p_category_id and
ITEM_ID= p_deliverable_id );
SELECT msite_id FROM JTF_MSITES_B where master_msite_flag='Y';
SELECT attachment_id FROM JTF_AMV_ATTACHMENTS
WHERE file_name = p_file_name;
SELECT attachment_id FROM JTF_AMV_ATTACHMENTS
WHERE file_name = p_file_name AND
file_id = p_file_id AND
attachment_used_by_id = p_deliverable_id;
SELECT attachment_id FROM JTF_AMV_ATTACHMENTS
WHERE file_name = p_file_name AND
file_id is null AND
attachment_used_by_id = p_deliverable_id;
SELECT 1 FROM DUAL WHERE EXISTS (
SELECT attachment_used_by_id FROM JTF_AMV_ATTACHMENTS
WHERE attachment_id = p_attachment_id
AND attachment_used_by_id = p_deliverable_id);
SELECT 1 FROM DUAL WHERE EXISTS (
SELECT attachment_id FROM JTF_DSP_LGL_PHYS_MAP
WHERE attachment_id = p_attachment_id
AND default_site = 'Y'
AND default_language = 'Y');
Select 'x'
From jtf_msites_b
Where access_name = p_access_name ;