APPS.BSC_KPI_PUB dependencies on BSC_KPI_CAUSE_EFFECT_RELS

Line 4757: DELETE FROM BSC_KPI_CAUSE_EFFECT_RELS

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))
4759: AND (NVL(CAUSE_LEVEL,'KPI')= 'KPI') AND (NVL(EFFECT_LEVEL,'NVL')= 'KPI'));
4760:
4761: UPDATE BSC_TAB_VIEW_KPI_TL

Line 4765: UPDATE BSC_KPI_CAUSE_EFFECT_RELS

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
4766: SET EFFECT_INDICATOR = l_master_kpi
4767: WHERE EFFECT_INDICATOR = l_share_kpi
4768: AND (NVL(CAUSE_LEVEL,'KPI')= 'KPI') AND (NVL(EFFECT_LEVEL,'NVL')= 'KPI');
4769: UPDATE BSC_KPI_CAUSE_EFFECT_RELS SET CAUSE_INDICATOR = l_master_kpi

Line 4769: UPDATE BSC_KPI_CAUSE_EFFECT_RELS SET CAUSE_INDICATOR = l_master_kpi

4765: UPDATE BSC_KPI_CAUSE_EFFECT_RELS
4766: SET EFFECT_INDICATOR = l_master_kpi
4767: WHERE EFFECT_INDICATOR = l_share_kpi
4768: AND (NVL(CAUSE_LEVEL,'KPI')= 'KPI') AND (NVL(EFFECT_LEVEL,'NVL')= 'KPI');
4769: UPDATE BSC_KPI_CAUSE_EFFECT_RELS SET CAUSE_INDICATOR = l_master_kpi
4770: WHERE CAUSE_INDICATOR = l_share_kpi
4771: AND (NVL(CAUSE_LEVEL,'KPI')= 'KPI') AND (NVL(EFFECT_LEVEL,'NVL')= 'KPI');
4772:
4773: /*********************************************