APPS.CSM_COUNTER_EVENT_PKG dependencies on CSM_COUNTER_VALUES_ACC

Line 22: g_counter_val_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_COUNTER_VALUES_ACC';

18: g_counters_pk1_name CONSTANT VARCHAR2(30) := 'COUNTER_ID';
19: g_counters_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=
20: CSM_ACC_PKG.t_publication_item_list('CSF_M_COUNTERS');
21:
22: g_counter_val_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_COUNTER_VALUES_ACC';
23: g_counter_val_table_name CONSTANT VARCHAR2(30) := 'CS_COUNTER_VALUES';
24: g_counter_val_seq_name CONSTANT VARCHAR2(30) := 'CSM_COUNTER_VALUES_ACC_S';
25: g_counter_val_pk1_name CONSTANT VARCHAR2(30) := 'COUNTER_VALUE_ID';
26: g_counter_val_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=

Line 24: g_counter_val_seq_name CONSTANT VARCHAR2(30) := 'CSM_COUNTER_VALUES_ACC_S';

20: CSM_ACC_PKG.t_publication_item_list('CSF_M_COUNTERS');
21:
22: g_counter_val_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_COUNTER_VALUES_ACC';
23: g_counter_val_table_name CONSTANT VARCHAR2(30) := 'CS_COUNTER_VALUES';
24: g_counter_val_seq_name CONSTANT VARCHAR2(30) := 'CSM_COUNTER_VALUES_ACC_S';
25: g_counter_val_pk1_name CONSTANT VARCHAR2(30) := 'COUNTER_VALUE_ID';
26: g_counter_val_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=
27: CSM_ACC_PKG.t_publication_item_list('CSF_M_COUNTER_VALUES');
28:

Line 44: FROM csm_counter_values_acc acc,

40:
41: CURSOR l_counter_value_csr(p_counter_id cs_counters.counter_id%TYPE, p_user_id NUMBER)
42: IS
43: SELECT cval.counter_value_id
44: FROM csm_counter_values_acc acc,
45: CSI_COUNTER_READINGS cval
46: WHERE acc.user_id = p_user_id
47: AND acc.counter_value_id = cval.counter_value_id
48: AND cval.counter_id = p_counter_id;

Line 228: FROM csm_counter_values_acc vacc

224: AND acc.user_id = p_user_id
225: AND cval.counter_id = p_counter_id
226: AND EXISTS
227: (SELECT 1
228: FROM csm_counter_values_acc vacc
229: WHERE vacc.counter_value_id = cval.counter_value_id
230: AND vacc.user_id = acc.user_id
231: );
232:

Line 467: FROM csm_counter_values_acc cv_acc

463: AND cas.source_object_id = iacc.instance_id
464: AND cval.counter_id = p_counter_id
465: AND EXISTS
466: (SELECT 1
467: FROM csm_counter_values_acc cv_acc
468: WHERE cv_acc.user_id = acc.user_id
469: AND cv_acc.counter_value_id = cval.counter_value_id
470: )
471: ORDER BY cval.value_timestamp desc;

Line 576: FROM csm_counter_values_acc acc,

572: IS
573: SELECT acc.user_id,
574: acc.access_id,
575: cv.counter_value_id
576: FROM csm_counter_values_acc acc,
577: CSI_COUNTER_READINGS cv
578: WHERE acc.counter_value_id = cv.counter_value_id
579: AND cv.transaction_id = p_counter_grp_log_id;
580: