APPS.AHL_PRD_DF_PVT dependencies on CS_COUNTERS

Line 2678: FROM CS_COUNTERS CO,ahl_unit_thresholds UT

2674: l_count2 NUMBER;
2675:
2676: CURSOR counter_values_csr(p_unit_deferral_id IN NUMBER) IS
2677: SELECT UT.counter_id, CO.name, UT.counter_value, UT.ctr_value_type_code,CO.uom_code
2678: FROM CS_COUNTERS CO,ahl_unit_thresholds UT
2679: WHERE CO.counter_id = UT.counter_id
2680: AND UT.unit_deferral_id = p_unit_deferral_id;
2681:
2682: l_counter_id NUMBER;

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

5487: -- fetch deferral schedule rec
5488: CURSOR df_schedule_tbl_csr(p_unit_deferral_id IN NUMBER) IS
5489: SELECT UT.unit_threshold_id,UT.object_version_number,UT.unit_deferral_id, UT.counter_id,
5490: CO.name, UT.counter_value, UT.ctr_value_type_code,MU.unit_of_measure
5491: FROM MTL_UNITS_OF_MEASURE_VL MU, CS_COUNTERS CO,ahl_unit_thresholds UT
5492: WHERE MU.uom_code = CO.uom_code
5493: AND CO.counter_id = UT.counter_id
5494: AND UT.unit_deferral_id = p_unit_deferral_id
5495: ORDER BY CO.name;