[Home] [Help]
102: p_meter_reading_date => null);
103:
104: END LOOP;
105:
106: -- reverse the last service reading in eam_pm_last_service table.
107: update eam_pm_last_service
108: set
109: last_service_reading=prev_service_reading,
110: wip_entity_id=null,
103:
104: END LOOP;
105:
106: -- reverse the last service reading in eam_pm_last_service table.
107: update eam_pm_last_service
108: set
109: last_service_reading=prev_service_reading,
110: wip_entity_id=null,
111: last_update_date=sysdate,