APPS.BIS_PMF_MIGRATION_PUB SQL Statements

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

Line: 33

   SELECT dimension_id
   FROM   bis_levels
   WHERE  level_id = p_dimension_level_id;

Line: 55

  SELECT count(1) FROM
  bis_indicator_dimensions
  WHERE indicator_id = p_measure_id;

Line: 232

  SELECT target_level_id, indicator_id, short_name
        ,time_level_id, org_level_id, dimension1_level_id
        ,dimension2_level_id, dimension3_level_id, dimension4_level_id
        ,dimension5_level_id
  FROM bis_target_levels;

Line: 238

  SELECT target_id, org_level_value, time_level_value
        ,dimension1_level_value, dimension2_level_value, dimension3_level_value
	,dimension4_level_value, dimension5_level_value
  FROM bis_target_values
  WHERE target_level_id = p_target_level_id;

Line: 302

                UPDATE bis_indicator_dimensions
                SET sequence_no = l_dummy_value
  	        WHERE dimension_id=l_Reseq_dims(l_count).dim_id AND
                      indicator_id=c_rec.indicator_id;

Line: 313

                UPDATE bis_indicator_dimensions
                SET    sequence_no= l_reseq_dims(l_count).seq_no
                WHERE  dimension_id = l_reseq_dims(l_count).dim_id AND
                       indicator_id = c_Rec.indicator_id;

Line: 320

            l_sqlstmt := 'UPDATE bis_target_levels SET ' ||
                        l_reseq_dims(1).dim_level_col ||' = :1' ||
                     ' , '||l_reseq_dims(2).dim_level_col ||' = :2'||
                     ' , '||l_reseq_dims(3).dim_level_col ||' = :3'||
                     ' , '||l_reseq_dims(4).dim_level_col ||' = :4'||
              	     ' , '||l_reseq_dims(5).dim_level_col ||' = :5'||
                     ' , '||l_reseq_dims(6).dim_level_col ||' = :6'||
                     ' , '||l_reseq_dims(7).dim_level_col ||' = :7'||
		     '  WHERE target_level_id =:8';

Line: 350

                 l_sqlstmt1 := 'UPDATE bis_target_values SET '||
                            l_reseq_target_values(1).target_level ||' = :1'||
                      ' ,'|| l_Reseq_target_values(2).target_level ||' = :2' ||
                      ' ,' || l_Reseq_target_values(3).target_level||' = :3'||
                      ' ,' || l_Reseq_target_values(4).target_level||' = :4' ||
                      ' ,' || l_Reseq_target_values(5).target_level||' = :5' ||
                      ' ,' || l_Reseq_target_values(6).target_level||' = :6' ||
                      ' ,' || l_Reseq_target_values(7).target_level||' = :7' ||
			' WHERE target_level_id = :8  AND target_id = :9';