APPS.BSC_DIMENSION_SETS_PUB dependencies on BSC_SYS_DIM_GROUPS_VL

Line 51: ( p_Dim_Group_Id IN BSC_SYS_DIM_GROUPS_VL.Dim_Group_Id%TYPE

47: /*********************************************************************************************
48: This function will return true if passed dimension id is valid and not equal to "UNASSIGNED"
49: *********************************************************************************************/
50: FUNCTION Is_Valid_Dimension
51: ( p_Dim_Group_Id IN BSC_SYS_DIM_GROUPS_VL.Dim_Group_Id%TYPE
52: ) RETURN BOOLEAN IS
53: l_Count NUMBER := 0;
54: BEGIN
55: SELECT COUNT(Dim_Group_ID) INTO l_Count

Line 56: FROM BSC_SYS_DIM_GROUPS_VL

52: ) RETURN BOOLEAN IS
53: l_Count NUMBER := 0;
54: BEGIN
55: SELECT COUNT(Dim_Group_ID) INTO l_Count
56: FROM BSC_SYS_DIM_GROUPS_VL
57: WHERE Dim_Group_Id = p_Dim_Group_Id
58: AND Short_Name <> BSC_BIS_DIMENSION_PUB.Unassigned_Dim;
59:
60: IF (l_Count <> 0) THEN

Line 1534: , BSC_SYS_DIM_GROUPS_VL C

1530: , A.Comparison_Flag
1531: , B.Source
1532: FROM BSC_SYS_DIM_LEVELS_BY_GROUP A
1533: , BSC_SYS_DIM_LEVELS_VL B
1534: , BSC_SYS_DIM_GROUPS_VL C
1535: WHERE A.Dim_Group_Id = p_Dim_Set_Rec.Bsc_Dim_Level_Group_Id
1536: AND C.Dim_Group_Id = A.Dim_Group_Id
1537: AND C.Short_Name <> BSC_BIS_DIMENSION_PUB.Unassigned_Dim
1538: AND A.Dim_Level_Id = B.Dim_Level_Id