APPS.BSC_BIS_KPI_MEAS_PUB dependencies on BSC_KPI_MEASURE_PROPS

Line 4106: l_def_calc_id bsc_kpi_measure_props.default_calculation%TYPE;

4102: -- Need the following to keep track of whether data set has changed (3169904)
4103: l_old_data_set_id BSC_SYS_DATASETS_B.Dataset_Id%TYPE;
4104: l_indic_type NUMBER;
4105: l_config_type NUMBER;
4106: l_def_calc_id bsc_kpi_measure_props.default_calculation%TYPE;
4107: CURSOR c_old_data_set_id IS
4108: SELECT dataset_id
4109: FROM BSC_KPI_ANALYSIS_MEASURES_B
4110: WHERE indicator = p_kpi_id

Line 4159: bsc_kpi_measure_props kp,

4155: CURSOR c_default_calculation IS
4156: SELECT
4157: default_calculation
4158: FROM
4159: bsc_kpi_measure_props kp,
4160: bsc_kpi_analysis_measures_b km
4161: WHERE
4162: km.indicator = p_kpi_id AND
4163: km.indicator = kp.indicator AND