APPS.EAM_METERASSOC_PUB dependencies on CSI_COUNTER_ASSOCIATIONS

Line 245: (select * from csi_counter_associations

241:
242: select 'Y' into l_exists_primary_flag
243: from dual
244: where exists
245: (select * from csi_counter_associations
246: where source_object_id = l_maintenance_object_id
247: and (end_date_active is null or end_date_active > sysdate)
248: and nvl(primary_failure_flag, 'N') = 'Y');
249:

Line 288: from csi_counter_associations

284:
285: -- Code added to take care of Re-Associations
286: BEGIN
287: select 1 into l_exists
288: from csi_counter_associations
289: where counter_id = p_meter_id AND source_object_id =l_maintenance_object_id;
290: EXCEPTION
291: WHEN NO_DATA_FOUND THEN
292: l_exists := 0;

Line 307: FROM csi_counter_associations

303: if (l_exists = 1) then
304:
305: SELECT object_version_number, instance_association_id
306: INTO l_object_version_number, l_association_id
307: FROM csi_counter_associations
308: WHERE source_object_id=l_maintenance_object_id and counter_id=p_meter_id;
309:
310: l_counter_associations_tbl(1).instance_association_id := l_association_id;
311: l_counter_associations_tbl(1).object_version_number := l_object_version_number;

Line 646: FROM csi_counter_associations cca

642: ELSE
643:
644: SELECT cca.object_version_number
645: INTO l_object_version_number
646: FROM csi_counter_associations cca
647: WHERE cca.instance_association_id = p_association_id;
648:
649: IF (l_plog) THEN
650: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

Line 663: (select * from csi_counter_associations

659:
660: select 'Y' into l_exists_primary_flag
661: from dual
662: where exists
663: (select * from csi_counter_associations
664: where source_object_id = l_maint_object_id
665: and (end_date_active is null or end_date_active > sysdate)
666: and instance_association_id <> p_association_id
667: and nvl(primary_failure_flag, 'N') = 'Y');