APPS.AHL_UMP_PROCESSUNIT_PVT dependencies on AHL_UNIT_THRESHOLDS

Line 4663: CURSOR ahl_unit_thresholds_csr (p_unit_deferral_id IN NUMBER) IS

4659: ue.mr_header_id IN (select mr_header_id from ahl_mr_headers_b mr where mr.title = p_title) AND
4660: ue.status_code = 'INIT-DUE';
4661:
4662: -- get all init-due counter records setup for this unit effectivity.
4663: CURSOR ahl_unit_thresholds_csr (p_unit_deferral_id IN NUMBER) IS
4664: SELECT counter_id, counter_value
4665: FROM ahl_unit_thresholds
4666: WHERE unit_deferral_id = p_unit_deferral_id;
4667:

Line 4665: FROM ahl_unit_thresholds

4661:
4662: -- get all init-due counter records setup for this unit effectivity.
4663: CURSOR ahl_unit_thresholds_csr (p_unit_deferral_id IN NUMBER) IS
4664: SELECT counter_id, counter_value
4665: FROM ahl_unit_thresholds
4666: WHERE unit_deferral_id = p_unit_deferral_id;
4667:
4668: -- added for performance fix bug# 6893404.
4669: CURSOR get_interval_ctr_name(p_mr_effectivity_id IN NUMBER) IS

Line 4776: FOR threshold_rec IN ahl_unit_thresholds_csr (l_unit_deferral_id)

4772: AHL_DEBUG_PUB.Debug('INIT-Due processing: Set due_date:UE_ID:' || l_set_due_date || ':' || l_unit_effectivity_id);
4773: END IF;
4774: --dbms_output.put_line ('in INIT-due part: due_date' || l_set_due_date);
4775:
4776: FOR threshold_rec IN ahl_unit_thresholds_csr (l_unit_deferral_id)
4777: LOOP
4778: -- for init due, ctr_value_type_code is always 'defer_to'.
4779: l_due_at_counter_value := threshold_rec.counter_value;
4780: l_counter_remain := 0;

Line 5837: FOR threshold_rec IN ahl_unit_thresholds_csr (l_unit_deferral_id)

5833: IF (ahl_init_due_csr%FOUND) THEN
5834:
5835: --dbms_output.put_line ('in INIT-due part: due_date' || l_set_due_date);
5836:
5837: FOR threshold_rec IN ahl_unit_thresholds_csr (l_unit_deferral_id)
5838: LOOP
5839: -- for init due, ctr_value_type_code is always 'defer_to'.
5840: l_due_at_counter_value := threshold_rec.counter_value;
5841: l_counter_remain := 0;

Line 10093: FROM ahl_unit_thresholds

10089:
10090: -- Get threshold details.
10091: CURSOR ahl_unit_threshold_csr (p_unit_deferral_id IN NUMBER) IS
10092: SELECT counter_id, counter_value, ctr_value_type_code
10093: FROM ahl_unit_thresholds
10094: WHERE unit_deferral_id = p_unit_deferral_id;
10095:
10096: -- Read applicable relns table for group MR details.
10097: CURSOR ahl_applicable_grp_csr( p_item_instance_id IN NUMBER,

Line 16261: FROM ahl_unit_thresholds aut, ahl_unit_deferrals_b udf

16257: -- added for USAF: Assembly Maint. Enh.: Support for initializing a NR.
16258: -- Get threshold details.
16259: CURSOR ahl_unit_threshold_csr (p_ue_id IN NUMBER) IS
16260: SELECT aut.counter_id, aut.counter_value, (select uom_code from csi_counters_b where counter_id = aut.counter_id) uom_code
16261: FROM ahl_unit_thresholds aut, ahl_unit_deferrals_b udf
16262: WHERE udf.unit_effectivity_id = p_ue_id
16263: AND udf.unit_deferral_id = aut.unit_deferral_id
16264: AND udf.unit_deferral_type = 'INIT-DUE';
16265: