APPS.BIS_JAVASCRIPTLOV_PVT SQL Statements

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

Line: 118

    SELECT source
    FROM  bis_levels WHERE short_name = cp_dim_level_short_name ;

Line: 132

		l_lov_sql := 'select measure_id, measure_name from bisfv_performance_measures  perfMeasuresList, BSC_SYS_DATASETS_B ds WHERE perfMeasuresList.dataset_id = ds.dataset_id AND perfMeasuresList.Obsolete = ''F'' AND ds.source = '||'''' || l_meas_src ||'''';

Line: 176

		l_lov_sql := 'select target_level_id || ''+'' || dimension1_level_id || ''+'' || dimension2_level_id || ''+'' || dimension3_level_id
		              || ''+'' || dimension4_level_id || ''+'' || dimension5_level_id || ''+'' || dimension6_level_id || ''+'' || dimension7_level_id, '
			      || l_temp || '
			     from bisfv_target_levels ';

Line: 210

           l_lov_sql := 'SELECT name, display_name FROM WF_ROLE_LOV_VL ';

Line: 216

		l_lov_sql := 	' select responsibility_id, responsibility_name ' ||
				' from fnd_responsibility_vl where upper(responsibility_name) like ' || 'replace('|| ':1' || ',' || '''''''''' || ',' || '''''''''''''' || ') ';

Line: 226

          BIS_PMF_GET_DIMLEVELS_PVT.GET_DIMLEVEL_SELECT_STRING
          (p_DimLevelName => p_parameter1
          ,x_Select_String => l_lov_sql
          ,x_table_name => l_table_name
          ,x_id_name => l_id_name
          ,x_value_name => l_value_name
          ,x_time_level => l_time_level
          ,x_return_status => l_return_status
          ,x_msg_count => l_msg_count
          ,x_msg_data => l_msg_data);