APPS.AHL_UMP_PROCESSUNIT_PVT dependencies on AHL_UNIT_THRESHOLDS

Line 3644: CURSOR ahl_unit_thresholds_csr (p_unit_deferral_id IN NUMBER) IS

3640: ue.mr_header_id = p_mr_header_id AND
3641: ue.status_code = 'INIT-DUE';
3642:
3643: -- get all init-due counter records setup for this unit effectivity.
3644: CURSOR ahl_unit_thresholds_csr (p_unit_deferral_id IN NUMBER) IS
3645: SELECT counter_id, counter_value
3646: FROM ahl_unit_thresholds
3647: WHERE unit_deferral_id = p_unit_deferral_id;
3648:

Line 3646: FROM ahl_unit_thresholds

3642:
3643: -- get all init-due counter records setup for this unit effectivity.
3644: CURSOR ahl_unit_thresholds_csr (p_unit_deferral_id IN NUMBER) IS
3645: SELECT counter_id, counter_value
3646: FROM ahl_unit_thresholds
3647: WHERE unit_deferral_id = p_unit_deferral_id;
3648:
3649: -- added for performance fix bug# 6893404.
3650: CURSOR get_interval_ctr_name(p_mr_effectivity_id IN NUMBER) IS

Line 3748: FOR threshold_rec IN ahl_unit_thresholds_csr (l_unit_deferral_id)

3744: AHL_DEBUG_PUB.Debug('INIT-Due processing: Set due_date:' || l_set_due_date);
3745: END IF;
3746: --dbms_output.put_line ('in INIT-due part: due_date' || l_set_due_date);
3747:
3748: FOR threshold_rec IN ahl_unit_thresholds_csr (l_unit_deferral_id)
3749: LOOP
3750: -- for init due, ctr_value_type_code is always 'defer_to'.
3751: l_due_at_counter_value := threshold_rec.counter_value;
3752: l_counter_remain := 0;

Line 4616: FOR threshold_rec IN ahl_unit_thresholds_csr (l_unit_deferral_id)

4612: IF (ahl_init_due_csr%FOUND) THEN
4613:
4614: --dbms_output.put_line ('in INIT-due part: due_date' || l_set_due_date);
4615:
4616: FOR threshold_rec IN ahl_unit_thresholds_csr (l_unit_deferral_id)
4617: LOOP
4618: -- for init due, ctr_value_type_code is always 'defer_to'.
4619: l_due_at_counter_value := threshold_rec.counter_value;
4620: l_counter_remain := 0;

Line 8604: FROM ahl_unit_thresholds

8600:
8601: -- Get threshold details.
8602: CURSOR ahl_unit_threshold_csr (p_unit_deferral_id IN NUMBER) IS
8603: SELECT counter_id, counter_value, ctr_value_type_code
8604: FROM ahl_unit_thresholds
8605: WHERE unit_deferral_id = p_unit_deferral_id;
8606:
8607: -- Read applicable relns table for group MR details.
8608: CURSOR ahl_applicable_grp_csr( p_item_instance_id IN NUMBER,