APPS.BSC_DEFAULT_KEY_ITEM_PUB dependencies on BSC_TAB_INDICATORS

Line 44: FROM bsc_tab_indicators a,

40: WHERE source_type =1
41: AND source_code =a.tab_id
42: AND dim_level_id =l_dim_level_id
43: AND dim_level_value =l_def_key_id)) total
44: FROM bsc_tab_indicators a,
45: bsc_tabs_vl b
46: WHERE a.tab_id =b.tab_id
47: AND a.indicator IN
48: (SELECT INDICATOR

Line 583: FROM bsc_tab_indicators

579: last_update_date = SYSDATE,
580: last_update_login = l_login_id
581: WHERE tab_id IN (
582: SELECT tab_id
583: FROM bsc_tab_indicators
584: WHERE indicator = p_kpi_id);
585:
586: UPDATE bsc_kpis_b
587: SET last_updated_by = l_user_id,