APPS.BSC_BIS_CUSTOM_KPI_UTIL_PUB dependencies on BSC_TABS_VL

Line 132: l_tab_name BSC_TABS_VL.NAME%TYPE;

128:
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

Line 569: FROM BSC_TABS_VL

565: l_max_tab_length := Get_Max_Tab_Name_Length;
566:
567: WHILE ((l_flag) AND (l_loop_count < BSC_BIS_CUSTOM_KPI_UTIL_PUB.C_MAX_LOOP_COUNT)) LOOP
568: SELECT count(1) INTO l_count
569: FROM BSC_TABS_VL
570: WHERE UPPER(trim(name)) = UPPER(l_tab_name);
571:
572: IF (l_count = 0) THEN
573: l_flag := FALSE;

Line 616: FROM BSC_TABS_VL

612: l_max_tab_length := Get_Max_Tab_Name_Length;
613:
614: WHILE ((l_flag) AND (l_loop_count < BSC_BIS_CUSTOM_KPI_UTIL_PUB.C_MAX_LOOP_COUNT)) LOOP
615: SELECT count(1) INTO l_count
616: FROM BSC_TABS_VL
617: WHERE UPPER(trim(name)) = UPPER(l_tab_name)
618: AND tab_id <> p_tab_id;
619:
620: IF (l_count = 0) THEN