DBA Data[Home] [Help]

APPS.BSC_MO_HELPER_PKG dependencies on BSC_KPI_DIM_LEVELS_B

Line 19: bsc_kpi_dim_levels_b kpidim,

15: -- Moved API from PL/SQL for loop into SQL itself for performance
16: cursor cMissingViews is
17: select distinct sysdim.short_name, sysdim.level_view_name
18: from bsc_sys_dim_levels_b sysdim,
19: bsc_kpi_dim_levels_b kpidim,
20: bsc_tmp_opt_ui_kpis proc
21: where proc.process_id = bsc_metadata_optimizer_pkg.g_ProcessID
22: and proc.indicator=kpidim.indicator
23: and kpidim.level_table_name = sysdim.level_table_name