APPS.BSC_UTILITY dependencies on BSC_SYS_DIM_LEVELS_B

Line 1699: FROM bsc_sys_dim_levels_b sys,

1695: l_Is_EndToEnd_Kpi VARCHAR2(2);
1696:
1697: CURSOR c_source IS
1698: SELECT DISTINCT(sys.source) source
1699: FROM bsc_sys_dim_levels_b sys,
1700: bsc_kpi_dim_level_properties kpi
1701: WHERE sys.dim_level_id = kpi.dim_level_id
1702: AND kpi.INDICATOR = p_Kpi_Id
1703: AND kpi.dim_set_id = p_Dim_Set_Id;

Line 1789: FROM BSC_SYS_DIM_LEVELS_B;

1785:
1786: ELSIF (l_type = bsc_utility.c_BSC_DIM_OBJ) THEN
1787: SELECT NVL(MAX(dim_level_id) + 1, 0)
1788: INTO l_next
1789: FROM BSC_SYS_DIM_LEVELS_B;
1790: l_ret_val := bsc_bis_dim_obj_pub.c_BSC_DIM_OBJ || l_next;
1791: END IF;
1792:
1793: RETURN l_ret_val;

Line 1933: l_table_name BSC_SYS_DIM_LEVELS_B.LEVEL_TABLE_NAME%TYPE;

1929: RETURN VARCHAR2 IS
1930: l_found BOOLEAN;
1931: l_alias VARCHAR2(30);
1932: l_count NUMBER;
1933: l_table_name BSC_SYS_DIM_LEVELS_B.LEVEL_TABLE_NAME%TYPE;
1934: BEGIN
1935: l_found := TRUE;
1936: l_alias := NULL;
1937: l_table_name := 'BSC_D_' || SUBSTR(UPPER(REPLACE(p_short_name, ' ', '_')) , 1, 22) || '_V';

Line 1941: FROM BSC_SYS_DIM_LEVELS_B

1937: l_table_name := 'BSC_D_' || SUBSTR(UPPER(REPLACE(p_short_name, ' ', '_')) , 1, 22) || '_V';
1938: WHILE (l_found) LOOP
1939: SELECT COUNT(1)
1940: INTO l_count
1941: FROM BSC_SYS_DIM_LEVELS_B
1942: WHERE Level_Table_Name = l_table_name
1943: AND short_name <> p_short_name ;
1944: IF (l_count = 0) THEN
1945: l_found := FALSE;