The following lines contain the word 'select', 'insert', 'update' or 'delete':
select CITEM_VERSION_ID, VERSION_NUMBER, START_DATE, END_DATE
from IBC_CITEM_VERSIONS_B
where CONTENT_ITEM_ID = p_content_item_id
and VERSION_NUMBER = (select max(VERSION_NUMBER)
from IBC_CITEM_VERSIONS_B
where CONTENT_ITEM_ID = p_content_item_id);
select CITEM_VERSION_ID, VERSION_NUMBER, START_DATE, END_DATE
from IBC_CITEM_VERSIONS_B
where CONTENT_ITEM_ID = p_content_item_id
and VERSION_NUMBER = (select max(VERSION_NUMBER)
from IBC_CITEM_VERSIONS_B
where CONTENT_ITEM_ID = p_content_item_id
and CITEM_VERSION_STATUS = IBC_UTILITIES_PUB.G_STV_APPROVED);
select CONTENT_TYPE_CODE, ITEM_REFERENCE_CODE, ENCRYPT_FLAG
from IBC_CONTENT_ITEMS
where content_item_id = p_content_item_id;
select VERSION_NUMBER, START_DATE, END_DATE
from IBC_CITEM_VERSIONS_B
where CITEM_VERSION_ID = p_citem_version_id;
select ATTRIBUTE_FILE_ID, CONTENT_ITEM_NAME, DESCRIPTION, ATTACHMENT_ATTRIBUTE_CODE,
ATTACHMENT_FILE_ID, ATTACHMENT_FILE_NAME, DEFAULT_RENDITION_MIME_TYPE
from IBC_CITEM_VERSIONS_TL
where citem_version_id = p_citem_version_id
and language = nvl(p_lang_code, userenv('LANG'));
select r.ATTRIBUTE_TYPE_CODE, r.CONTENT_ITEM_ID,
r.SUBITEM_VERSION_ID, c.ENCRYPT_FLAG
from IBC_COMPOUND_RELATIONS r, IBC_CONTENT_ITEMS c
where r.CITEM_VERSION_ID = p_citem_version_id
and r.CONTENT_ITEM_ID = c.CONTENT_ITEM_ID
order by r.SORT_ORDER;
-- update max num levels
IF (x_num_levels_loaded > l_max_num_levels_loaded) THEN
l_max_num_levels_loaded := x_num_levels_loaded;