APPS.BSC_UPDATE_UTIL dependencies on BSC_TAB_INDICATORS

Line 5290: ' FROM bsc_tab_indicators'||

5286: ' SET last_updated_by = :1,'||
5287: ' last_update_date = SYSDATE'||
5288: ' WHERE tab_id IN ('||
5289: ' SELECT tab_id'||
5290: ' FROM bsc_tab_indicators'||
5291: ' WHERE indicator = :2)';
5292:
5293: h_bind_vars_values.delete;
5294: h_bind_vars_values(1) := h_user_id;

Line 5304: FROM bsc_tab_indicators

5300: SET last_updated_by = h_user_id,
5301: last_update_date = SYSDATE
5302: WHERE tab_id IN (
5303: SELECT tab_id
5304: FROM bsc_tab_indicators
5305: WHERE indicator = x_indicator);
5306:
5307: --LOCKING: remove this commit
5308: --COMMIT;

Line 5343: ' FROM bsc_tab_indicators'||

5339: h_sql := 'UPDATE bsc_tabs_b'||
5340: ' SET last_updated_by = :1, last_update_date = SYSDATE'||
5341: ' WHERE tab_id IN ('||
5342: ' SELECT tab_id'||
5343: ' FROM bsc_tab_indicators'||
5344: ' WHERE '||x_condition||')';
5345:
5346: h_bind_vars_values.delete;
5347: h_bind_vars_values(1) := h_user_id;

Line 6265: FROM bsc_tab_indicators tab_ind,

6261: ds.operation ||
6262: DECODE(ds.measure_id2,
6263: NULL, NULL,
6264: m2.operation || '(' || NVL(BSC_APPS.Get_Property_Value(m2.s_color_formula, 'pFormulaSource'), m2.measure_col) || ')' ) measure_formula
6265: FROM bsc_tab_indicators tab_ind,
6266: bsc_kpi_analysis_measures_b anal_meas,
6267: bsc_sys_datasets_b ds,
6268: bsc_sys_measures m1,
6269: bsc_sys_measures m2,