APPS.BSC_KPI_PUB dependencies on BSC_TAB_VIEW_KPI_TL

Line 4754: DELETE FROM BSC_TAB_VIEW_KPI_TL

4750: WHERE INDICATOR = l_master_kpi;
4751: UPDATE BSC_KPI_DEFAULTS_TL SET TAB_ID = l_share_tab
4752: WHERE INDICATOR= l_master_kpi;
4753:
4754: DELETE FROM BSC_TAB_VIEW_KPI_TL
4755: WHERE TAB_ID = l_master_tab AND INDICATOR = l_master_kpi;
4756:
4757: DELETE FROM BSC_KPI_CAUSE_EFFECT_RELS
4758: WHERE (((CAUSE_INDICATOR= l_master_kpi)) OR ((EFFECT_INDICATOR = l_master_kpi))

Line 4761: UPDATE BSC_TAB_VIEW_KPI_TL

4757: DELETE FROM BSC_KPI_CAUSE_EFFECT_RELS
4758: WHERE (((CAUSE_INDICATOR= l_master_kpi)) OR ((EFFECT_INDICATOR = l_master_kpi))
4759: AND (NVL(CAUSE_LEVEL,'KPI')= 'KPI') AND (NVL(EFFECT_LEVEL,'NVL')= 'KPI'));
4760:
4761: UPDATE BSC_TAB_VIEW_KPI_TL
4762: SET INDICATOR = l_master_kpi, LAST_UPDATE_DATE = sysdate
4763: WHERE TAB_ID= l_share_tab AND INDICATOR= l_share_kpi;
4764:
4765: UPDATE BSC_KPI_CAUSE_EFFECT_RELS