APPS.BSC_PMF_UI_WRAPPER dependencies on BSC_KPIS_VL

Line 2300: FROM BSC_KPIS_VL K

2296: l_commit varchar2(10);
2297:
2298: CURSOR c_Share_Ind IS
2299: SELECT DISTINCT K.Indicator
2300: FROM BSC_KPIS_VL K
2301: , BSC_TAB_INDICATORS T
2302: WHERE K.Indicator = T.Indicator
2303: AND K.Share_Flag = 2
2304: AND T.Tab_Id = p_tab_id;

Line 2473: from BSC_KPIS_VL

2469: -- get the name, l_share_flag and Indicator source . It will be used for tab validation.
2470:
2471: select name, share_flag, source_indicator
2472: into l_kpi_name, l_share_flag, l_kpi_source
2473: from BSC_KPIS_VL
2474: where indicator = p_kpi_id;
2475:
2476: -- Validate that the p_KPI_id corresponds to the Master KPI.
2477: if l_share_flag <> 2 then

Line 5924: l_objective_name BSC_KPIS_VL.NAME%TYPE;

5920: l_dep_obj_message varchar2(1000);
5921: l_dep_obj_list varchar2(2000);
5922: l_scr_name BSC_TABS_VL.NAME%TYPE;
5923: l_scr_short_name BSC_TABS_VL.SHORT_NAME%TYPE;
5924: l_objective_name BSC_KPIS_VL.NAME%TYPE;
5925: l_Is_Ag_Type_Scorecard VARCHAR2(1);
5926: l_exist_dependency VARCHAR2(10);
5927:
5928: CURSOR c_scr IS

Line 5935: FROM bsc_oaf_analysys_opt_comb_v a,bsc_tab_indicators b,bis_indicators c,bsc_kpis_vl d

5931: WHERE tab_id = p_tab_id;
5932:
5933: CURSOR c_Kpi_function IS
5934: SELECT c.function_name,d.name
5935: FROM bsc_oaf_analysys_opt_comb_v a,bsc_tab_indicators b,bis_indicators c,bsc_kpis_vl d
5936: WHERE a.indicator = b.indicator
5937: AND a.dataset_id = c.dataset_id
5938: AND a.indicator = d.indicator
5939: AND b.tab_id = p_tab_id;