APPS.BSC_PMF_UI_API_PUB dependencies on BISFV_DIMENSION_LEVELS

Line 378: from bisfv_dimension_levels

374:
375: select distinct source
376: -- into g_source
377: into g_Bsc_Pmf_Dim_Tbl(i).Dimension_Level_Source
378: from bisfv_dimension_levels
379: where upper(dimension_level_short_name) = upper(p_Bsc_Pmf_Dim_Tbl(i).Dimension_Level_Short_Name);
380:
381: if g_Bsc_Pmf_Dim_Tbl(i).Dimension_Level_Source = 'OLTP' then
382: select distinct dimension_level_name, level_values_view_name, 'ID', 'value'

Line 410: from bisfv_dimension_levels

406: ,level_values_view_name
407: into g_Bsc_Pmf_Dim_Tbl(i).Dimension_Level_Long_Name
408: ,g_Bsc_Pmf_Dim_Tbl(i).Dimension_Level_View_Name
409: ,l_alternate_level_view
410: from bisfv_dimension_levels
411: where dimension_level_short_name = p_Bsc_Pmf_Dim_Tbl(i).Dimension_Level_Short_Name;
412:
413: if l_alternate_level_view is not null then
414: g_Bsc_Pmf_Dim_Tbl(i).Dimension_Level_View_Name := l_alternate_level_view;

Line 1249: from bisfv_dimension_levels

1245: --DBMS_OUTPUT.PUT_LINE(' Populate_Bsc_Pmf_Dim_Rec x_Bsc_Pmf_Dim_Rec.Dimension_Level_Short_Name = ' || x_Bsc_Pmf_Dim_Rec.Dimension_Level_Short_Name );
1246:
1247: select distinct source
1248: into x_Bsc_Pmf_Dim_Rec.Dimension_Level_Source
1249: from bisfv_dimension_levels
1250: where upper(dimension_level_short_name) = upper(p_Dim_Level_Short_Name);
1251:
1252: --DBMS_OUTPUT.PUT_LINE('Populate_Bsc_Pmf_Dim_Rec x_Bsc_Pmf_Dim_Rec.Dimension_Level_Source = ' || x_Bsc_Pmf_Dim_Rec.Dimension_Level_Source );
1253: