DBA Data[Home] [Help]

APPS.EAM_METERREADING_VALIDATE_PVT dependencies on CSI_COUNTER_ASSOCIATIONS

Line 174: FROM csi_counter_associations cca

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

Line 180: FROM csi_counter_associations cca, csi_counters_b ccb

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