APPS.BSC_BIS_DIM_OBJ_PUB dependencies on BSC_SYS_DIM_GROUPS_VL

Line 2084: FROM BSC_SYS_DIM_GROUPS_VL

2080: l_count NUMBER;
2081:
2082: CURSOR c_dimension_names IS
2083: SELECT short_name
2084: FROM BSC_SYS_DIM_GROUPS_VL
2085: WHERE dim_group_id IN (SELECT dim_group_id
2086: FROM BSC_SYS_DIM_LEVELS_BY_GROUP
2087: WHERE dim_level_id = l_bsc_dim_obj_rec.Bsc_Level_Id);
2088:

Line 3042: FROM BSC_SYS_DIM_GROUPS_VL

3038: WHERE short_name = p_dim_obj_short_name;
3039:
3040: CURSOR c_dimension_names IS
3041: SELECT short_name
3042: FROM BSC_SYS_DIM_GROUPS_VL
3043: WHERE dim_group_id IN (SELECT dim_group_id
3044: FROM BSC_SYS_DIM_LEVELS_BY_GROUP
3045: WHERE dim_level_id = l_dim_level_id);
3046:

Line 3592: FROM BSC_SYS_DIM_GROUPS_VL

3588: FROM BSC_SYS_DIM_LEVELS_VL A
3589: , BSC_SYS_DIM_LEVELS_BY_GROUP B
3590: WHERE A.dim_level_id = B.dim_level_id
3591: AND B.dim_group_id = (SELECT dim_group_id
3592: FROM BSC_SYS_DIM_GROUPS_VL
3593: WHERE Short_Name = p_dim_short_name);
3594: BEGIN
3595: FOR cd IN c_dimension_obj_name LOOP
3596: l_name := cd.name;

Line 5547: FROM BSC_SYS_DIM_GROUPS_VL

5543: WHERE short_name = p_dim_obj_short_name;
5544:
5545: CURSOR c_Dimension_Names IS
5546: SELECT Short_Name
5547: FROM BSC_SYS_DIM_GROUPS_VL
5548: WHERE dim_group_id IN
5549: (SELECT dim_group_id
5550: FROM BSC_SYS_DIM_LEVELS_BY_GROUP
5551: WHERE dim_level_id = l_bsc_dim_obj_rec.Bsc_Level_Id);

Line 5580: , BSC_SYS_DIM_GROUPS_VL C

5576: SELECT DISTINCT B.Name||'['||B.Indicator||']' Name
5577: ,B.Indicator
5578: FROM BSC_KPI_DIM_GROUPS A
5579: , BSC_KPIS_VL B
5580: , BSC_SYS_DIM_GROUPS_VL C
5581: WHERE A.INDICATOR = B.INDICATOR
5582: AND A.dim_group_id = C.Dim_Group_ID
5583: AND B.share_flag <> 2
5584: AND INSTR(l_new_dim_Grps, ','||C.Short_Name||',') > 0;

Line 5646: , BSC_SYS_DIM_GROUPS_VL B

5642: )) LOOP
5643: SELECT COUNT(0)
5644: INTO l_count
5645: FROM BSC_SYS_DIM_LEVELS_BY_GROUP A
5646: , BSC_SYS_DIM_GROUPS_VL B
5647: WHERE A.Dim_Level_Id = l_bsc_dim_obj_rec.Bsc_Level_Id
5648: AND B.Short_Name = l_dim_Grp_name
5649: AND B.Dim_Group_Id = A.Dim_Group_Id;
5650:

Line 5791: ,BSC_SYS_DIM_GROUPS_VL B

5787: CURSOR cr_kpidimset_dim IS
5788: SELECT A. INDICATOR
5789: ,A.DIM_SET_ID
5790: FROM BSC_KPI_DIM_GROUPS A
5791: ,BSC_SYS_DIM_GROUPS_VL B
5792: WHERE A.DIM_GROUP_ID = B.DIM_GROUP_ID
5793: AND B.SHORT_NAME = l_dim_short_name;
5794:
5795: CURSOR cr_dimobj_in_dimset IS