APPS.BSC_DIMENSION_SETS_PUB dependencies on BSC_SYS_DIM_LEVEL_RELS

Line 73: p_Dim_Level_Id IN BSC_SYS_DIM_LEVEL_RELS.DIM_LEVEL_ID%TYPE

69: This function will return the table name for a MxN type of relationship, otherwise return NULL
70: *********************************************************************************************/
71:
72: FUNCTION Get_MN_Table_Name (
73: p_Dim_Level_Id IN BSC_SYS_DIM_LEVEL_RELS.DIM_LEVEL_ID%TYPE
74: , p_Parent_Dim_Level_Id IN BSC_SYS_DIM_LEVEL_RELS.PARENT_DIM_LEVEL_ID%TYPE
75: ) RETURN VARCHAR2 IS
76: l_Table_Name BSC_SYS_DIM_LEVEL_RELS.RELATION_COL%TYPE;
77: BEGIN

Line 74: , p_Parent_Dim_Level_Id IN BSC_SYS_DIM_LEVEL_RELS.PARENT_DIM_LEVEL_ID%TYPE

70: *********************************************************************************************/
71:
72: FUNCTION Get_MN_Table_Name (
73: p_Dim_Level_Id IN BSC_SYS_DIM_LEVEL_RELS.DIM_LEVEL_ID%TYPE
74: , p_Parent_Dim_Level_Id IN BSC_SYS_DIM_LEVEL_RELS.PARENT_DIM_LEVEL_ID%TYPE
75: ) RETURN VARCHAR2 IS
76: l_Table_Name BSC_SYS_DIM_LEVEL_RELS.RELATION_COL%TYPE;
77: BEGIN
78: SELECT R.RELATION_COL INTO l_Table_Name

Line 76: l_Table_Name BSC_SYS_DIM_LEVEL_RELS.RELATION_COL%TYPE;

72: FUNCTION Get_MN_Table_Name (
73: p_Dim_Level_Id IN BSC_SYS_DIM_LEVEL_RELS.DIM_LEVEL_ID%TYPE
74: , p_Parent_Dim_Level_Id IN BSC_SYS_DIM_LEVEL_RELS.PARENT_DIM_LEVEL_ID%TYPE
75: ) RETURN VARCHAR2 IS
76: l_Table_Name BSC_SYS_DIM_LEVEL_RELS.RELATION_COL%TYPE;
77: BEGIN
78: SELECT R.RELATION_COL INTO l_Table_Name
79: FROM BSC_SYS_DIM_LEVEL_RELS R
80: WHERE R.DIM_LEVEL_ID = p_Dim_Level_Id

Line 79: FROM BSC_SYS_DIM_LEVEL_RELS R

75: ) RETURN VARCHAR2 IS
76: l_Table_Name BSC_SYS_DIM_LEVEL_RELS.RELATION_COL%TYPE;
77: BEGIN
78: SELECT R.RELATION_COL INTO l_Table_Name
79: FROM BSC_SYS_DIM_LEVEL_RELS R
80: WHERE R.DIM_LEVEL_ID = p_Dim_Level_Id
81: AND R.PARENT_DIM_LEVEL_ID = p_Parent_Dim_Level_Id
82: AND R.RELATION_TYPE = C_REL_MANY_TO_MANY;
83:

Line 1556: , BSC_SYS_DIM_LEVEL_RELS E

1552: FROM BSC_KPI_DIM_LEVELS_B A -- current
1553: , BSC_KPI_DIM_LEVELS_B B -- parent
1554: , BSC_SYS_DIM_LEVELS_B C -- current
1555: , BSC_SYS_DIM_LEVELS_B D -- parent
1556: , BSC_SYS_DIM_LEVEL_RELS E
1557: WHERE A.Indicator = p_Dim_Set_Rec.Bsc_Kpi_Id
1558: AND A.Dim_Set_Id = p_Dim_Set_Rec.Bsc_Dim_Set_Id
1559: AND A.Indicator = B.Indicator
1560: AND A.Dim_Set_Id = B.Dim_Set_Id

Line 1583: , BSC_SYS_DIM_LEVEL_RELS E

1579: FROM BSC_KPI_DIM_LEVELS_B A -- current
1580: , BSC_KPI_DIM_LEVELS_B B -- parent
1581: , BSC_SYS_DIM_LEVELS_B C -- current
1582: , BSC_SYS_DIM_LEVELS_B D -- parent
1583: , BSC_SYS_DIM_LEVEL_RELS E
1584: WHERE A.Indicator = p_Dim_Set_Rec.Bsc_Kpi_Id
1585: AND A.Dim_Set_Id = p_Dim_Set_Rec.Bsc_Dim_Set_Id
1586: AND A.Indicator = B.Indicator
1587: AND A.Dim_Set_Id = B.Dim_Set_Id