APPS.BSC_DBGEN_METADATA_READER SQL Statements

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

Line: 14

select source from BSC_DB_FACT_KPI_MAPS
where indicator= p_fact_id;*/

Line: 28

select object_name from BSC_DB_FACT_KPI_MAPS
where indicator= p_fact_id;*/

Line: 31

select name from bsc_kpis_vl
where indicator= p_fact_id;

Line: 45

select object_name, object_type, source from BSC_DB_FACT_KPI_MAPS
where indicator= p_fact_id;

Line: 49

select name, 1, 'BSC' from BSC_KPIS_VL
where indicator= p_fact_id;

Line: 261

select count(1) from bsc_sys_dim_level_rels
where dim_level_id=parent_dim_level_id
and dim_level_id in (select dim_level_id from bsc_sys_dim_levels_b where level_table_name=p_dim_level);

Line: 296

   p_data_source:='(select code from hri_table)';

Line: 297

   p_inc_data_source:='(select code from hri_table)';

Line: 321

   p_denorm_data_source:='(select employee, manager from hri_denorm_table)';

Line: 322

   p_denorm_change_data_source:='(select employee, manager from hri_denorm_change_table)';

Line: 340

select kpi.indicator from bsc_kpi_periodicities kpi,
bsc_sys_periodicities sysper
where kpi.periodicity_id = sysper.periodicity_id
and sysper.calendar_id= p_calendar_id;

Line: 371

SELECT calendar_id
FROM bsc_sys_periodicities sysper,
bsc_kpi_periodicities kpi
where kpi.periodicity_id = sysper.periodicity_id
and kpi.indicator = to_number(p_fact);

Line: 864

  g_assume_production_facts.delete;

Line: 879

select value from v$parameter where name=p_parameter;

Line: 953

select properties from bsc_db_tables
where table_name = p_table_name;

Line: 987

select table_name, partitioning_type, partition_count from all_part_tables where table_name=p_table_name
and owner=p_owner;

Line: 991

SELECT part_cols.column_name, tab_cols.data_type
  FROM all_tab_columns tab_cols
     , all_part_key_columns part_cols
 WHERE part_cols.name=p_table_name
   AND part_cols.owner = p_owner
   AND part_cols.name = tab_cols.table_name
   AND part_cols.column_name = tab_cols.column_name
   AND part_cols.owner = tab_cols.owner
   AND part_cols.object_type = p_table;

Line: 1002

select partition_name, high_value, partition_position
from all_tab_partitions where table_name=p_table_name
and table_owner = pOwner
order by partition_position;

Line: 1045

function get_last_update_date_for_fact(p_fact in varchar2) return date is
begin
  return bsc_dbgen_bsc_reader.get_last_update_date_for_fact(p_fact);

Line: 1075

  select reverse(p_dim_short_name) into l_reverse from dual;