APPS.AHL_PRD_DF_PVT dependencies on CS_COUNTERS

Line 2615: FROM CS_COUNTERS CO,ahl_unit_thresholds UT

2611: l_count2 NUMBER;
2612:
2613: CURSOR counter_values_csr(p_unit_deferral_id IN NUMBER) IS
2614: SELECT UT.counter_id, CO.name, UT.counter_value, UT.ctr_value_type_code,CO.uom_code
2615: FROM CS_COUNTERS CO,ahl_unit_thresholds UT
2616: WHERE CO.counter_id = UT.counter_id
2617: AND UT.unit_deferral_id = p_unit_deferral_id;
2618:
2619: l_counter_id NUMBER;

Line 5101: FROM MTL_UNITS_OF_MEASURE_VL MU, CS_COUNTERS CO,ahl_unit_thresholds UT

5097: -- fetch deferral schedule rec
5098: CURSOR df_schedule_tbl_csr(p_unit_deferral_id IN NUMBER) IS
5099: SELECT UT.unit_threshold_id,UT.object_version_number,UT.unit_deferral_id, UT.counter_id,
5100: CO.name, UT.counter_value, UT.ctr_value_type_code,MU.unit_of_measure
5101: FROM MTL_UNITS_OF_MEASURE_VL MU, CS_COUNTERS CO,ahl_unit_thresholds UT
5102: WHERE MU.uom_code = CO.uom_code
5103: AND CO.counter_id = UT.counter_id
5104: AND UT.unit_deferral_id = p_unit_deferral_id
5105: ORDER BY CO.name;