APPS.CSI_CTR_GEN_UTILITY_PVT SQL Statements

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

Line: 55

         SELECT sid, osuser
         INTO   l_sid, l_os_user
         FROM   v$session
         WHERE  audsid = (SELECT userenv('SESSIONID') FROM dual);

Line: 67

         SELECT instr(g_debug_file,'.')
         INTO   l_instr
         FROM   dual;

Line: 79

            SELECT substr(g_debug_file,1,l_instr-1)||'-counter'||substr(g_debug_file,l_instr)
            INTO   l_log_file
            FROM   dual;

Line: 632

   SELECT bind_variable_name
   FROM csi_counter_relationships
   WHERE object_counter_id  = p_counter_id;

Line: 692

      SELECT formula_text
      INTO   l_formula
      FROM   csi_counters_v
      WHERE  counter_id = p_counter_id;

Line: 706

      l_formula := 'SELECT '||l_formula||' FROM DUAL';

Line: 805

   SELECT distinct ctr.counter_id, ctr.derive_function,
          ctr.derive_counter_id, ctr.derive_property_id
   FROM   csi_counters_bc_v ctr
   WHERE  ctr.counter_id = p_counter_id;

Line: 811

   SELECT filt.counter_property_id, filt.seq_no,filt.left_parent,
          filt.right_parent, filt.relational_operator,
          filt.logical_operator, filt.right_value,
          nvl(pro.default_value, 'NULL') as default_value,
          pro.property_data_type
   FROM   csi_counter_derived_filters filt, csi_ctr_properties_bc_v pro
   WHERE  filt.counter_id = b_counter_id
   AND    pro.counter_property_id(+) = filt.counter_property_id;

Line: 905

          l_sqlstr := 'select '||ctrs.derive_function||'( counter_reading )';

Line: 908

          l_sqlstr := l_sqlstr || ' select distinct cv.counter_value_id from ';