DBA Data[Home] [Help]

APPS.EAM_METERREADING_VALIDATE_PVT dependencies on CSI_COUNTERS_B

Line 181: FROM csi_counter_associations cca, csi_counters_b ccb

177: and SYSDATE BETWEEN nvl(cca.start_date_active, SYSDATE-1)
178: AND nvl(cca.end_date_active, SYSDATE+1); */
179:
180: SELECT cca.counter_id bulk collect into counter_id_tbl -- Bug 7323234
181: FROM csi_counter_associations cca, csi_counters_b ccb
182: WHERE source_object_id = p_instance_id
183: AND SYSDATE BETWEEN nvl(cca.start_date_active, SYSDATE-1)
184: and nvl(cca.end_date_active, SYSDATE+1)
185: AND SYSDATE BETWEEN nvl(ccb.start_date_active, SYSDATE-1)