APPS.CSM_COUNTER_READING_EVENT_PKG dependencies on CSM_COUNTERS_ACC

Line 45: csm_counters_acc cnt_acc

41: cnt_rd.counter_value_id,
42: cnt_acc.counter_id,
43: cnt_acc.user_id
44: FROM CSI_COUNTER_READINGS cnt_rd,
45: csm_counters_acc cnt_acc
46: where cnt_rd.counter_id=cnt_acc.counter_id
47: AND NOT EXISTS
48: (SELECT 1 FROM csm_counter_values_acc val_acc
49: WHERE VAL_acc.counter_value_id =cnt_rd.counter_value_id);

Line 71: (SELECT 1 FROM csm_counters_acc cnt_acc

67: FROM CSI_COUNTER_READINGS cnt_rd,
68: csm_counter_values_acc val_acc
69: where cnt_rd.counter_id = val_acc.counter_id
70: AND NOT EXISTS
71: (SELECT 1 FROM csm_counters_acc cnt_acc
72: WHERE cnt_acc.counter_id =val_acc.counter_id
73: AND cnt_acc.user_id =val_acc.user_id);
74:
75:

Line 264: csm_counters_acc cnt_acc

260: cnt_rd.counter_value_id,
261: cnt_acc.counter_id,
262: cnt_acc.user_id
263: FROM CSI_COUNTER_READINGS cnt_rd,
264: csm_counters_acc cnt_acc
265: where cnt_rd.counter_id=cnt_acc.counter_id
266: AND cnt_rd.counter_value_id = c_counter_value_id
267: AND cnt_acc.counter_id = c_counter_id
268: AND NOT EXISTS