DBA Data[Home] [Help]

APPS.BSC_COLOR_CALC_UTIL dependencies on BSC_KPI_PROPERTIES

Line 485: FROM bsc_kpi_properties

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:

Line 488: l_default_node_dataset_id bsc_kpi_properties.property_value%TYPE;

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