1011:
1012: CURSOR l_counter_id_csr ( p_instance_id NUMBER, p_user_id NUMBER)
1013: IS
1014: SELECT cntrs.counter_id
1015: FROM CS_CSI_COUNTER_GROUPS cntr_grps,
1016: CSI_COUNTERS_B cntrs,
1017: CSI_COUNTER_ASSOCIATIONS cas
1018: WHERE cntrs.counter_id = cas.counter_id
1019: AND cas.source_object_code = 'CP'
1139: CURSOR l_counter_id_csr ( p_instance_id number,
1140: p_user_id number )
1141: IS
1142: SELECT cntrs.counter_id
1143: FROM CS_CSI_COUNTER_GROUPS cntr_grps,
1144: CSI_COUNTERS_B cntrs,
1145: CSI_COUNTER_ASSOCIATIONS cas
1146: WHERE cntrs.counter_id = cas.counter_id
1147: AND cas.source_object_code = 'CP'