APPS.BIS_PMV_ACTUAL_PVT SQL Statements

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

Line: 52

  select 'ACTUAL_'||bis_notification_id_s.nextval into l_session_id from dual;

Line: 118

  SELECT attribute8 plsql_function
  from ak_Regions
  where region_code = p_region_Code;

Line: 123

  SELECT attribute3 base_column
    FROM ak_region_items
   WHERE region_code = p_region_code
     AND attribute_code = cpAttributeCode;

Line: 129

  SELECT attribute_code, attribute3 base_column
    FROM ak_region_items
   WHERE region_code = p_region_code
     AND nested_region_code is null
     AND (   (attribute1 = 'MEASURE')
          or (attribute1 = 'MEASURE_NOTARGET')
          or (attribute1 is null and node_query_flag = 'N')
          or (attribute1 is null and node_display_flag = 'Y')
         );

Line: 482

          l_sql := 'select '||l_temp_actual_formula||' from dual';

Line: 513

          l_sql := 'select '||l_temp_compareto_formula||' from dual';

Line: 619

  SELECT attribute1 disable_viewby, attribute8 plsql_function
  from ak_Regions
  where region_code = p_region_Code;

Line: 623

  SELECT attribute_code, attribute2 from ak_region_items
  WHERE display_Sequence = (select min(display_sequence)
  from ak_region_items where region_code = pregioncode
  and attribute_code <> 'AS_OF_DATE') and region_code = pregioncode;

Line: 629

  SELECT attribute3 base_column
    FROM ak_region_items
   WHERE region_code = p_region_code
     AND attribute_code = cpAttributeCode;

Line: 635

  SELECT attribute_code, attribute3 base_column
    FROM ak_region_items
   WHERE region_code = p_region_code
     AND nested_region_code is null
     AND (   (attribute1 = 'MEASURE')
          or (attribute1 = 'MEASURE_NOTARGET')
          or (attribute1 is null and node_query_flag = 'N')
          or (attribute1 is null and node_display_flag = 'Y')
         );

Line: 647

  SELECT attribute_code
         FROM ak_region_items
  WHERE region_code = p_region_code
  and attribute2 = p_attrib_code
  and attribute1 = l_grand_total;

Line: 709

  select 'ACTUAL_'||bis_notification_id_s.nextval into l_session_id from dual;

Line: 726

   select attribute_code  into l_ranking_attr
   from ak_region_items
   where region_code = p_region_code and
         attribute2 = p_ranking_level;

Line: 1229

          l_sql := 'select '||l_temp_actual_formula||' from dual';

Line: 1275

          l_sql := 'select '||l_temp_compareto_formula||' from dual';

Line: 1707

  SELECT attribute1 disable_viewby, attribute8 plsql_function
  from ak_Regions
  where region_code = p_region_Code;

Line: 1712

  SELECT attribute_code, attribute2 from ak_region_items
  WHERE display_Sequence = (select min(display_sequence)
  from ak_region_items where region_code = pregioncode
  and attribute_code <> 'AS_OF_DATE') and region_code = pregioncode;

Line: 1718

  SELECT attribute3 base_column
    FROM ak_region_items
   WHERE region_code = p_region_code
     AND attribute_code = cpAttributeCode;

Line: 1724

  SELECT attribute_code, attribute3 base_column
    FROM ak_region_items
   WHERE region_code = p_region_code
     AND nested_region_code is null
     AND (   (attribute1 = 'MEASURE')
          or (attribute1 = 'MEASURE_NOTARGET')
          or (attribute1 is null and node_query_flag = 'N')
          or (attribute1 is null and node_display_flag = 'Y')
         );

Line: 1737

  SELECT attribute_code
         FROM ak_region_items
  WHERE region_code = p_region_code
  and attribute2 = p_attrib_code
  and attribute1 = l_grand_total;

Line: 1780

  l_selected_attr_codes BISVIEWER.t_char;

Line: 1781

  l_selected_base_columns BISVIEWER.t_char;

Line: 1782

  l_selected_base_columns2 BISVIEWER.t_char;

Line: 1783

  l_selected_measure_values BISVIEWER.t_char;

Line: 1784

  l_selected_gt_values BISVIEWER.t_char;

Line: 1785

  l_selected_col_index BISVIEWER.t_num;

Line: 1786

  l_selected_gt_index BISVIEWER.t_num;

Line: 1829

  select 'ACTUAL_'||bis_notification_id_s.nextval into l_session_id from dual;

Line: 1846

   select attribute_code  into l_ranking_attr
   from ak_region_items
   where region_code = p_region_code and
         attribute2 = p_ranking_level;

Line: 2010

             l_selected_col_index(l_measure_count) := i;

Line: 2011

             l_selected_attr_codes(l_measure_count) := l_measure_attr_codes(j);

Line: 2012

             l_selected_base_columns(l_measure_count) := l_measure_base_columns(j);

Line: 2039

      SORTBY_BASE_COLUMN_LENGTH(p_table1 => l_selected_base_columns
                               ,p_table2 => l_selected_attr_codes
                               ,p_table3 => l_selected_col_index
                               ,x_return_status => x_return_status
                               ,x_msg_count => x_msg_count
                               ,x_msg_data => x_msg_data
                               );

Line: 2072

          l_selected_gt_index(l_gt_count) := i;

Line: 2090

      dbms_sql.define_column(l_cursor, l_selected_col_index(i), l_measure_value, 200);

Line: 2157

           dbms_sql.column_value(l_cursor, l_selected_col_index(i), l_selected_measure_values(i));

Line: 2164

              dbms_sql.column_value(l_cursor, l_gt_index(i), l_selected_gt_values(i));

Line: 2184

                                       ,p_measure_base_columns => l_selected_base_columns
                                       ,p_measure_values => l_selected_measure_values
                                       ,x_calculated_value => l_measure_value);

Line: 2188

                   for k in 1..l_selected_attr_codes.COUNT loop
                      if p_measure_attribute_codes(i) = l_selected_attr_codes(k) then
                         l_measure_value := l_selected_measure_values(k);

Line: 2198

                        if p_measure_attribute_codes(i) = l_measure_attr_codes(l_selected_gt_index(n)) then
                           l_actual_rec.actual_grandtotal_value := l_selected_gt_values(n);

Line: 2210

                      if p_measure_attribute_codes(i) = l_measure_attr_codes(l_selected_gt_index(n)) then
                           l_actual_rec.actual_grandtotal_value := l_selected_gt_values(n);

Line: 2280

  l_sql := 'select '||l_formula||' from dual';