APPS.CSM_COUNTER_EVENT_PKG dependencies on CSM_COUNTERS_ACC

Line 15: g_counters_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_COUNTERS_ACC';

11: -- Ctr_Val_MDirty_U_ForEachUser
12: -- --------- ------ ------------------------------------------
13:
14: /*** Globals ***/
15: g_counters_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_COUNTERS_ACC';
16: g_counters_table_name CONSTANT VARCHAR2(30) := 'CS_COUNTERS';
17: g_counters_seq_name CONSTANT VARCHAR2(30) := 'CSM_COUNTERS_ACC_S';
18: g_counters_pk1_name CONSTANT VARCHAR2(30) := 'COUNTER_ID';
19: g_counters_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=

Line 17: g_counters_seq_name CONSTANT VARCHAR2(30) := 'CSM_COUNTERS_ACC_S';

13:
14: /*** Globals ***/
15: g_counters_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_COUNTERS_ACC';
16: g_counters_table_name CONSTANT VARCHAR2(30) := 'CS_COUNTERS';
17: g_counters_seq_name CONSTANT VARCHAR2(30) := 'CSM_COUNTERS_ACC_S';
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:

Line 288: FROM csm_counters_acc acc

284: CURSOR l_user_ids_csr (p_counter_id cs_counters.counter_id%TYPE)
285: IS
286: SELECT acc.user_id,
287: acc.access_id
288: FROM csm_counters_acc acc
289: WHERE acc.counter_id = p_counter_id;
290:
291: BEGIN
292: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 432: csm_counters_acc cnt_acc,

428: acc.instance_id
429: FROM CSI_COUNTER_READINGS cval,
430: csi_counter_associations cas,
431: csi_counters_b ctr,
432: csm_counters_acc cnt_acc,
433: csm_item_instances_acc acc
434: WHERE cval.transaction_id = p_counter_grp_log_id
435: AND cas.source_object_code = 'CP'
436: AND ctr.counter_id = cas.counter_id

Line 454: csm_counters_acc acc

450: FROM CSI_COUNTERS_B cntrs,
451: CSI_COUNTER_READINGS cval,
452: CSI_COUNTER_ASSOCIATIONS cas,
453: csm_item_instances_acc iacc,
454: csm_counters_acc acc
455: WHERE acc.user_id = p_user_id
456: AND acc.counter_id = p_counter_id
457: AND iacc.user_id = acc.user_id
458: AND cntrs.counter_id = acc.counter_id

Line 697: csm_counters_acc cnt_acc,

693: cval.counter_value_id
694: FROM CSI_COUNTERS_B cntrs,
695: CSI_COUNTER_READINGS cval,
696: CSI_COUNTER_ASSOCIATIONS cas,
697: csm_counters_acc cnt_acc,
698: csm_item_instances_acc acc
699: WHERE cntrs.counter_id = cas.counter_id
700: AND cas.source_object_code = 'CP'
701: AND cas.source_object_id = p_instance_id