APPS.BIS_WEIGHTED_MEASURE_PUB dependencies on AK_REGION_ITEMS_VL

Line 3409: ) RETURN AK_REGION_ITEMS_VL.ATTRIBUTE7%TYPE IS

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
3413: WHERE wkpi.indicator_id = p_wkpi_id

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

Line 3420: l_format_mask AK_REGION_ITEMS_VL.ATTRIBUTE7%TYPE;

3416: AND dkpi.short_name = r.attribute2
3417: AND r.attribute1 IN ('MEASURE', 'MEASURE_NOTARGET');
3418: l_format_mask_cur format_mask_cur%ROWTYPE;
3419:
3420: l_format_mask AK_REGION_ITEMS_VL.ATTRIBUTE7%TYPE;
3421: BEGIN
3422: OPEN format_mask_cur;
3423: FETCH format_mask_cur INTO l_format_mask_cur;
3424: IF format_mask_cur%FOUND THEN