APPS.BSC_UPGRADES_GENERIC dependencies on BSC_TAB_VIEW_LABELS_B

Line 279: select count(*) into l_count from bsc_tab_view_labels_b

275:
276: IF (l_property_value IS NULL) THEN -- run for the first time
277: FOR all_tab_view_kpis IN c_all_tab_view_kpis LOOP
278: -- check if it exists already
279: select count(*) into l_count from bsc_tab_view_labels_b
280: where tab_id = all_tab_view_kpis.tab_id and tab_view_id=all_tab_view_kpis.tab_view_id
281: and label_type = BSC_CUSTOM_VIEW_UI_WRAPPER.c_type_kpi and link_id = all_tab_view_kpis.indicator;
282:
283: IF (l_count = 0) THEN

Line 290: from bsc_tab_view_labels_b

286: --dbms_output.put_line(substr('Value of all_tab_view_kpis.indicator='||all_tab_view_kpis.indicator,1,255));
287:
288: -- find the next unique label_id
289: select DECODE(max(LABEL_ID),NULL,0,max(LABEL_ID)+1) into l_label_id
290: from bsc_tab_view_labels_b
291: where tab_id = all_tab_view_kpis.tab_id and tab_view_id=all_tab_view_kpis.tab_view_id;
292:
293: -- Add specified entry for objectives to BSC_TAB_VIEW_LABELS_PKG
294: -- position and color info is stored in BSC_TAB_VIEW_KPI_TL entries