APPS.BSC_COLOR_UPGRADE dependencies on BSC_KPI_COMMENTS

Line 1274: FROM bsc_kpi_comments

1270: CURSOR c_old_kpi_comments IS
1271: SELECT comment_id
1272: ,indicator
1273: ,trend_flag
1274: FROM bsc_kpi_comments
1275: WHERE nvl(trend_flag,0)<10
1276: AND trend_flag <>0
1277: AND indicator IS NOT NULL;
1278:

Line 1317: UPDATE bsc_kpi_comments

1313: l_new_trend := 13;
1314: END IF;
1315:
1316: IF l_color<>0 AND l_new_trend <>0 THEN
1317: UPDATE bsc_kpi_comments
1318: SET color_flag=l_color, trend_flag=l_new_trend
1319: WHERE comment_id = c_kpi_comm.comment_id
1320: AND indicator = c_kpi_comm.indicator;
1321: END IF;