APPS.BIS_TARGET_UTIL SQL Statements

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

Line: 15

  select short_name
  into x_level_name
  from BIS_levels
  where level_id = p_level_id;

Line: 67

l_level_select_list1 Varchar2(2000) :=
      'lvl.wf_process,PLan.plan_id, plan.short_name,' ||
      'plan.version_no,plan.current_plan_flag' ;

Line: 70

l_level_select_list2 Varchar2(2000) :=
      ',val.target, val.range1_low, val.range1_high,' ||
      'val.range2_low, val.range2_high, val.range3_low, val.range3_high,' ||
      'val.role1_id,'||
      'val.role2_id,'||
      'val.role3_id,'||
      'val.role1,'||
      'val.role2,'||
      'val.role3';

Line: 79

l_level_select_list3 Varchar2(2000);

Line: 98

  BIS_debug_pub.add('Selecting row from BIS_target_levels for : '
         || p_ind_level_name);

Line: 101

  select *
  into l_trg_lvl_rec
  from BIS_target_levels
  where short_name = p_ind_level_name;

Line: 107

  BIS_debug_pub.add('Select Level Name For Time');

Line: 131

     l_level_select_list3 := ','||' substr(val.time_level_value,instr(val.time_level_value,''+'',1,1)+1) '
			  ||', '|| ' substr(val.time_level_value,-4), '
		          || 'substr(val.time_level_value,1,instr(val.time_level_value,''+'',1,1)-1)';

Line: 138

     l_level_select_list3 := ','||'substr(val.time_level_value,instr(val.time_level_value,''+'',1,1)+1) '
			  ||', '||'to_number(' ||'gl.period_year'||')'||','
		          || 'substr(val.time_level_value,1,instr(val.time_level_value,''+'',1,1)-1)';

Line: 155

     l_level_select_list1 := l_level_select_list1 || ',' || 'val.time_level_value';

Line: 162

  BIS_debug_pub.add('Select Level Name For Org');

Line: 179

        l_level_select_list1 := l_level_select_list1
                      || ',' || 'val.org_level_value';

Line: 185

  BIS_debug_pub.add('Select Level Name For Dimension 1');

Line: 202

        l_level_select_list1 := l_level_select_list1 || ','
                   || 'val.dimension1_level_value';

Line: 208

  BIS_debug_pub.add('Select Level Name For Dimension 2');

Line: 225

        l_level_select_list1 := l_level_select_list1 || ','
              || 'val.dimension2_level_value';

Line: 231

  BIS_debug_pub.add('Select Level Name For Dimension 3');

Line: 248

        l_level_select_list1 := l_level_select_list1 || ','
                       || 'val.dimension3_level_value';

Line: 254

  BIS_debug_pub.add('Select Level Name For Dimension 4');

Line: 271

        l_level_select_list1 := l_level_select_list1 || ','
             || 'val.dimension4_level_value';

Line: 277

  BIS_debug_pub.add('Select Level Name For Dimension 5');

Line: 294

        l_level_select_list1 := l_level_select_list1
             || ',' || 'val.dimension5_level_value';

Line: 307

  BIS_debug_pub.add(l_level_col_list3|| ') as select ' );

Line: 308

  BIS_debug_pub.add(l_level_select_list1 || l_level_select_list2|| l_level_select_list3);

Line: 318

			    || l_level_col_list3 || ') as select '
                            || l_level_select_list1
			    || l_level_select_list2
			    || l_level_select_list3
                            || ' ' || l_view_from_stmt ||' '||l_view_from_stmt2||' '||l_view_from_stmt3
               ,language_flag => DBMS_SQL.Native);

Line: 408

   select lvl.short_name
   from BIS_target_levels lvl,
        BIS_indicators ind
   where lvl.indicator_id = ind.indicator_id
   and ind.short_name = p_indicator_name;

Line: 416

   BIS_debug_pub.add('Select Levels for Indicator:' || p_indicator_name);

Line: 490

   select short_name
   from BIS_indicators ;

Line: 574

   select short_name into l_view_name from bis_target_levels
   where target_level_id = p_target_level_id;

Line: 630

  l_select_stmt Varchar2(2000);

Line: 635

   select level_values_view_name into l_view_name
   from bis_levels where level_id = p_dim_level_id;

Line: 640

  l_select_stmt := 'select value from '|| l_view_name
		   ||' where id = :dim_level_value_id';

Line: 644

		 statement => l_select_stmt,
		 language_flag => DBMS_SQL.Native);

Line: 691

  l_select_stmt Varchar2(2000);

Line: 697

   select level_values_view_name into l_view_name
   from bis_levels where level_id = p_dim_level_id;

Line: 703

   l_select_stmt := 'select v.responsibility_id, v.id, f.user_id '
		    ||' from '||l_view_name||' v, fnd_user_responsibility f '
		    ||' where v.responsibility_id = :responsibility_id '
		    ||' and v.id = :organization_id '
		    ||' and f.user_id = :user_id '
		    ||' and v.responsibility_id = f.responsibility_id '
		    ||' and f.start_date <= SYSDATE and nvl(f.end_date,SYSDATE) >= SYSDATE ';

Line: 712

		  statement => l_select_stmt,
		  language_flag => DBMS_SQL.NATIVE);