APPS.AHL_UMP_UNITMAINT_PVT dependencies on AHL_UNIT_ACCOMPLISHMNTS

Line 2289: FROM AHL_UNIT_ACCOMPLISHMNTS

2285: ) WHERE ROWNUM < 2;
2286:
2287: CURSOR l_get_prev_ctr_csr(p_accomplishment_id IN NUMBER) IS
2288: SELECT OBJECT_VERSION_NUMBER, COUNTER_ID
2289: FROM AHL_UNIT_ACCOMPLISHMNTS
2290: WHERE UNIT_ACCOMPLISHMNT_ID = p_accomplishment_id;
2291:
2292: CURSOR l_ue_id_check_csr(p_accomplishment_id IN NUMBER, p_ue_id IN NUMBER) IS
2293: SELECT 'x'

Line 2294: FROM AHL_UNIT_ACCOMPLISHMNTS

2290: WHERE UNIT_ACCOMPLISHMNT_ID = p_accomplishment_id;
2291:
2292: CURSOR l_ue_id_check_csr(p_accomplishment_id IN NUMBER, p_ue_id IN NUMBER) IS
2293: SELECT 'x'
2294: FROM AHL_UNIT_ACCOMPLISHMNTS
2295: WHERE UNIT_ACCOMPLISHMNT_ID = p_accomplishment_id AND
2296: UNIT_EFFECTIVITY_ID = p_ue_id;
2297:
2298: l_prev_object_version_no NUMBER;

Line 2515: FROM AHL_UNIT_ACCOMPLISHMNTS

2511: AND UDF.unit_effectivity_id = p_ue_id;
2512:
2513: CURSOR l_accomplish_exists_csr(p_ue_id IN NUMBER) IS
2514: SELECT 'x'
2515: FROM AHL_UNIT_ACCOMPLISHMNTS
2516: WHERE unit_effectivity_id = p_ue_id;
2517:
2518: CURSOR l_get_unit_effectivity_csr(p_ue_id IN NUMBER) IS
2519: SELECT

Line 2587: FROM ahl_unit_accomplishmnts

2583: AND relationship_code = 'PARENT';
2584:
2585: CURSOR l_get_accomplishments(p_ue_id IN NUMBER) IS
2586: SELECT UNIT_ACCOMPLISHMNT_ID
2587: FROM ahl_unit_accomplishmnts
2588: WHERE UNIT_EFFECTIVITY_ID = p_ue_id;
2589:
2590: CURSOR l_get_thresholds(p_ue_id IN NUMBER) IS
2591: SELECT UNIT_THRESHOLD_ID

Line 3583: FROM AHL_UNIT_ACCOMPLISHMNTS

3579: ATTRIBUTE12,
3580: ATTRIBUTE13,
3581: ATTRIBUTE14,
3582: ATTRIBUTE15
3583: FROM AHL_UNIT_ACCOMPLISHMNTS
3584: WHERE UNIT_ACCOMPLISHMNT_ID = p_accomplish_id
3585: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
3586:
3587: CURSOR l_get_dup_counter_csr(p_ue_id IN NUMBER,

Line 3590: FROM AHL_UNIT_ACCOMPLISHMNTS

3586:
3587: CURSOR l_get_dup_counter_csr(p_ue_id IN NUMBER,
3588: p_counter_id IN NUMBER) IS
3589: SELECT 'x'
3590: FROM AHL_UNIT_ACCOMPLISHMNTS
3591: WHERE UNIT_EFFECTIVITY_ID = p_ue_id AND
3592: COUNTER_ID = p_counter_id;
3593:
3594: l_accomplish_details l_get_unit_accomplish_csr%ROWTYPE;

Line 3970: --FROM CS_COUNTERS C, ahl_unit_accomplishmnts ua

3966: and cca.source_object_id = p_instance_id
3967: MINUS
3968: --SELECT c.name counter_name
3969: SELECt c.COUNTER_TEMPLATE_NAME counter_name
3970: --FROM CS_COUNTERS C, ahl_unit_accomplishmnts ua
3971: FROM csi_counters_vl C, ahl_unit_accomplishmnts ua
3972: WHERE c.COUNTER_ID = UA.COUNTER_ID
3973: AND UA.unit_effectivity_id = p_unit_effectivity_id;
3974:

Line 3971: FROM csi_counters_vl C, ahl_unit_accomplishmnts ua

3967: MINUS
3968: --SELECT c.name counter_name
3969: SELECt c.COUNTER_TEMPLATE_NAME counter_name
3970: --FROM CS_COUNTERS C, ahl_unit_accomplishmnts ua
3971: FROM csi_counters_vl C, ahl_unit_accomplishmnts ua
3972: WHERE c.COUNTER_ID = UA.COUNTER_ID
3973: AND UA.unit_effectivity_id = p_unit_effectivity_id;
3974:
3975: BEGIN

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

4030: l_inst_sql := ' select distinct counter_template_name counter_name from csi_counters_vl cc, csi_counter_associations cca ';
4031: 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';
4032:
4033: -- Counters for the Accomplishment
4034: --l_acc_sql := ' select distinct counter_name from csi_cp_counters_v co, ahl_unit_accomplishmnts ua';
4035: l_acc_sql := ' select distinct counter_template_name counter_name from csi_counters_vl cc, ahl_unit_accomplishmnts ua';
4036: l_acc_sql := l_acc_sql || ' where ua.unit_effectivity_id = :2';
4037: l_acc_sql := l_acc_sql || ' and ua.counter_id = cc.counter_id';
4038: l_acc_sql := l_acc_sql || ' order by counter_name ';

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

4031: 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';
4032:
4033: -- Counters for the Accomplishment
4034: --l_acc_sql := ' select distinct counter_name from csi_cp_counters_v co, ahl_unit_accomplishmnts ua';
4035: l_acc_sql := ' select distinct counter_template_name counter_name from csi_counters_vl cc, ahl_unit_accomplishmnts ua';
4036: l_acc_sql := l_acc_sql || ' where ua.unit_effectivity_id = :2';
4037: l_acc_sql := l_acc_sql || ' and ua.counter_id = cc.counter_id';
4038: l_acc_sql := l_acc_sql || ' order by counter_name ';
4039: