APPS.CSM_CTR_PROP_READ_EVENT_PKG dependencies on CSM_COUNTER_VALUES_ACC

Line 32: csm_counter_values_acc VACC

28: SELECT
29: B.COUNTER_PROP_VALUE_ID
30: FROM
31: CSI_CTR_PROPERTY_READINGS B,
32: csm_counter_values_acc VACC
33: WHERE B.COUNTER_VALUE_ID = VACC.COUNTER_VALUE_ID
34: AND VACC.USER_ID = c_user_id
35: AND VACC.COUNTER_VALUE_ID = c_counter_value_id
36: AND NOT EXISTS( SELECT 1

Line 217: csm_counter_values_acc val_acc

213: SELECT CSM_COUNTER_PROP_VALUES_ACC_S.NEXTVAL,
214: prd.counter_prop_value_id,
215: val_acc.user_id
216: FROM CSI_CTR_PROPERTY_READINGS prd,
217: csm_counter_values_acc val_acc
218: where prd.counter_value_id = val_acc.counter_value_id
219: AND val_acc.creation_date >= c_last_run_date
220: AND NOT EXISTS
221: (SELECT 1 FROM CSM_COUNTER_PROP_VALUES_ACC prop_acc

Line 236: (SELECT 1 FROM csm_counter_values_acc val_acc

232: FROM CSI_CTR_PROPERTY_READINGS prd,
233: CSM_COUNTER_PROP_VALUES_ACC prop_acc
234: where prd.counter_prop_value_id = prop_acc.counter_prop_value_id
235: AND NOT EXISTS
236: (SELECT 1 FROM csm_counter_values_acc val_acc
237: WHERE prd.counter_value_id = val_acc.counter_value_id
238: AND prop_acc.user_id = val_acc.user_id);
239:
240: