APPS.CSI_COUNTER_READINGS_PVT dependencies on CSI_COUNTER_RELATIONSHIPS

Line 156: from CSI_COUNTER_RELATIONSHIPS

152: select '1'
153: into l_exists
154: from dual
155: where exists (select 'x'
156: from CSI_COUNTER_RELATIONSHIPS
157: where object_counter_id = p_counter_id
158: and relationship_type_code = l_rel_type);
159: l_return_value := TRUE;
160: Exception

Line 179: from CSI_COUNTER_RELATIONSHIPS

175: select '1'
176: into l_exists
177: from dual
178: where exists (select 'x'
179: from CSI_COUNTER_RELATIONSHIPS
180: where object_counter_id = p_counter_id
181: and relationship_type_code = l_rel_type
182: and nvl(active_end_date,(sysdate+1)) > sysdate);
183: l_return_value := TRUE;

Line 401: from CSI_COUNTER_RELATIONSHIPS ccr,

397: --
398: CURSOR OBJECT_CTR_CUR IS
399: select ccr.object_counter_id,nvl(ccr.factor,1) factor,
400: ccv.direction,ccv.reading_type, ccv.uom_code object_uom_code
401: from CSI_COUNTER_RELATIONSHIPS ccr,
402: CSI_COUNTERS_B ccv
403: where ccr.source_counter_id = p_ctr_rdg_rec.counter_id
404: and ccr.relationship_type_code =l_rel_type
405: and nvl(ccr.active_start_date,sysdate) <= p_ctr_rdg_rec.value_timestamp

Line 1393: from CSI_COUNTER_RELATIONSHIPS

1389: into l_rdg_lock_date
1390: from CSI_COUNTER_READING_LOCKS
1391: where counter_id = p_ctr_rdg_rec.counter_id
1392: OR counter_id in (select object_counter_id
1393: from CSI_COUNTER_RELATIONSHIPS
1394: where source_counter_id = p_ctr_rdg_rec.counter_id
1395: and nvl(active_end_date,(p_ctr_rdg_rec.value_timestamp+1)) > p_ctr_rdg_rec.value_timestamp);
1396: End;
1397: --

Line 1972: from CSI_COUNTER_RELATIONSHIPS ccr,

1968: --
1969: BEGIN
1970: select 'Y'
1971: into l_target_ctr_exist
1972: from CSI_COUNTER_RELATIONSHIPS ccr,
1973: CSI_COUNTERS_B ccv,
1974: CSI_COUNTERS_TL cct
1975: where ccr.source_counter_id = p_ctr_rdg_rec.counter_id
1976: and ccr.relationship_type_code = 'CONFIGURATION'

Line 2555: from csi_counter_relationships

2551: l_tmp_ctr_value_id NUMBER;
2552: --
2553: CURSOR OBJECT_CTR_CUR(p_src_ctr_id IN NUMBER) IS
2554: select distinct object_counter_id
2555: from csi_counter_relationships
2556: where source_counter_id = p_src_ctr_id
2557: and relationship_type_code = l_rel_type
2558: and nvl(active_end_date,(sysdate+1)) > sysdate;
2559: --

Line 2562: from csi_counter_relationships

2558: and nvl(active_end_date,(sysdate+1)) > sysdate;
2559: --
2560: CURSOR SOURCE_CTR_CUR(p_obj_ctr_id IN NUMBER) IS
2561: select source_counter_id,bind_variable_name
2562: from csi_counter_relationships
2563: where object_counter_id = p_obj_ctr_id
2564: and relationship_type_code = l_rel_type
2565: and nvl(active_end_date,(sysdate+1)) > sysdate;
2566: --

Line 3529: from CSI_COUNTER_RELATIONSHIPS ccr,

3525: CURSOR OBJECT_CTR_CUR IS
3526: select ccr.object_counter_id,nvl(ccr.factor,1) factor,
3527: ccv.direction,ccv.reading_type, ccv.uom_code object_uom_code,
3528: cct.name object_counter_name
3529: from CSI_COUNTER_RELATIONSHIPS ccr,
3530: CSI_COUNTERS_B ccv,
3531: CSI_COUNTERS_TL cct
3532: where ccr.source_counter_id = p_ctr_rdg_rec.counter_id
3533: and ccr.relationship_type_code = l_rel_type

Line 3546: CSI_COUNTER_RELATIONSHIPS ccr,

3542: crg.adjustment_reading,crg.counter_reading,nvl(ccr.factor,1) factor,
3543: ccv.direction,ccv.reading_type,crg.reset_mode,
3544: ccv.uom_code object_uom_code, cct.name object_counter_name
3545: from CSI_COUNTER_READINGS crg,
3546: CSI_COUNTER_RELATIONSHIPS ccr,
3547: CSI_COUNTERS_B ccv,
3548: CSI_COUNTERS_TL cct
3549: where crg.source_counter_value_id = p_ctr_rdg_rec.counter_value_id
3550: and ccr.object_counter_id = crg.counter_id

Line 4619: from CSI_COUNTER_RELATIONSHIPS

4615: into l_rdg_lock_date
4616: from CSI_COUNTER_READING_LOCKS
4617: where counter_id = l_curr_ctr_rdg_rec.counter_id
4618: OR counter_id in (select object_counter_id
4619: from CSI_COUNTER_RELATIONSHIPS
4620: where source_counter_id = l_curr_ctr_rdg_rec.counter_id
4621: and nvl(active_end_date,(l_curr_ctr_rdg_rec.value_timestamp+1)) > l_curr_ctr_rdg_rec.value_timestamp);
4622: End;
4623: --