DBA Data[Home] [Help]

APPS.BSC_KPI_GROUP_PVT dependencies on BSC_KPIS_B

Line 606: from bsc_kpis_b a, bsc_tab_indicators b

602: if ((p_Bsc_Kpi_Group_Rec.Bsc_Tab_Id is not null) and (p_Bsc_Kpi_Group_Rec.Bsc_Tab_Id <> -1)) then
603:
604: select count(b.indicator)
605: into l_count_kpi
606: from bsc_kpis_b a, bsc_tab_indicators b
607: where a.ind_group_id = p_Bsc_Kpi_Group_Rec.Bsc_Kpi_Group_Id
608: and a.indicator = b.indicator
609: and b.tab_id = p_Bsc_Kpi_Group_Rec.Bsc_Tab_Id;
610:

Line 633: from BSC_KPIS_B

629:
630: -- Before deleting Kpi Group check that there are no KPIs assigned to it.
631: select count(indicator)
632: into l_count
633: from BSC_KPIS_B
634: where ind_group_id = p_Bsc_Kpi_Group_Rec.Bsc_Kpi_Group_Id
635: and PROTOTYPE_FLAG <> BSC_KPI_PUB.DELETE_KPI_FLAG; -- Added to fix bug 3267470
636:
637: if l_count = 0 then