DBA Data[Home] [Help]

APPS.BSC_KPI_MEASURE_PROPS_PUB dependencies on BSC_KPI_ANALYSIS_MEASURES_B

Line 13: FROM bsc_kpi_analysis_measures_b

9: ) RETURN NUMBER
10: IS
11: CURSOR c_analysis_option_comb(p_indicator NUMBER, p_kpi_measure_id NUMBER) IS
12: SELECT analysis_option0, analysis_option1, analysis_option2, series_id
13: FROM bsc_kpi_analysis_measures_b
14: WHERE indicator = p_indicator
15: AND kpi_measure_id = p_kpi_measure_id;
16: c_analysis_option_comb_rec c_analysis_option_comb%ROWTYPE;
17:

Line 21: FROM bsc_kpi_analysis_measures_b

17:
18: CURSOR c_kpi_measure_id(p_indicator NUMBER, p_analysis_option0 NUMBER,
19: p_analysis_option1 NUMBER, p_analysis_option2 NUMBER, p_series_id NUMBER) IS
20: SELECT kpi_measure_id
21: FROM bsc_kpi_analysis_measures_b
22: WHERE indicator = p_indicator
23: AND analysis_option0 = p_analysis_option0
24: AND analysis_option1 = p_analysis_option1
25: AND analysis_option2 = p_analysis_option2