APPS.EAM_METERREADING_UTILITY_PVT dependencies on CSI_COUNTER_ASSOCIATIONS

Line 318: FROM CSI_COUNTER_ASSOCIATIONS cca

314: WHERE wip_entity_id = l_eam_wo_comp_rebuild_tbl(ii).wip_entity_id;
315:
316: SELECT cca.counter_id
317: BULK COLLECT INTO l_counter_tbl
318: FROM CSI_COUNTER_ASSOCIATIONS cca
319: WHERE cca.source_object_id = l_eam_wo_comp_rebuild_tbl(ii).instance_id_removed
320: AND (cca.end_date_active IS NULL OR cca.end_date_active > sysdate)
321: AND exists
322: (

Line 324: FROM CSI_COUNTER_ASSOCIATIONS ccas, CSI_COUNTER_RELATIONSHIPS ccr

320: AND (cca.end_date_active IS NULL OR cca.end_date_active > sysdate)
321: AND exists
322: (
323: SELECT '1'
324: FROM CSI_COUNTER_ASSOCIATIONS ccas, CSI_COUNTER_RELATIONSHIPS ccr
325: WHERE ccas.source_object_id = l_instance_id
326: AND (ccas.end_date_active IS NULL OR ccas.end_date_active > sysdate)
327: AND ccr.object_counter_id = cca.COUNTER_ID
328: AND ccr.source_counter_id = ccas.counter_id