450:
451: SELECT nvl(fnd_date.canonical_to_date(start_date),to_date('01/01/1950','MM/DD/RRRR')),
452: nvl(fnd_date.canonical_to_date(end_date), sysdate)
453: INTO min_hist_creation_date, max_hist_creation_date 454: FROM dual; 455: retcode := 0;
456:
457: --Commented this out for bug 3630281.
458: /*if order_number_from is not null then