APPS.CSI_COUNTER_PVT dependencies on CSI_COUNTER_READINGS

Line 2017: from CSI_COUNTER_READINGS

2013: l_source_dist_ref_id2 NUMBER;
2014:
2015: CURSOR LAST_CTR_READING_CUR(p_counter_id IN NUMBER,p_reading_lock_date IN DATE) IS
2016: select value_timestamp
2017: from CSI_COUNTER_READINGS
2018: where counter_id = p_counter_id
2019: and nvl(disabled_flag,'N') = 'N'
2020: and value_timestamp <= p_reading_lock_date
2021: ORDER BY value_timestamp desc;

Line 2505: FROM csi_counter_readings

2501: WHERE source_counter_id = p_counter_id and relationship_type_code = 'CONFIGURATION';
2502: l_target_ctr_exist NUMBER;
2503: CURSOR counter_readings_cur(p_counter_id NUMBER) IS
2504: SELECT counter_value_id
2505: FROM csi_counter_readings
2506: WHERE counter_id = p_counter_id;
2507: l_rdg_exists NUMBER;
2508:
2509: -- for counter name check

Line 4176: FROM csi_counter_readings

4172: (px_ctr_val_max_seq_no <> FND_API.G_MISS_NUM) THEN
4173: BEGIN
4174: SELECT 'Y', value_timestamp
4175: INTO l_ctr_val_id_exist, l_new_value_timestamp
4176: FROM csi_counter_readings
4177: WHERE counter_id = p_counter_id
4178: AND counter_value_id = px_ctr_val_max_seq_no
4179: AND NVL(disabled_flag, 'N') = 'N';
4180: EXCEPTION

Line 4193: FROM csi_counter_readings

4189: ELSE --l_old_ctr_val_max_seq_no > 0
4190: BEGIN
4191: SELECT 'Y'
4192: INTO l_new_reading_is_latest
4193: FROM csi_counter_readings
4194: WHERE counter_id = p_counter_id
4195: AND counter_value_id = l_old_ctr_val_max_seq_no
4196: AND NVL(disabled_flag, 'N') = 'N'
4197: AND value_timestamp < l_new_value_timestamp;

Line 4213: FROM csi_counter_readings

4209: BEGIN
4210: SELECT counter_value_id, value_timestamp, 'Y', 'Y'
4211: INTO px_ctr_val_max_seq_no, l_new_value_timestamp,
4212: l_ctr_val_id_exist, l_new_reading_is_latest
4213: FROM csi_counter_readings
4214: WHERE counter_id = p_counter_id
4215: AND value_timestamp =
4216: (SELECT MAX(value_timestamp) FROM csi_counter_readings
4217: WHERE counter_id = p_counter_id AND NVL(disabled_flag, 'N') = 'N');

Line 4216: (SELECT MAX(value_timestamp) FROM csi_counter_readings

4212: l_ctr_val_id_exist, l_new_reading_is_latest
4213: FROM csi_counter_readings
4214: WHERE counter_id = p_counter_id
4215: AND value_timestamp =
4216: (SELECT MAX(value_timestamp) FROM csi_counter_readings
4217: WHERE counter_id = p_counter_id AND NVL(disabled_flag, 'N') = 'N');
4218: EXCEPTION
4219: WHEN NO_DATA_FOUND THEN
4220: px_ctr_val_max_seq_no := 0;