481: RETURN NUMBER IS
482:
483: CURSOR c_default_node_dataset(p_indicator NUMBER) IS
484: SELECT property_value dataset_id
485: FROM bsc_kpi_properties
486: WHERE property_code = BSC_SIMULATION_VIEW_PUB.c_SIM_NODE_ID
487: AND indicator = p_indicator;
488: l_default_node_dataset_id bsc_kpi_properties.property_value%TYPE;
489:
484: SELECT property_value dataset_id
485: FROM bsc_kpi_properties
486: WHERE property_code = BSC_SIMULATION_VIEW_PUB.c_SIM_NODE_ID
487: AND indicator = p_indicator;
488: l_default_node_dataset_id bsc_kpi_properties.property_value%TYPE;
489:
490: CURSOR c_default_kpi(p_indicator NUMBER, p_dataset_id NUMBER) IS
491: SELECT kpi_measure_id
492: FROM bsc_kpi_analysis_measures_b anal_meas