DBA Data[Home] [Help]

APPS.BSC_PMF_UI_WRAPPER dependencies on BSC_TAB_IND_GROUPS_B

Line 2517: FROM BSC_TAB_IND_GROUPS_B

2513: where indicator = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
2514: -- Evaluate the Group Type
2515: SELECT GROUP_TYPE
2516: into l_kpi_group_type
2517: FROM BSC_TAB_IND_GROUPS_B
2518: WHERE IND_GROUP_ID = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Group_Id
2519: and tab_id = -1 ;
2520:
2521: if l_kpi_group_type = 1 then

Line 2530: update BSC_TAB_IND_GROUPS_B

2526: WHERE BK.IND_GROUP_ID = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Group_Id
2527: AND TI.TAB_ID = p_tab_id
2528: AND BK.INDICATOR = TI.INDICATOR;
2529: if l_count > 0 then
2530: update BSC_TAB_IND_GROUPS_B
2531: set GROUP_TYPE = 0
2532: where IND_GROUP_ID = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Group_Id;
2533: end if;
2534: end if;

Line 5051: FROM BSC_TAB_IND_GROUPS_B

5047: BEGIN
5048:
5049: SELECT count(*)
5050: INTO l_count
5051: FROM BSC_TAB_IND_GROUPS_B
5052: WHERE tab_id = p_tab_id
5053: AND ind_group_id = p_group_id;
5054:
5055: IF (l_count = 0) THEN