APPS.BSC_BIS_CUSTOM_KPI_UTIL_PUB dependencies on BSC_TAB_IND_GROUPS_VL

Line 133: l_tab_ind_group_name BSC_TAB_IND_GROUPS_VL.NAME%TYPE;

129: l_tab_id BSC_TABS_B.TAB_ID%TYPE;
130: l_kpi_group_id BSC_TAB_IND_GROUPS_B.IND_GROUP_ID%TYPE;
131: l_kpi_id BSC_KPIS_B.INDICATOR%TYPE;
132: l_tab_name BSC_TABS_VL.NAME%TYPE;
133: l_tab_ind_group_name BSC_TAB_IND_GROUPS_VL.NAME%TYPE;
134: not_S_To_E_Kpi EXCEPTION;
135:
136: BEGIN
137: SAVEPOINT UpdateEndToEndKPIName;

Line 663: FROM BSC_TAB_IND_GROUPS_VL

659: l_max_tab_grp_length := Get_Max_Tab_Grp_Name_Length;
660:
661: WHILE ((l_flag) AND (l_loop_count < BSC_BIS_CUSTOM_KPI_UTIL_PUB.C_MAX_LOOP_COUNT)) LOOP
662: SELECT count(1) INTO l_count
663: FROM BSC_TAB_IND_GROUPS_VL
664: WHERE UPPER(trim(name)) = UPPER(l_tab_grp_name);
665:
666: IF (l_count = 0) THEN
667: l_flag := FALSE;

Line 710: FROM BSC_TAB_IND_GROUPS_VL

706: l_max_tab_grp_length := Get_Max_Tab_Grp_Name_Length;
707:
708: WHILE ((l_flag) AND (l_loop_count < BSC_BIS_CUSTOM_KPI_UTIL_PUB.C_MAX_LOOP_COUNT)) LOOP
709: SELECT count(1) INTO l_count
710: FROM BSC_TAB_IND_GROUPS_VL
711: WHERE UPPER(trim(name)) = UPPER(l_tab_grp_name)
712: AND IND_GROUP_ID <> p_tab_grp_id;
713:
714: IF (l_count = 0) THEN