APPS.IBE_CATALOG_PRELOAD_PUB SQL Statements

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

Line: 76

	SELECT s.SECTION_ID
	FROM IBE_DSP_SECTIONS_B s
        WHERE sysdate between s.start_date_active and nvl(s.end_date_active,sysdate);

Line: 203

	SELECT DISTINCT si.INVENTORY_ITEM_ID
	FROM IBE_DSP_SECTIONS_B s, IBE_DSP_SECTION_ITEMS si, MTL_SYSTEM_ITEMS_B i
	WHERE s.SECTION_TYPE_CODE = 'F'	AND s.SECTION_ID = si.SECTION_ID
	AND si.INVENTORY_ITEM_ID = i.INVENTORY_ITEM_ID AND i.WEB_STATUS = 'PUBLISHED'
        AND sysdate between s.start_date_active and nvl(s.end_date_active,sysdate)
        AND sysdate between si.start_date_active and nvl(si.end_date_active,sysdate);