APPS.AHL_UMP_UNITMAINT_PVT dependencies on AHL_UNIT_ACCOMPLISHMNTS

Line 2021: FROM AHL_UNIT_ACCOMPLISHMNTS

2017: CCR.VALUE_TIMESTAMP ASC;
2018:
2019: CURSOR l_get_prev_ctr_csr(p_accomplishment_id IN NUMBER) IS
2020: SELECT OBJECT_VERSION_NUMBER, COUNTER_ID
2021: FROM AHL_UNIT_ACCOMPLISHMNTS
2022: WHERE UNIT_ACCOMPLISHMNT_ID = p_accomplishment_id;
2023:
2024: CURSOR l_ue_id_check_csr(p_accomplishment_id IN NUMBER, p_ue_id IN NUMBER) IS
2025: SELECT 'x'

Line 2026: FROM AHL_UNIT_ACCOMPLISHMNTS

2022: WHERE UNIT_ACCOMPLISHMNT_ID = p_accomplishment_id;
2023:
2024: CURSOR l_ue_id_check_csr(p_accomplishment_id IN NUMBER, p_ue_id IN NUMBER) IS
2025: SELECT 'x'
2026: FROM AHL_UNIT_ACCOMPLISHMNTS
2027: WHERE UNIT_ACCOMPLISHMNT_ID = p_accomplishment_id AND
2028: UNIT_EFFECTIVITY_ID = p_ue_id;
2029:
2030: l_prev_object_version_no NUMBER;

Line 2206: FROM AHL_UNIT_ACCOMPLISHMNTS

2202: AND UDF.unit_effectivity_id = p_ue_id;
2203:
2204: CURSOR l_accomplish_exists_csr(p_ue_id IN NUMBER) IS
2205: SELECT 'x'
2206: FROM AHL_UNIT_ACCOMPLISHMNTS
2207: WHERE unit_effectivity_id = p_ue_id;
2208:
2209: CURSOR l_get_unit_effectivity_csr(p_ue_id IN NUMBER) IS
2210: SELECT

Line 2278: FROM ahl_unit_accomplishmnts

2274: AND relationship_code = 'PARENT';
2275:
2276: CURSOR l_get_accomplishments(p_ue_id IN NUMBER) IS
2277: SELECT UNIT_ACCOMPLISHMNT_ID
2278: FROM ahl_unit_accomplishmnts
2279: WHERE UNIT_EFFECTIVITY_ID = p_ue_id;
2280:
2281: CURSOR l_get_thresholds(p_ue_id IN NUMBER) IS
2282: SELECT UNIT_THRESHOLD_ID

Line 3270: FROM AHL_UNIT_ACCOMPLISHMNTS

3266: ATTRIBUTE12,
3267: ATTRIBUTE13,
3268: ATTRIBUTE14,
3269: ATTRIBUTE15
3270: FROM AHL_UNIT_ACCOMPLISHMNTS
3271: WHERE UNIT_ACCOMPLISHMNT_ID = p_accomplish_id
3272: FOR UPDATE OF OBJECT_VERSION_NUMBER;
3273:
3274: CURSOR l_get_dup_counter_csr(p_ue_id IN NUMBER,

Line 3277: FROM AHL_UNIT_ACCOMPLISHMNTS

3273:
3274: CURSOR l_get_dup_counter_csr(p_ue_id IN NUMBER,
3275: p_counter_id IN NUMBER) IS
3276: SELECT 'x'
3277: FROM AHL_UNIT_ACCOMPLISHMNTS
3278: WHERE UNIT_EFFECTIVITY_ID = p_ue_id AND
3279: COUNTER_ID = p_counter_id;
3280:
3281: l_accomplish_details l_get_unit_accomplish_csr%ROWTYPE;

Line 3657: --FROM CS_COUNTERS C, ahl_unit_accomplishmnts ua

3653: and cca.source_object_id = p_instance_id
3654: MINUS
3655: --SELECT c.name counter_name
3656: SELECt c.COUNTER_TEMPLATE_NAME counter_name
3657: --FROM CS_COUNTERS C, ahl_unit_accomplishmnts ua
3658: FROM csi_counters_vl C, ahl_unit_accomplishmnts ua
3659: WHERE c.COUNTER_ID = UA.COUNTER_ID
3660: AND UA.unit_effectivity_id = p_unit_effectivity_id;
3661:

Line 3658: FROM csi_counters_vl C, ahl_unit_accomplishmnts ua

3654: MINUS
3655: --SELECT c.name counter_name
3656: SELECt c.COUNTER_TEMPLATE_NAME counter_name
3657: --FROM CS_COUNTERS C, ahl_unit_accomplishmnts ua
3658: FROM csi_counters_vl C, ahl_unit_accomplishmnts ua
3659: WHERE c.COUNTER_ID = UA.COUNTER_ID
3660: AND UA.unit_effectivity_id = p_unit_effectivity_id;
3661:
3662: BEGIN

Line 3721: --l_acc_sql := ' select distinct counter_name from csi_cp_counters_v co, ahl_unit_accomplishmnts ua';

3717: l_inst_sql := ' select distinct counter_template_name counter_name from csi_counters_vl cc, csi_counter_associations cca ';
3718: l_inst_sql := l_inst_sql || ' where cc.counter_id = cca.counter_id and cca.source_object_code = ''CP'' and cca.source_object_id = :1';
3719:
3720: -- Counters for the Accomplishment
3721: --l_acc_sql := ' select distinct counter_name from csi_cp_counters_v co, ahl_unit_accomplishmnts ua';
3722: l_acc_sql := ' select distinct counter_template_name counter_name from csi_counters_vl cc, ahl_unit_accomplishmnts ua';
3723: l_acc_sql := l_acc_sql || ' where ua.unit_effectivity_id = :2';
3724: l_acc_sql := l_acc_sql || ' and ua.counter_id = cc.counter_id';
3725: l_acc_sql := l_acc_sql || ' order by counter_name ';

Line 3722: l_acc_sql := ' select distinct counter_template_name counter_name from csi_counters_vl cc, ahl_unit_accomplishmnts ua';

3718: l_inst_sql := l_inst_sql || ' where cc.counter_id = cca.counter_id and cca.source_object_code = ''CP'' and cca.source_object_id = :1';
3719:
3720: -- Counters for the Accomplishment
3721: --l_acc_sql := ' select distinct counter_name from csi_cp_counters_v co, ahl_unit_accomplishmnts ua';
3722: l_acc_sql := ' select distinct counter_template_name counter_name from csi_counters_vl cc, ahl_unit_accomplishmnts ua';
3723: l_acc_sql := l_acc_sql || ' where ua.unit_effectivity_id = :2';
3724: l_acc_sql := l_acc_sql || ' and ua.counter_id = cc.counter_id';
3725: l_acc_sql := l_acc_sql || ' order by counter_name ';
3726: