APPS.CSM_ITEM_INSTANCE_EVENT_PKG dependencies on CS_COUNTERS

Line 977: cs_counters cntrs

973: CURSOR l_counter_id_csr ( p_instance_id NUMBER, p_user_id NUMBER)
974: IS
975: SELECT counter_id
976: FROM cs_counter_groups cntr_grps,
977: cs_counters cntrs
978: WHERE cntr_grps.source_object_code='CP'
979: AND cntr_grps.source_object_id = p_instance_id
980: AND cntr_grps.counter_group_id = cntrs.counter_group_id
981: AND cntrs.TYPE = 'REGULAR'

Line 1103: cs_counters cntrs

1099: p_user_id number )
1100: IS
1101: SELECT counter_id
1102: FROM cs_counter_groups cntr_grps,
1103: cs_counters cntrs
1104: WHERE cntr_grps.source_object_code='CP'
1105: AND cntr_grps.source_object_id = p_instance_id
1106: AND cntr_grps.counter_group_id = cntrs.counter_group_id
1107: AND cntrs.TYPE = 'REGULAR';