2481: CURSOR ahl_unit_accomplish_csr (p_unit_effectivity_id IN NUMBER) IS
2482:
2483: /*
2484: SELECT ua.counter_id, ua.counter_value, cs.uom_code, cs.name counter_name
2485: FROM ahl_unit_accomplishmnts ua, cs_counters_v cs
2486: WHERE ua.counter_id = cs.counter_id AND
2487: ua.unit_effectivity_id = p_unit_effectivity_id
2488: ORDER BY cs.uom_code;
2489: */
2499: CS.UOM_CODE,
2500: --CS.NAME COUNTER_NAME
2501: CS.COUNTER_TEMPLATE_NAME COUNTER_NAME
2502: FROM
2503: AHL_UNIT_ACCOMPLISHMNTS UA,
2504: CSI_COUNTERS_VL CS
2505: WHERE
2506: UA.COUNTER_ID = CS.COUNTER_ID AND
2507: UA.UNIT_EFFECTIVITY_ID = P_UNIT_EFFECTIVITY_ID