APPS.CSI_COUNTER_READINGS_PVT dependencies on CSI_COUNTERS_TL

Line 1182: CSI_COUNTERS_TL cct

1178: ccv.direction,ccv.reading_type, ccv.uom_code object_uom_code,
1179: cct.name object_counter_name
1180: from CSI_COUNTER_RELATIONSHIPS ccr,
1181: CSI_COUNTERS_B ccv,
1182: CSI_COUNTERS_TL cct
1183: where ccr.source_counter_id = p_ctr_rdg_rec.counter_id
1184: and ccr.relationship_type_code = 'CONFIGURATION'
1185: and nvl(ccr.active_start_date,sysdate) <= p_ctr_rdg_rec.value_timestamp
1186: and nvl(ccr.active_end_date,(sysdate+1)) > p_ctr_rdg_rec.value_timestamp

Line 2335: CSI_COUNTERS_TL cct

2331: select 'Y'
2332: into l_target_ctr_exist
2333: from CSI_COUNTER_RELATIONSHIPS ccr,
2334: CSI_COUNTERS_B ccv,
2335: CSI_COUNTERS_TL cct
2336: where ccr.source_counter_id = p_ctr_rdg_rec.counter_id
2337: and ccr.relationship_type_code = 'CONFIGURATION'
2338: and nvl(ccr.active_start_date,sysdate) <= p_ctr_rdg_rec.value_timestamp
2339: and nvl(ccr.active_end_date,(sysdate+1)) > p_ctr_rdg_rec.value_timestamp

Line 4069: CSI_COUNTERS_TL cct

4065: ccv.direction,ccv.reading_type, ccv.uom_code object_uom_code,
4066: cct.name object_counter_name
4067: from CSI_COUNTER_RELATIONSHIPS ccr,
4068: CSI_COUNTERS_B ccv,
4069: CSI_COUNTERS_TL cct
4070: where ccr.source_counter_id = p_ctr_rdg_rec.counter_id
4071: and ccr.relationship_type_code = l_rel_type
4072: and nvl(ccr.active_start_date,sysdate) <= p_ctr_rdg_rec.value_timestamp
4073: and nvl(ccr.active_end_date,(sysdate+1)) > p_ctr_rdg_rec.value_timestamp

Line 4086: CSI_COUNTERS_TL cct

4082: ccv.uom_code object_uom_code, cct.name object_counter_name
4083: from CSI_COUNTER_READINGS crg,
4084: CSI_COUNTER_RELATIONSHIPS ccr,
4085: CSI_COUNTERS_B ccv,
4086: CSI_COUNTERS_TL cct
4087: where crg.source_counter_value_id = p_ctr_rdg_rec.counter_value_id
4088: and ccr.object_counter_id = crg.counter_id
4089: and ccr.source_counter_id = p_ctr_rdg_rec.counter_id
4090: and ccr.relationship_type_code = l_rel_type