APPS.IBC_CITEM_PREVIEW_PVT SQL Statements

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

Line: 17

	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);

Line: 25

	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);

Line: 107

	select CONTENT_TYPE_CODE, ITEM_REFERENCE_CODE, ENCRYPT_FLAG
	from IBC_CONTENT_ITEMS
	where content_item_id = p_content_item_id;

Line: 112

	select VERSION_NUMBER, START_DATE, END_DATE
	from IBC_CITEM_VERSIONS_B
	where CITEM_VERSION_ID = p_citem_version_id;

Line: 117

	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'));

Line: 125

	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;

Line: 301

		    -- update max num levels
		    IF (x_num_levels_loaded > l_max_num_levels_loaded) THEN
		        l_max_num_levels_loaded := x_num_levels_loaded;