APPS.EAM_METR_VALIDATOR dependencies on EAM_METERS

Line 382: FROM EAM_METERS

378: 'eam_meter_readings_interface mri',
379: 'METER_ID',
380: 'METER_NAME',
381: '(SELECT METER_ID
382: FROM EAM_METERS
383: WHERE METER_NAME = MRI.METER_NAME
384: AND MRI.READING_DATE BETWEEN
385: NVL(FROM_EFFECTIVE_DATE, MRI.READING_DATE-1)
386: AND NVL(TO_EFFECTIVE_DATE, MRI.READING_DATE+1))'

Line 396: FROM EAM_METERS

392: 'eam_meter_readings_interface mri',
393: 'METER_ID',
394: 'METER_NAME',
395: '(SELECT METER_NAME
396: FROM EAM_METERS
397: WHERE METER_ID = MRI.METER_ID
398: AND MRI.READING_DATE BETWEEN
399: NVL(FROM_EFFECTIVE_DATE, MRI.READING_DATE-1)
400: AND NVL(TO_EFFECTIVE_DATE, MRI.READING_DATE+1))'

Line 436: FROM EAM_METERS

432: p_current_rowid,
433: p_interface_id,
434: '(NOT EXISTS
435: (SELECT METER_ID
436: FROM EAM_METERS
437: WHERE METER_NAME = MRI.METER_NAME
438: AND MRI.READING_DATE BETWEEN
439: NVL(FROM_EFFECTIVE_DATE, MRI.READING_DATE-1)
440: AND NVL(TO_EFFECTIVE_DATE, MRI.READING_DATE+1)))',

Line 465: FROM EAM_METERS EM

461: p_interface_id,
462: '(MRI.READING_DATE > SYSDATE
463: OR NOT EXISTS
464: (SELECT 1
465: FROM EAM_METERS EM
466: WHERE EM.METER_ID = MRI.METER_ID
467: AND MRI.READING_DATE BETWEEN
468: NVL(EM.FROM_EFFECTIVE_DATE, MRI.READING_DATE-1)
469: AND NVL(EM.TO_EFFECTIVE_DATE, MRI.READING_DATE+1)))',

Line 605: eam_meters em

601: x_meter_type,
602: x_reading_date,
603: x_value_change_dir
604: from eam_meter_readings_interface mri,
605: eam_meters em
606: where mri.meter_id = em.meter_id
607: and mri.rowid = p_current_rowid;
608:
609:

Line 668: l_ltd := eam_meters_util.calculate_ltd(x_meter_id,

664: x_next_reading := null;
665: end if;
666:
667: -- dbms_output.put_line('here');
668: l_ltd := eam_meters_util.calculate_ltd(x_meter_id,
669: x_reading_date, x_reading_value, x_meter_type);
670: if ( x_pre_reading is not null ) then
671: -- dbms_output.put_line('here 1');
672: if(x_meter_type = 1) then

Line 776: eam_meters em

772: x_reset_flag,
773: x_meter_id,
774: x_value_change_dir
775: from eam_meter_readings_interface mri,
776: eam_meters em
777: where mri.meter_id = em.meter_id
778: and mri.rowid = p_current_rowid;
779:
780: begin