DBA Data[Home] [Help]

APPS.AHL_UMP_PROCESSUNIT_PVT dependencies on AHL_UNIT_ACCOMPLISHMNTS

Line 2485: FROM ahl_unit_accomplishmnts ua, cs_counters_v cs

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: */

Line 2503: AHL_UNIT_ACCOMPLISHMNTS UA,

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