APPS.BIS_DIMS_AND_LEVELS_PKG dependencies on BIS_LEVELS_VL

Line 107: , bis_levels_vl bl

103: , SUBSTR(NVL(BIS_DIMS_AND_LEVELS_PKG.get_level_names(bi.indicator_id), '' ''),1,180) LEVEL_NAMES
104: , SUBSTR(NVL(f.application_name, '' ''),1,180) Owning_applicn_name2
105: FROM
106: bis_indicators_vl bi
107: , bis_levels_vl bl
108: , BIS_IND_TL_LVL_V bitlv
109: , bis_application_measures bam
110: , fnd_application_vl f
111: WHERE bitlv.indicator_id = bi.indicator_id

Line 315: , bis_levels_vl bl

311: , SUBSTR(NVL(bl.description, '' ''),1,180) Level_description2
312: , NVL(bl.level_values_view_name, '' '') Level_value_Source_view2
313: FROM
314: Bis_dimensions_vl bd
315: , bis_levels_vl bl
316: '
317: || l_kpi_table_names
318: || l_dyn_table ||
319: '

Line 445: bis_levels_vl bl

441: , SUBSTR(NVL(bl.description, '' ''),1,180) Level_description
442: , bl.source Level_value_Source_type1
443: , SUBSTR(NVL(BIS_DIMS_AND_LEVELS_PKG.get_kpi_names(bl.level_id), '' ''),1,180) Kpi_names
444: FROM
445: bis_levels_vl bl
446: , ak_attributes_vl aa
447: , bis_dimensions_vl bd
448: '
449: || l_dyn_table ||

Line 589: l_lvl_name bis_levels_vl.name%TYPE;

585: FUNCTION get_level_names ( kpi_id IN NUMBER )
586: RETURN VARCHAR2 IS
587:
588: l_lvl_names VARCHAR2(32000) := NULL;
589: l_lvl_name bis_levels_vl.name%TYPE;
590:
591: CURSOR cur_get_level_name IS
592: SELECT name
593: FROM bis_levels_vl bl

Line 593: FROM bis_levels_vl bl

589: l_lvl_name bis_levels_vl.name%TYPE;
590:
591: CURSOR cur_get_level_name IS
592: SELECT name
593: FROM bis_levels_vl bl
594: , BIS_IND_TL_LVL_V bitlv
595: WHERE bitlv.level_id = bl.level_id
596: AND bitlv.indicator_id = kpi_id;
597: