APPS.BSC_DIMENSION_SETS_PUB dependencies on BSC_BIS_DIMENSION_PUB

Line 58: AND Short_Name <> BSC_BIS_DIMENSION_PUB.Unassigned_Dim;

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
61: RETURN TRUE;
62: ELSE

Line 1537: AND C.Short_Name <> BSC_BIS_DIMENSION_PUB.Unassigned_Dim

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
1539: ORDER BY A.Dim_Level_Index;
1540:
1541: CURSOR c_kpi_dim_set_relations IS