APPS.BIS_RKPI SQL Statements

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

Line: 19

   h_sql := 'SELECT DISTINCT sn, gr FROM '||
   -- non nested items
   		'((SELECT SUBSTR(A.attribute2,'||
		' INSTR(A.attribute2, ''+'') + 1,'||
		' LENGTH(A.attribute2)-INSTR(A.attribute2, ''+''))'||
		' AS sn,'||
		' SUBSTR(A.attribute2,'||
		' 1,'||
		' INSTR(A.attribute2, ''+'') - 1)'||
		' AS gr'||
        ' FROM AK_REGION_ITEMS A'||
    	' WHERE A.region_code = :1'||
	    ' AND A.item_style <> ''NESTED_REGION'''||
        ' AND A.attribute1 IN (''DIM LEVEL SINGLE VALUE'', '||
		'''DIMENSION LEVEL'', ''HIDE DIMENSION LEVEL'', '||
		'''HIDE PARAMETER'', ''HIDE VIEW BY DIMENSION'', '||
		'''HIDE_VIEW_BY_DIM_SINGLE'', ''COMPARE TO DIMENSION LEVEL'', '||
		'''VIEWBY PARAMETER'')'||
		' AND A.attribute2 IS NOT NULL)'||
		' UNION '||
	-- nested items
		'(SELECT SUBSTR(A.attribute2,'||
		' INSTR(A.attribute2, ''+'') + 1,'||
		' LENGTH(A.attribute2)-INSTR(A.attribute2, ''+''))'||
		' AS sn,'||
		' SUBSTR(A.attribute2,'||
		' 1,'||
		' INSTR(A.attribute2, ''+'') - 1)'||
		' AS gr'||
        ' FROM AK_REGION_ITEMS A'||
    	' WHERE A.region_code IN '||
			'(SELECT B.nested_region_code '||
					'FROM AK_REGION_ITEMS B '||
					'WHERE B.region_code = :2 '||
					'AND B.ITEM_STYLE = ''NESTED_REGION'')'||
        ' AND A.attribute1 IN (''DIM LEVEL SINGLE VALUE'', '||
		'''DIMENSION LEVEL'', ''HIDE DIMENSION LEVEL'', '||
		'''HIDE PARAMETER'', ''HIDE VIEW BY DIMENSION'', '||
		'''HIDE_VIEW_BY_DIM_SINGLE'', ''COMPARE TO DIMENSION LEVEL'', '||
		'''VIEWBY PARAMETER'')'||
		' AND A.attribute2 IS NOT NULL))'||
        ' ORDER BY sn';

Line: 121

   h_sql := 'SELECT b2.name'||
            ' FROM BIS_LEVELS_TL b2, BIS_LEVELS b1'||
            ' WHERE b1.SHORT_NAME = :1'||
		' AND b1.LEVEL_ID = b2.LEVEL_ID'||
	      ' AND b2.language = :2';