APPS.BSC_UPGRADES dependencies on BSC_SYS_DIM_LEVELS_BY_GROUP

Line 1649: FROM BSC_SYS_DIM_LEVELS_BY_GROUP

1645: EXCEPTION WHEN OTHERS THEN
1646: NULL;
1647: END;
1648: SELECT COUNT(1) INTO l_count
1649: FROM BSC_SYS_DIM_LEVELS_BY_GROUP
1650: WHERE dim_level_id = l_cn_dim_level_id
1651: AND dim_group_id = (SELECT Dim_Group_Id
1652: FROM BSC_SYS_DIM_GROUPS_VL WHERE SHORT_NAME = cd.Short_Name);
1653:

Line 2743: bsc_sys_dim_levels_by_group lvl_by_grp,

2739: CURSOR c_bsc_rel is
2740: SELECT bsc_lvl.short_name, bis_dim.dimension_id
2741: FROM bsc_sys_dim_groups_vl bsc_dim,
2742: bsc_sys_dim_levels_b bsc_lvl,
2743: bsc_sys_dim_levels_by_group lvl_by_grp,
2744: bis_dimensions bis_dim
2745: WHERE bsc_dim.dim_group_id = lvl_by_grp.dim_group_id
2746: AND bsc_lvl.dim_level_id = lvl_by_grp.dim_level_id
2747: /* AND bsc_dim.dim_group_id = bis_dim.dim_grp_id cannot use since dim_group_id is not updated on BIS side yet */