APPS.BSC_SIMULATION_VIEW_PUB dependencies on BIS_INDICATORS

Line 69: l_kpi_short_name bis_indicators.short_name%TYPE;

65: ) RETURN VARCHAR2 IS
66:
67: l_measure_col bsc_sys_measures.measure_col%TYPE;
68: l_short_name bsc_kpis_b.short_name%TYPE;
69: l_kpi_short_name bis_indicators.short_name%TYPE;
70: l_formula VARCHAR2(32000);
71: l_count NUMBER;
72:
73: l_Ak_Null_Tbl BSC_SIMULATION_VIEW_PUB.Bsc_Ak_Region_Items_Tbl_Type ;

Line 212: FROM bis_indicators

208: END LOOP; */
209:
210: SELECT short_name
211: INTO l_short_name
212: FROM bis_indicators
213: WHERE dataset_id = p_Dataset_Id;
214:
215: --l_short_name := 'SHORT_NAME4';
216:

Line 1035: l_measure_type BIS_INDICATORS.measure_type%TYPE;

1031: l_id NUMBER;
1032: l_labels VARCHAR2(8000);
1033: l_links_table BSC_UTILITY.varchar_tabletype;
1034: l_index NUMBER;
1035: l_measure_type BIS_INDICATORS.measure_type%TYPE;
1036: l_range_id NUMBER;
1037: l_dataset_id BIS_INDICATORS.dataset_id%TYPE;
1038: l_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;
1039: l_default_node bsc_kpi_properties.property_value%TYPE;

Line 1037: l_dataset_id BIS_INDICATORS.dataset_id%TYPE;

1033: l_links_table BSC_UTILITY.varchar_tabletype;
1034: l_index NUMBER;
1035: l_measure_type BIS_INDICATORS.measure_type%TYPE;
1036: l_range_id NUMBER;
1037: l_dataset_id BIS_INDICATORS.dataset_id%TYPE;
1038: l_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;
1039: l_default_node bsc_kpi_properties.property_value%TYPE;
1040: l_count NUMBER;
1041:

Line 1051: FROM bis_indicators

1047: AND tab_view_id = p_obj_Id;
1048:
1049: CURSOR measure_cur IS
1050: SELECT measure_type
1051: FROM bis_indicators
1052: WHERE dataset_id = l_dataset_id;
1053:
1054:
1055: CURSOR c_default IS