DBA Data[Home] [Help]

APPS.BIS_WEIGHTED_MEASURE_PUB dependencies on BIS_INDICATORS

Line 511: bis_indicators B

507:
508: CURSOR c_measure_name IS
509: SELECT V.name
510: FROM bis_display_measures_v V,
511: bis_indicators B
512: WHERE B.short_name =V.short_name
513: AND B.indicator_id = p_Bis_WM_Rec.dependent_measure_id;
514:
515: BEGIN

Line 3407: p_wkpi_id IN BIS_INDICATORS.INDICATOR_ID%TYPE,

3403:
3404: end Set_Weights_Data;
3405:
3406: FUNCTION Get_Dep_KPI_Format_Mask (
3407: p_wkpi_id IN BIS_INDICATORS.INDICATOR_ID%TYPE,
3408: p_dep_kpi_id IN BIS_INDICATORS.INDICATOR_ID%TYPE
3409: ) RETURN AK_REGION_ITEMS_VL.ATTRIBUTE7%TYPE IS
3410: CURSOR format_mask_cur IS
3411: SELECT attribute7

Line 3408: p_dep_kpi_id IN BIS_INDICATORS.INDICATOR_ID%TYPE

3404: end Set_Weights_Data;
3405:
3406: FUNCTION Get_Dep_KPI_Format_Mask (
3407: p_wkpi_id IN BIS_INDICATORS.INDICATOR_ID%TYPE,
3408: p_dep_kpi_id IN BIS_INDICATORS.INDICATOR_ID%TYPE
3409: ) RETURN AK_REGION_ITEMS_VL.ATTRIBUTE7%TYPE IS
3410: CURSOR format_mask_cur IS
3411: SELECT attribute7
3412: FROM bis_indicators wkpi, bis_indicators dkpi, ak_region_items_vl r

Line 3412: FROM bis_indicators wkpi, bis_indicators dkpi, ak_region_items_vl r

3408: p_dep_kpi_id IN BIS_INDICATORS.INDICATOR_ID%TYPE
3409: ) RETURN AK_REGION_ITEMS_VL.ATTRIBUTE7%TYPE IS
3410: CURSOR format_mask_cur IS
3411: SELECT attribute7
3412: FROM bis_indicators wkpi, bis_indicators dkpi, ak_region_items_vl r
3413: WHERE wkpi.indicator_id = p_wkpi_id
3414: AND dkpi.indicator_id = p_dep_kpi_id
3415: AND BSC_BIS_MEASURE_PUB.Get_Primary_Data_Source(p_wkpi_id) = r.region_code
3416: AND dkpi.short_name = r.attribute2