APPS.EAM_METERREADING_VALIDATE_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 174

	/* SELECT  counter_id  bulk collect into counter_id_tbl
	  FROM 	csi_counter_associations cca
	 WHERE  source_object_id =     p_instance_id
	 and SYSDATE BETWEEN nvl(cca.start_date_active, SYSDATE-1)
	AND nvl(cca.end_date_active, SYSDATE+1);  */

Line: 180

  SELECT  cca.counter_id  bulk collect into counter_id_tbl                                     -- Bug 7323234
  FROM 	csi_counter_associations cca, csi_counters_b ccb
  WHERE  source_object_id =  p_instance_id
  AND SYSDATE BETWEEN nvl(cca.start_date_active, SYSDATE-1)
    and nvl(cca.end_date_active, SYSDATE+1)
  AND SYSDATE BETWEEN nvl(ccb.start_date_active, SYSDATE-1)
    and nvl(ccb.end_date_active, SYSDATE+1)
  AND cca.counter_id = ccb.counter_id;

Line: 218

			select count(*) into l_no_of_reading
			from CSI_COUNTER_READINGS
			 where counter_id = mandatory_counter_id_tbl(J)
			   and value_timestamp  = p_work_order_cmpl_date
			   and DISABLED_FLAG = 'N';   -- BUG 12536849

Line: 232

					SELECT SOURCE_COUNTER_ID INTO L_SOURCE_METER_ID FROM CSI_COUNTER_RELATIONSHIPS WHERE OBJECT_COUNTER_ID = MANDATORY_COUNTER_ID_TBL(J)
					AND SYSDATE BETWEEN NVL(ACTIVE_START_DATE(+), SYSDATE-1) AND  NVL(ACTIVE_END_DATE(+), SYSDATE+1);

Line: 246

						    SELECT SOURCE_COUNTER_ID INTO L_SOURCE_METER_ID_P FROM CSI_COUNTER_RELATIONSHIPS WHERE OBJECT_COUNTER_ID = P_EAM_METER_READING_TBL(K).METER_ID
						    AND SYSDATE BETWEEN NVL(ACTIVE_START_DATE(+), SYSDATE-1) AND  NVL(ACTIVE_END_DATE(+), SYSDATE+1);