APPS.BSC_BIS_MEASURE_PUB dependencies on BSC_KPIS_VL

Line 3881: from bsc_kpis_vl k

3877: l_isFirst boolean := true;
3878:
3879: cursor indicators_cursor is
3880: select k.name || ' [' || k.indicator || '] ' name
3881: from bsc_kpis_vl k
3882: where indicator in
3883: (
3884: select distinct indicator
3885: from bsc_kpi_analysis_measures_b d

Line 3925: FROM bsc_kpis_vl k

3921: l_isFirst BOOLEAN := TRUE;
3922:
3923: CURSOR indicators_cursor IS
3924: SELECT k.name || ' [' || k.indicator || '] ' name
3925: FROM bsc_kpis_vl k
3926: WHERE indicator IN
3927: (
3928: SELECT DISTINCT d.indicator
3929: FROM bsc_kpi_analysis_measures_b d,

Line 3994: BSC_KPIS_VL B,

3990:
3991: cursor c_Indicators_Cursor is
3992: SELECT DISTINCT B.NAME||'['||B.INDICATOR||']' NAME
3993: FROM BSC_KPI_ANALYSIS_MEASURES_B A,
3994: BSC_KPIS_VL B,
3995: BSC_DB_COLOR_KPI_DEFAULTS_V D
3996: WHERE INSTR(L_DATASET_LIST, ','||A.DATASET_ID||',') > 0
3997: AND D.DATASET_ID = A.DATASET_ID
3998: AND A.INDICATOR =B.INDICATOR

Line 4164: from bsc_kpis_vl

4160:
4161:
4162: select name || '[' || indicator || ']'
4163: into l_kpi_name
4164: from bsc_kpis_vl
4165: where indicator = p_kpi_id;
4166:
4167: if ((instr(l_indicators, l_kpi_name) = 0) or (l_indicators is null)) then
4168: if(l_isFirst = true) then

Line 4542: BSC_KPIS_VL OB,

4538: CURSOR c_Get_Obj_Names IS
4539: SELECT
4540: OB.NAME
4541: FROM
4542: BSC_KPIS_VL OB,
4543: BSC_KPI_ANALYSIS_MEASURES_B AM,
4544: BSC_SYS_DATASETS_B ME
4545: WHERE
4546: ME.DATASET_ID = p_Dataset_Id AND