APPS.BSC_PMF_UI_API_PUB dependencies on BSC_SYS_DIM_LEVELS_VL

Line 873: from BSC_SYS_DIM_LEVELS_VL

869: g_Bsc_Dimset_Rec.Bsc_Dset_Default_Value := g_Bsc_Pmf_Dim_Tbl(i).Dimension_Level_Status;
870: select TOTAL_DISP_NAME, COMP_DISP_NAME
871: into g_Bsc_Dimset_Rec.Bsc_Dim_Tot_Disp_Name,
872: g_Bsc_Dimset_Rec.Bsc_Dim_Comp_Disp_Name
873: from BSC_SYS_DIM_LEVELS_VL
874: where SHORT_NAME = g_Bsc_Pmf_Dim_Tbl(i).Dimension_Level_Short_Name;
875:
876: -- g_Bsc_Dimset_Rec.Bsc_Level_View_Name := g_Bsc_Pmf_Dim_Tbl(i).Dimension_Level_View_Name;
877: -- g_Bsc_Dimset_Rec.Bsc_Level_Pk_Key := g_Bsc_Pmf_Dim_Tbl(i).Dimension_Level_Pk_Key;

Line 1402: from bsc_sys_dim_levels_vl

1398: BEGIN
1399: -- See if the Level Short Name is already imported
1400: select count(LEVEL_TABLE_NAME)
1401: into l_count
1402: from bsc_sys_dim_levels_vl
1403: where SHORT_NAME = 'p_Short_Name';
1404:
1405: if l_count <> 0 then
1406: -- if the level is already imported return the same name

Line 1409: from bsc_sys_dim_levels_vl

1405: if l_count <> 0 then
1406: -- if the level is already imported return the same name
1407: select LEVEL_TABLE_NAME
1408: into l_view_name
1409: from bsc_sys_dim_levels_vl
1410: where SHORT_NAME = p_Short_Name;
1411: else
1412: l_index := 0;
1413: