DBA Data[Home] [Help]

APPS.EAM_METERREADING_VALIDATE_PVT dependencies on CSI_COUNTER_ASSOCIATIONS

Line 175: FROM csi_counter_associations cca

171: */
172:
173:
174: /* SELECT counter_id bulk collect into counter_id_tbl
175: FROM csi_counter_associations cca
176: WHERE source_object_id = p_instance_id
177: and SYSDATE BETWEEN nvl(cca.start_date_active, SYSDATE-1)
178: AND nvl(cca.end_date_active, SYSDATE+1); */
179:

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)