APPS.BSC_DIMENSION_LEVELS_PVT dependencies on BSC_SYS_DIM_LEVELS_VL

Line 2185: SELECT NAME INTO v_Dim_Level_Name FROM BSC_SYS_DIM_LEVELS_VL

2181: v_Dim_Level_Name VARCHAR2(1000) := '' ;
2182:
2183: BEGIN
2184:
2185: SELECT NAME INTO v_Dim_Level_Name FROM BSC_SYS_DIM_LEVELS_VL
2186: WHERE DIM_LEVEL_ID = p_Child_level_Id;
2187:
2188: RETURN v_Dim_Level_Name;
2189:

Line 2246: FROM BSC_SYS_DIM_LEVEL_RELS LR, BSC_SYS_DIM_LEVELS_VL DL, BSC_SYS_DIM_LEVELS_VL PL

2242: , LR.RELATION_COL
2243: , LR.DATA_SOURCE_TYPE
2244: , LR.DATA_SOURCE
2245: , LR.RELATION_TYPE
2246: FROM BSC_SYS_DIM_LEVEL_RELS LR, BSC_SYS_DIM_LEVELS_VL DL, BSC_SYS_DIM_LEVELS_VL PL
2247: WHERE DL.dim_level_id = LR.dim_level_id
2248: AND PL.dim_level_id = LR.parent_dim_level_id
2249: AND LR.DIM_LEVEL_ID = p_Dim_Level_Rec.Bsc_Level_Id
2250: AND LR.PARENT_DIM_LEVEL_ID = p_Dim_Level_Rec.Bsc_Parent_Level_Id;

Line 2264: FROM BSC_SYS_DIM_LEVEL_RELS LR, BSC_SYS_DIM_LEVELS_VL DL, BSC_SYS_DIM_LEVELS_VL PL

2260: , LR.RELATION_COL
2261: , LR.DATA_SOURCE_TYPE
2262: , LR.DATA_SOURCE
2263: , LR.RELATION_TYPE
2264: FROM BSC_SYS_DIM_LEVEL_RELS LR, BSC_SYS_DIM_LEVELS_VL DL, BSC_SYS_DIM_LEVELS_VL PL
2265: WHERE DL.dim_level_id = LR.dim_level_id
2266: AND PL.dim_level_id = LR.parent_dim_level_id
2267: AND DL.SHORT_NAME = p_Dim_Level_Rec.Bsc_Level_Short_Name
2268: AND PL.SHORT_NAME = p_Dim_Level_Rec.Bsc_Parent_Level_Short_Name;

Line 2646: FROM BSC_SYS_DIM_LEVELS_VL

2642: ,x_Dim_Level_Rec.Bsc_Dim_Level_Long_Name
2643: ,x_Dim_Level_Rec.Bsc_Dim_Level_Help
2644: ,x_Dim_Level_Rec.Bsc_Dim_Tot_Disp_Name
2645: ,x_Dim_Level_Rec.Bsc_Dim_Comp_Disp_Name
2646: FROM BSC_SYS_DIM_LEVELS_VL
2647: WHERE short_name = p_Dim_Level_Rec.Bsc_Level_Short_Name;
2648:
2649:
2650: IF (p_Dim_Level_Rec.Bsc_Dim_Level_Long_Name IS NOT NULL) THEN