[Home] [Help]
8385: RETURN NUMBER IS
8386:
8387: CURSOR c1 IS
8388: SELECT counter_value_id
8389: FROM CSI_COUNTER_READINGS
8390: WHERE counter_id = p_counter_id
8391: AND value_timestamp in
8392: (select max(value_timestamp) from CSI_COUNTER_READINGS
8393: where counter_id = p_counter_id
8388: SELECT counter_value_id
8389: FROM CSI_COUNTER_READINGS
8390: WHERE counter_id = p_counter_id
8391: AND value_timestamp in
8392: (select max(value_timestamp) from CSI_COUNTER_READINGS
8393: where counter_id = p_counter_id
8394: and disabled_flag='N');
8395:
8396: l_counter_value_id NUMBER;