DBA Data[Home] [Help]

APPS.AHL_UMP_PROCESSUNIT_PVT dependencies on AHL_UNIT_ACCOMPLISHMNTS

Line 3117: FROM ahl_unit_accomplishmnts ua, cs_counters_v cs

3113: CURSOR ahl_unit_accomplish_csr (p_unit_effectivity_id IN NUMBER) IS
3114:
3115: /*
3116: SELECT ua.counter_id, ua.counter_value, cs.uom_code, cs.name counter_name
3117: FROM ahl_unit_accomplishmnts ua, cs_counters_v cs
3118: WHERE ua.counter_id = cs.counter_id AND
3119: ua.unit_effectivity_id = p_unit_effectivity_id
3120: ORDER BY cs.uom_code;
3121: */

Line 3135: AHL_UNIT_ACCOMPLISHMNTS UA,

3131: CS.UOM_CODE,
3132: --CS.NAME COUNTER_NAME
3133: CS.COUNTER_TEMPLATE_NAME COUNTER_NAME
3134: FROM
3135: AHL_UNIT_ACCOMPLISHMNTS UA,
3136: CSI_COUNTERS_VL CS
3137: WHERE
3138: UA.COUNTER_ID = CS.COUNTER_ID AND
3139: UA.UNIT_EFFECTIVITY_ID = P_UNIT_EFFECTIVITY_ID

Line 15964: AHL_UNIT_ACCOMPLISHMNTS UA,

15960: UA.COUNTER_VALUE,
15961: CS.UOM_CODE,
15962: CS.COUNTER_TEMPLATE_NAME COUNTER_NAME
15963: FROM
15964: AHL_UNIT_ACCOMPLISHMNTS UA,
15965: CSI_COUNTERS_VL CS
15966: WHERE
15967: UA.COUNTER_ID = CS.COUNTER_ID AND
15968: UA.UNIT_EFFECTIVITY_ID = P_UNIT_EFFECTIVITY_ID