554:
555: SELECT nvl(fnd_date.canonical_to_date(start_date),to_date('01/01/1950','MM/DD/RRRR')),
556: nvl(fnd_date.canonical_to_date(end_date), sysdate)
557: INTO min_hist_creation_date, max_hist_creation_date 558: FROM dual; 559: retcode := 0;
560:
561: --Commented this out for bug 3630281.
562: /*if order_number_from is not null then