APPS.IBC_STYLESHEETS_GRP SQL Statements

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

Line: 22

	select LIVE_CITEM_VERSION_ID, CONTENT_ITEM_STATUS
	from IBC_CONTENT_ITEMS
	where content_item_id = p_stylesheet_item_id;

Line: 78

	select START_DATE, END_DATE
	from IBC_CITEM_VERSIONS_B
	where CITEM_VERSION_ID = p_stylesheet_version_id;

Line: 143

	select citem_version_id
	from IBC_CITEM_VERSION_LABELS
	where label_code = p_stylesheet_label_code and
	      content_item_id = p_stylesheet_item_id;

Line: 149

	select f.FILE_DATA
	from FND_LOBS f, IBC_CITEM_VERSIONS_VL v
	where v.CITEM_VERSION_ID = l_citem_version_id
	and v.ATTACHMENT_FILE_ID = f.FILE_ID;

Line: 247

	select s.CONTENT_ITEM_ID
	from IBC_STYLESHEETS s, IBC_CONTENT_ITEMS i
	where i.CONTENT_ITEM_ID = p_content_item_id
        and i.CONTENT_TYPE_CODE = s.CONTENT_TYPE_CODE
	and s.DEFAULT_STYLESHEET_FLAG = FND_API.G_TRUE;

Line: 335

	select s.CONTENT_ITEM_ID
	from IBC_STYLESHEETS s, IBC_CONTENT_ITEMS i
	where i.CONTENT_ITEM_ID = p_content_item_id
        and i.CONTENT_TYPE_CODE = s.CONTENT_TYPE_CODE
	and s.DEFAULT_STYLESHEET_FLAG = FND_API.G_TRUE;

Line: 484

	select CONTENT_ITEM_ID
	from IBC_CONTENT_ITEMS
	where ITEM_REFERENCE_CODE = p_stylesheet_ref_code;

Line: 586

	select s.CONTENT_ITEM_ID, p_stylesheets_label_code as LABEL,
	       userenv('LANG') as LANG
	from IBC_STYLESHEETS s, IBC_CONTENT_ITEMS i
	where i.CONTENT_ITEM_ID = p_content_item_id
        and i.CONTENT_TYPE_CODE = s.CONTENT_TYPE_CODE;