APPS.BIS_DIMS_AND_LEVELS_PKG dependencies on BIS_IND_TL_LVL_V

Line 108: , BIS_IND_TL_LVL_V bitlv

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
112: AND bitlv.level_id = bl.level_id

Line 243: ' , BIS_IND_TL_LVL_V bitlv ';

239:
240: IF (l_pvalue <> 'All') THEN
241: l_kpi_nm_filter := ' AND bi.name = ''' || l_pvalue || ''' ';
242: l_kpi_table_names := ' , bis_indicators_vl bi ' ||
243: ' , BIS_IND_TL_LVL_V bitlv ';
244: l_kpi_where_clause := ' AND bitlv.indicator_id = bi.indicator_id ' ||
245: ' AND bitlv.level_id = bl.level_id ';
246: END IF;
247:

Line 594: , BIS_IND_TL_LVL_V bitlv

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:
598: BEGIN

Line 638: , BIS_IND_TL_LVL_V bitlv

634:
635: CURSOR cur_get_kpi_name IS
636: SELECT DISTINCT name
637: FROM bis_indicators_vl bi
638: , BIS_IND_TL_LVL_V bitlv
639: WHERE bitlv.indicator_id = bi.indicator_id
640: AND bitlv.level_id = lvl_id;
641:
642: BEGIN