APPS.BSC_BIS_KPI_MEAS_PUB dependencies on BSC_KPI_DIM_LEVELS_VL

Line 37: REM | to create and delete default row in BSC_KPI_DIM_LEVELS_VL |

33: REM | 14-NOV-2003 PAJOHRI Bug #3248729 |
34: REM | 08-DEC-2003 KYADAMAK Bug #3225685 |
35: REM | 07-JAN-2004 PAJOHRI Bug #3343860, created two new procudures |
36: REM | Create_Default_Kpi_Dim_Object & Delete_Default_Kpi_Dim_Object|
37: REM | to create and delete default row in BSC_KPI_DIM_LEVELS_VL |
38: REM | 16-JAN-2004 PAJOHRI Bug #3372305 |
39: REM | 29-JAN-2004 PAJOHRI Bug #3404081 |
40: REM | 15-MAR-2004 PAJOHRI Bug #3504996, Assign_DSet_Analysis_Options |
41: REM | procedure is modified, to flag stuct. changes. |

Line 2349: FROM BSC_KPI_DIM_LEVELS_VL

2345: --Source of Dim Levels present in this Dim Set should not be BSC
2346:
2347: SELECT count(1)
2348: INTO l_count
2349: FROM BSC_KPI_DIM_LEVELS_VL
2350: WHERE INDICATOR = p_Indicator
2351: AND DIM_SET_ID = p_DimSetId
2352: AND LEVEL_SOURCE = BSC_BIS_MEASURE_PUB.c_BSC;
2353:

Line 3849: FROM BSC_KPI_DIM_LEVELS_VL

3845: , x_Data_Set_Id OUT NOCOPY NUMBER
3846: ) IS
3847: CURSOR c_dimSetSource IS
3848: SELECT LEVEL_SOURCE
3849: FROM BSC_KPI_DIM_LEVELS_VL
3850: WHERE INDICATOR = p_Indicator
3851: AND DIM_SET_ID = p_DimSetId
3852: AND LEVEL_SOURCE IS NOT NULL;
3853: