APPS.BSC_MO_INDICATOR_PKG dependencies on BSC_SYS_DIM_LEVEL_RELS

Line 193: from bsc_sys_dim_level_rels rels,

189: IS
190: cursor cJoin (p_indicator NUMBER, p_dimset NUMBER, p_level_name VARCHAR2) IS
191: select distinct levels.level_table_name child_level, parent_levels.level_table_name parent_level,
192: relation_col parent_fk, level
193: from bsc_sys_dim_level_rels rels,
194: bsc_sys_dim_levels_b levels,
195: bsc_sys_dim_levels_b parent_levels,
196: bsc_kpi_dim_levels_b kpi_levels
197: where rels.dim_level_id = levels.dim_level_id

Line 323: FROM BSC_SYS_DIM_LEVEL_RELS RELS, BSC_SYS_DIM_LEVELS_B LVLA, BSC_SYS_DIM_LEVELS_B LVLB

319: l_dimension_levels BSC_METADATA_OPTIMIZER_PKG.tab_clsLevels;
320:
321: CURSOR cParentFK(p_lower_dim_table IN VARCHAR2, p_higher_dim_table IN VARCHAR2) IS
322: SELECT RELATION_COL
323: FROM BSC_SYS_DIM_LEVEL_RELS RELS, BSC_SYS_DIM_LEVELS_B LVLA, BSC_SYS_DIM_LEVELS_B LVLB
324: WHERE LVLA.level_table_name = p_lower_dim_table
325: AND LVLB.level_table_name = p_higher_dim_table
326: AND LVLA.dim_level_id = rels.dim_level_id
327: AND LVLB.dim_level_id = rels.parent_dim_level_id;

Line 2750: (select dim_level_id from bsc_sys_dim_level_rels

2746: and level_table_name in (
2747: select level_table_name from bsc_sys_dim_levels_b
2748: where short_name in ('|| gRecDims||')
2749: or dim_level_id in
2750: (select dim_level_id from bsc_sys_dim_level_rels
2751: where dim_level_id = parent_dim_level_id))
2752: ';
2753:
2754: OPEN CV for l_stmt using pIndicator, pKey;