APPS.BSC_BIS_DIM_OBJ_PUB dependencies on BSC_SYS_DIM_LEVEL_RELS_V

Line 4065: bsc_sys_dim_level_rels_v b

4061: (SELECT level_pk_col
4062: FROM bsc_sys_dim_levels_b
4063: WHERE dim_level_id =b.parent_dim_level_id) AS pk_col
4064: FROM
4065: bsc_sys_dim_level_rels_v b
4066: WHERE
4067: b.dim_level_id= p_Dim_Level_Rec.Bsc_Level_Id;
4068: BEGIN
4069: FND_MSG_PUB.Initialize;

Line 6412: FROM BSC_SYS_DIM_LEVEL_RELS_V R

6408: CURSOR c_Rel_Levels IS
6409: SELECT R.SHORT_NAME CHILD_SHORT_NAME
6410: , R.RELATION_COL PARENT_COL
6411: , L.LEVEL_VALUES_VIEW_NAME VIEW_NAME
6412: FROM BSC_SYS_DIM_LEVEL_RELS_V R
6413: , BIS_LEVELS L
6414: WHERE R.SHORT_NAME = L.SHORT_NAME
6415: AND L.SHORT_NAME = p_Dim_Obj_Short_Name
6416: AND R.SOURCE = 'PMF';

Line 7013: FROM BSC_SYS_DIM_LEVEL_RELS_V R

7009: CURSOR c_Rels IS
7010: SELECT R.RELATION_COL,
7011: R.DATA_SOURCE,
7012: R.DATA_SOURCE_TYPE
7013: FROM BSC_SYS_DIM_LEVEL_RELS_V R
7014: WHERE R.DIM_LEVEL_ID = R.PARENT_DIM_LEVEL_ID
7015: AND R.SHORT_NAME = p_Short_Name
7016: AND R.PARENT_SHORT_NAME = p_Short_Name
7017: AND R.SOURCE = BSC_UTILITY.c_PMF