APPS.CSM_COUNTER_EVENT_PKG dependencies on CSI_COUNTERS_B

Line 98: FROM CSI_COUNTERS_B counters

94:
95: CURSOR l_acc_csr(b_counter_id NUMBER)
96: IS
97: SELECT acc.user_id
98: FROM CSI_COUNTERS_B counters
99: , CS_CSI_COUNTER_GROUPS counter_groups
100: , csm_item_instances_acc acc
101: , CSI_COUNTER_ASSOCIATIONS ass
102: WHERE counters.counter_id = ass.counter_id

Line 215: FROM CSI_COUNTERS_B cntrs,

211: CURSOR l_counter_value_csr(p_counter_id cs_counters.counter_id%TYPE, p_instance_id NUMBER,
212: p_user_id NUMBER)
213: IS
214: SELECT cval.counter_value_id
215: FROM CSI_COUNTERS_B cntrs,
216: CSI_COUNTER_READINGS cval,
217: CSI_COUNTER_ASSOCIATIONS cas,
218: csm_item_instances_acc acc
219: WHERE cntrs.counter_id = cas.counter_id

Line 357: FROM CSI_COUNTERS_B ctr

353:
354: CURSOR l_user_ids_csr (p_counter_id cs_counters.counter_id%TYPE)
355: IS
356: SELECT acc.user_id
357: FROM CSI_COUNTERS_B ctr
358: , CS_CSI_COUNTER_GROUPS cgrp
359: , csm_item_instances_acc acc
360: , CSI_COUNTER_ASSOCIATIONS cas
361: WHERE ctr.counter_id = cas.counter_id

Line 431: csi_counters_b ctr,

427: ctr.counter_id,
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'

Line 450: FROM CSI_COUNTERS_B cntrs,

446: p_user_id IN NUMBER)
447: IS
448: SELECT cval.counter_value_id,
449: cval.value_timestamp
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

Line 694: FROM CSI_COUNTERS_B cntrs,

690: p_user_id NUMBER)
691: IS
692: SELECT cval.value_timestamp,
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