APPS.BSC_BIS_KPI_CRUD_PUB dependencies on BSC_OAF_ANALYSYS_OPT_COMB_V

Line 7265: FROM bsc_oaf_analysys_opt_comb_v a

7261: l_series_id BSC_KPI_ANALYSIS_MEASURES_B.SERIES_ID%TYPE;
7262:
7263: CURSOR c_get_ana_options IS
7264: SELECT a.indicator,a.analysis_option0,a.analysis_option1,a.analysis_option2,a.series_id
7265: FROM bsc_oaf_analysys_opt_comb_v a
7266: WHERE a.indicator = p_indicator;
7267:
7268: CURSOR c_get_measure_short_name(p_ana_option0 BSC_KPI_ANALYSIS_MEASURES_B.ANALYSIS_OPTION0%TYPE
7269: ,p_ana_option1 BSC_KPI_ANALYSIS_MEASURES_B.ANALYSIS_OPTION1%TYPE

Line 7610: l_cust_kpi_name bsc_oaf_analysys_opt_comb_v.full_name%TYPE;

7606: ) IS
7607:
7608: l_objective_name BSC_KPIS_VL.NAME%TYPE;
7609: l_indicator BSC_KPIS_VL.INDICATOR%TYPE;
7610: l_cust_kpi_name bsc_oaf_analysys_opt_comb_v.full_name%TYPE;
7611: l_cust_kpis varchar2(1000) := '';
7612:
7613: CURSOR c_get_objective IS
7614: SELECT a.name,a.indicator FROM BSC_KPIS_VL a,BSC_TAB_INDICATORS b

Line 7618: CURSOR c_get_custom_Kpis(p_indicator bsc_oaf_analysys_opt_comb_v.indicator%TYPE) IS

7614: SELECT a.name,a.indicator FROM BSC_KPIS_VL a,BSC_TAB_INDICATORS b
7615: WHERE a.indicator = b.indicator
7616: AND b.tab_id = p_tabId;
7617:
7618: CURSOR c_get_custom_Kpis(p_indicator bsc_oaf_analysys_opt_comb_v.indicator%TYPE) IS
7619: SELECT a.full_name FROM bsc_oaf_analysys_opt_comb_v a
7620: WHERE a.indicator = p_indicator;
7621:
7622: BEGIN

Line 7619: SELECT a.full_name FROM bsc_oaf_analysys_opt_comb_v a

7615: WHERE a.indicator = b.indicator
7616: AND b.tab_id = p_tabId;
7617:
7618: CURSOR c_get_custom_Kpis(p_indicator bsc_oaf_analysys_opt_comb_v.indicator%TYPE) IS
7619: SELECT a.full_name FROM bsc_oaf_analysys_opt_comb_v a
7620: WHERE a.indicator = p_indicator;
7621:
7622: BEGIN
7623: FND_MSG_PUB.Initialize;