APPS.BSC_BIS_DIMENSION_PUB dependencies on BSC_DB_DATASET_DIM_SETS_V

Line 98: p_kpi_measure_id BSC_DB_DATASET_DIM_SETS_V.kpi_measure_id%TYPE,

94: /*********************************************************************************/
95:
96: TYPE dimobj_objective_kpis_type IS RECORD
97: ( p_indicator BSC_KPIS_B.indicator%TYPE ,
98: p_kpi_measure_id BSC_DB_DATASET_DIM_SETS_V.kpi_measure_id%TYPE,
99: p_short_name BSC_SYS_DIM_LEVELS_B.short_name%TYPE
100: );
101: TYPE dimobj_obj_kpis_tbl_type IS TABLE OF dimobj_objective_kpis_type INDEX BY BINARY_INTEGER;
102:

Line 749: FROM BSC_DB_DATASET_DIM_SETS_V a, bsc_kpi_dim_levels_vl b

745: ) IS
746: l_count NUMBER;
747: CURSOR c_dim_obj_objectives IS
748: SELECT a.indicator indicator, a.kpi_measure_id
749: FROM BSC_DB_DATASET_DIM_SETS_V a, bsc_kpi_dim_levels_vl b
750: WHERE a.indicator = b.indicator
751: AND a.dim_set_id = b.dim_set_id
752: AND b.level_shortname = p_dim_obj_short_name;
753:

Line 1573: FROM bsc_db_dataset_dim_sets_v a,

1569:
1570: CURSOR c_kpi_meas_props IS
1571: SELECT a.indicator,
1572: a.kpi_measure_id
1573: FROM bsc_db_dataset_dim_sets_v a,
1574: bsc_kpi_dim_levels_vl b
1575: WHERE a.indicator =b.indicator
1576: AND a.dim_set_id =b.dim_set_id
1577: AND b.level_shortname =p_dim_obj_short_name;

Line 3832: FROM bsc_db_dataset_dim_sets_v a,

3828: CURSOR c_dim_set_kpi IS
3829: SELECT a.indicator indicator,
3830: a.kpi_measure_id,
3831: c.color_by_total
3832: FROM bsc_db_dataset_dim_sets_v a,
3833: bsc_kpi_dim_levels_vl b,
3834: bsc_kpi_measure_props c
3835: WHERE a.indicator =b.indicator
3836: AND a.dim_set_id =b.dim_set_id