DBA Data[Home] [Help]

APPS.BSC_KPI_PUB dependencies on BSC_TAB_IND_GROUPS_B

Line 109: FROM BSC_TAB_IND_GROUPS_B

105:
106: if l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Group_Id is not null then
107:
108: SELECT COUNT(1) INTO l_Count
109: FROM BSC_TAB_IND_GROUPS_B
110: WHERE IND_GROUP_ID = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Group_Id;
111:
112: if l_count = 0 then
113: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KGROUP_ID');

Line 127: FROM BSC_TAB_IND_GROUPS_B A

123:
124: IF (l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Share_Flag <> 2) THEN
125: SELECT COUNT(B.Indicator)
126: INTO l_No_Ind
127: FROM BSC_TAB_IND_GROUPS_B A
128: , BSC_KPIS_B B
129: WHERE A.Ind_Group_Id = B.Ind_Group_Id
130: AND A.Group_Type = 1
131: AND A.Ind_Group_Id = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Group_Id