AWR Report Generation in Sql prompt for the given time frame

--run this in sqlplus.

set pagesize 0
set linesize 121
col instart_fmt noprint;
col inst_name format a12 heading 'Instance';
col db_name format a12 heading 'DB Name';
col snap_id format 99999990 heading 'Snap Id';
col snapdat format a18 heading 'Snap Started' just c;
col lvl format 99 heading 'Snap|Level';
set heading on;
break on inst_name on db_name on host on instart_fmt skip 1;
ttitle off;

spool C:\app\subramaniana\admin\LFINARUL\dpdump\awr.html

SELECT
   output 
FROM   
   TABLE
   (dbms_workload_repository.AWR_REPORT_HTML
      (
( SELECT dbid FROM v$database),
( SELECT inst_id FROM gv$instance ),
( select snap_id from DBA_HIST_SNAPSHOT 
  where begin_interval_time = ( select  max(begin_interval_time) from DBA_HIST_SNAPSHOT 
  where begin_interval_time<= to_timestamp('03-DEC-13 01.30.26.273' ,'DD-MON-RR HH24:MI:SS.FF') ) ),
( select snap_id from DBA_HIST_SNAPSHOT 
where end_interval_time = ( select  min(end_interval_time) from DBA_HIST_SNAPSHOT 
where end_interval_time >= to_timestamp('03-DEC-13 01.45.26.273' ,'DD-MON-RR HH24:MI:SS.FF')
and snap_id > (select snap_id from DBA_HIST_SNAPSHOT 
where begin_interval_time = ( select  max(begin_interval_time) from DBA_HIST_SNAPSHOT 
where begin_interval_time<= to_timestamp('03-DEC-13 01.30.26.273' ,'DD-MON-RR HH24:MI:SS.FF') )) ) ))
   );