APPS.BSC_PMA_APIS_PUB SQL Statements

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

Line: 6

select dim_level_id, parent_dim_level_id from bsc_sys_dim_level_rels
where dim_level_id in(select dim_level_id from bsc_sys_dim_levels_b where short_name=p_dim_short_name);

Line: 64

select table_name, mv_name, data_source, sql_stmt, projection_source, projection_data
  from bsc_kpi_data_tables
 where indicator = p_objective
   and periodicity_id = p_periodicity_id
   and dim_set_id = p_dim_set_id
   and level_comb = p_level_pattern;