APPS.BIS_INTERMEDIATE_LOV_PVT SQL Statements

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

Line: 106

  l_sqlcount := 'select count(distinct id) from ('||l_temp||')';

Line: 184

   select dimension_short_name
         ,dimension_level_short_name
   ,level_values_view_name
   ,source
   from  bisfv_dimension_levels
   where dimension_level_id = cp_dim_level_id;

Line: 220

  BIS_PMF_GET_DIMLEVELS_PUB.GET_DIMLEVEL_SELECT_STRING(
    p_DimLevelShortName => l_dimlevel_shname
    ,p_bis_source => l_source
    ,x_Select_String => v_sql_stmnt
    ,x_table_name=>     v_table_name
    ,x_id_name=>        v_id_name
    ,x_value_name=>     v_value_name
    ,x_return_status=>  v_return_status
    ,x_msg_count=>      v_msg_count
    ,x_msg_data=>       v_msg_data
  );