DBA Data[Home] [Help]

APPS.BSC_UPDATE dependencies on BSC_KPIS_B

Line 295: FROM bsc_kpis_b

291: SELECT level_pk_col
292: FROM bsc_kpi_dim_levels_b
293: WHERE indicator IN (
294: SELECT indicator
295: FROM bsc_kpis_b
296: WHERE indicator_type = p_indic_type AND config_type = p_config_type
297: ) AND
298: dim_level_index = p_dim_level_index
299: );

Line 3604: UPDATE bsc_kpis_b

3600: IF NOT BSC_UPDATE_LOCK.Lock_Prototype_Indicator(h_color_indicators(h_i)) THEN
3601: RAISE e_could_not_get_lock;
3602: END IF;
3603:
3604: UPDATE bsc_kpis_b
3605: SET prototype_flag = 0, last_updated_by = BSC_APPS.fnd_global_user_id, last_update_date = SYSDATE
3606: WHERE indicator = h_color_indicators(h_i) AND prototype_flag IN (6, 7);
3607:
3608: -- Color By KPI: Mark KPIs for color done