DBA Data[Home] [Help]

APPS.BIS_UTIL dependencies on BIS_INDICATORS_VL

Line 2646: l_measure_name bis_indicators_vl.name%type;

2642: p_attribute1 IN VARCHAR2,
2643: p_attribute2 IN VARCHAR2)
2644: RETURN VARCHAR2
2645: IS
2646: l_measure_name bis_indicators_vl.name%type;
2647: BEGIN
2648: IF (p_attribute1 = BIS_AK_REGION_PUB.C_MEASURE_NO_TARGET OR p_attribute1 = BIS_AK_REGION_PUB.C_MEASURE) THEN
2649: SELECT
2650: bis_measures.name INTO l_measure_name

Line 2652: bis_indicators_vl bis_measures

2648: IF (p_attribute1 = BIS_AK_REGION_PUB.C_MEASURE_NO_TARGET OR p_attribute1 = BIS_AK_REGION_PUB.C_MEASURE) THEN
2649: SELECT
2650: bis_measures.name INTO l_measure_name
2651: FROM
2652: bis_indicators_vl bis_measures
2653: WHERE
2654: bis_measures.short_name = p_attribute2;
2655: ELSIF (p_attribute1 = BIS_AK_REGION_PUB.C_CHANGE_MEASURE_NO_TARGET OR p_attribute1 = BIS_AK_REGION_PUB.C_COMPARE_TO_MEASURE_NO_TARGET OR p_attribute1 = BIS_AK_REGION_PUB.C_PERCENT_OF_TOTAL) THEN
2656: SELECT

Line 2659: bis_indicators_vl bis_measures,

2655: ELSIF (p_attribute1 = BIS_AK_REGION_PUB.C_CHANGE_MEASURE_NO_TARGET OR p_attribute1 = BIS_AK_REGION_PUB.C_COMPARE_TO_MEASURE_NO_TARGET OR p_attribute1 = BIS_AK_REGION_PUB.C_PERCENT_OF_TOTAL) THEN
2656: SELECT
2657: bis_measures.name INTO l_measure_name
2658: FROM
2659: bis_indicators_vl bis_measures,
2660: ak_region_items_vl akRegionItems
2661: WHERE
2662: akRegionItems.region_code = p_region_code AND
2663: akRegionItems.attribute_code = p_attribute2 AND