APPS.BSC_UPDATE_DIM dependencies on BSC_KPIS_B

Line 1561: from bsc_kpi_properties p, bsc_kpis_b k

1557: into h_count
1558: from bsc_kpi_dim_levels_b
1559: where indicator in (
1560: select p.indicator
1561: from bsc_kpi_properties p, bsc_kpis_b k
1562: where p.indicator = k.indicator and
1563: p.property_code = h_aw_impl_type_name and
1564: p.property_value = h_aw_impl_type and
1565: k.prototype_flag in (0,6,7)

Line 1597: from bsc_kpi_properties p, bsc_kpis_b k

1593: into h_count
1594: from bsc_kpi_dim_levels_b
1595: where indicator in (
1596: select k.indicator
1597: from bsc_kpi_properties p, bsc_kpis_b k
1598: where p.indicator (+) = k.indicator and
1599: p.property_code (+) = h_mv_impl_type_name and
1600: (p.property_value is null or p.property_value = h_mv_impl_type) and
1601: k.prototype_flag in (0,6,7)

Line 3745: UPDATE BSC_KPIS_B K

3741:
3742: -- Mark indicators using this dimension to be recalculated.
3743: -- Only if the table was modified.
3744: IF h_table_was_modified THEN
3745: UPDATE BSC_KPIS_B K
3746: SET PROTOTYPE_FLAG = 6,
3747: LAST_UPDATED_BY = BSC_APPS.fnd_global_user_id,
3748: LAST_UPDATE_DATE = SYSDATE
3749: WHERE INDICATOR IN (SELECT D.INDICATOR

Line 4757: UPDATE BSC_KPIS_B K

4753: IF h_num_mod_dimensions > 0 THEN
4754: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_RECALC_KPI_DIMTABLES'), BSC_UPDATE_LOG.OUTPUT);
4755: FOR h_i IN 1..h_num_mod_dimensions LOOP
4756:
4757: UPDATE BSC_KPIS_B K
4758: SET PROTOTYPE_FLAG = 6,
4759: LAST_UPDATED_BY = BSC_APPS.fnd_global_user_id,
4760: LAST_UPDATE_DATE = SYSDATE
4761: WHERE INDICATOR IN (SELECT D.INDICATOR

Line 5113: ' FROM bsc_kpi_dim_levels_b d, bsc_kpis_b k'||

5109:
5110: /*
5111: c_indicators t_cursor;
5112: c_indicators_sql VARCHAR2(2000) := 'SELECT d.indicator, d.level_table_name, d.default_key_value'||
5113: ' FROM bsc_kpi_dim_levels_b d, bsc_kpis_b k'||
5114: ' WHERE d.indicator = k.indicator AND'||
5115: ' d.default_key_value IS NOT NULL';
5116: */
5117: CURSOR c_indicators IS

Line 5119: FROM bsc_kpi_dim_levels_b d, bsc_kpis_b k

5115: ' d.default_key_value IS NOT NULL';
5116: */
5117: CURSOR c_indicators IS
5118: SELECT d.indicator, d.level_table_name, d.default_key_value
5119: FROM bsc_kpi_dim_levels_b d, bsc_kpis_b k
5120: WHERE d.indicator = k.indicator AND
5121: d.default_key_value IS NOT NULL;
5122:
5123: h_indicator NUMBER;