APPS.BSC_COMMON_DIM_LEVELS_PUB dependencies on BSC_KPIS_B

Line 354: BSC_KPIS_B KB,

350: --Cursor to get The common Dimensions for the tab.
351: CURSOR c_Common_Levels IS
352: SELECT DISTINCT KL.LEVEL_TABLE_NAME, KL.DIM_LEVEL_INDEX, NVL(KL.PARENT_LEVEL_INDEX, -1), SL.DIM_LEVEL_ID
353: FROM BSC_TAB_INDICATORS TI,
354: BSC_KPIS_B KB,
355: BSC_KPI_DIM_LEVELS_VL KL,
356: BSC_SYS_DIM_LEVELS_VL SL
357: WHERE TI.TAB_ID = p_Tab_Id
358: AND KB.INDICATOR = TI.INDICATOR

Line 384: , BSC_KPIS_B KB

380: , SLG.DEFAULT_VALUE
381: , KL.PARENT_LEVEL_INDEX
382: , KL.DEFAULT_KEY_VALUE
383: FROM BSC_TAB_INDICATORS TI
384: , BSC_KPIS_B KB
385: , BSC_KPI_DIM_LEVELS_VL KL
386: , BSC_KPI_DIM_GROUPS KG
387: , BSC_SYS_DIM_LEVELS_BY_GROUP SLG
388: , BSC_SYS_DIM_LEVELS_VL SL

Line 453: BSC_KPIS_B KB,

449: SELECT DISTINCT INDICATOR, DIM_SET_ID, SOURCE
450: FROM
451: ( SELECT KB.INDICATOR, KDS.DIM_SET_ID, SL.DIM_LEVEL_ID, SL.SOURCE
452: FROM BSC_TAB_INDICATORS TI,
453: BSC_KPIS_B KB,
454: BSC_KPI_DIM_SETS_VL KDS,
455: BSC_KPI_DIM_GROUPS KDG,
456: BSC_SYS_DIM_LEVELS_BY_GROUP SLG,
457: BSC_SYS_DIM_LEVELS_B SL

Line 808: p_Kpi_Id IN BSC_KPIS_B.indicator%TYPE := NULL

804:
805: /******************************************************************/
806: PROCEDURE Validate_List_Button
807: (
808: p_Kpi_Id IN BSC_KPIS_B.indicator%TYPE := NULL
809: , p_Dim_Level_Id IN NUMBER := NULL
810: , x_return_status OUT NOCOPY VARCHAR2
811: , x_msg_count OUT NOCOPY NUMBER
812: , x_msg_data OUT NOCOPY VARCHAR2

Line 814: l_Kpi_Id BSC_KPIS_B.indicator%TYPE;

810: , x_return_status OUT NOCOPY VARCHAR2
811: , x_msg_count OUT NOCOPY NUMBER
812: , x_msg_data OUT NOCOPY VARCHAR2
813: )IS
814: l_Kpi_Id BSC_KPIS_B.indicator%TYPE;
815: l_count NUMBER;
816: l_tab_id BSC_TABS_B.Tab_Id%TYPE;
817:
818: CURSOR c_kpi_ids IS

Line 820: FROM BSC_KPIS_B

816: l_tab_id BSC_TABS_B.Tab_Id%TYPE;
817:
818: CURSOR c_kpi_ids IS
819: SELECT indicator
820: FROM BSC_KPIS_B
821: WHERE Source_Indicator = l_Kpi_Id
822: AND Prototype_Flag <> 2;
823:
824: CURSOR c_tab_id IS