APPS.BSC_COLOR_UPGRADE dependencies on BSC_KPI_PROPERTIES

Line 145: FROM bsc_kpi_properties

141:
142: IF (p_kpi_measure_id = p_default_kpi_measure_id) THEN
143: SELECT property_value
144: INTO l_color_by_total
145: FROM bsc_kpi_properties
146: WHERE indicator = p_objective_id
147: AND property_code = 'COLOR_BY_TOTAL';
148: END IF;
149:

Line 1121: FROM bsc_kpi_properties

1117: );
1118:
1119: CURSOR c_obj_threshold IS
1120: SELECT property_code, property_value
1121: FROM bsc_kpi_properties
1122: WHERE property_code in ('COL_M1_LEVEL1', 'COL_M1_LEVEL2', 'COL_M2_LEVEL1', 'COL_M2_LEVEL2',
1123: 'COL_M3_LEVEL1', 'COL_M3_LEVEL2', 'COL_M3_LEVEL3', 'COL_M3_LEVEL4')
1124: AND indicator = l_indicator;
1125:

Line 1189: /*DELETE bsc_kpi_properties

1185: END;
1186: END LOOP;
1187:
1188: -- Delete the data moved.
1189: /*DELETE bsc_kpi_properties
1190: WHERE property_code in ('COL_M1_LEVEL1', 'COL_M1_LEVEL2', 'COL_M2_LEVEL1', 'COL_M2_LEVEL2',
1191: 'COL_M3_LEVEL1', 'COL_M3_LEVEL2', 'COL_M3_LEVEL3', 'COL_M3_LEVEL4');*/
1192:
1193: RETURN TRUE;