Here is the plan.

PLAN JOIN (A10 INDEX (RDB$FOREIGN62),D2 INDEX (RDB$PRIMARY21),A9
INDEX (RDB$PRIMARY7,ALLCANCEL_PROCESS_DATE))

Please note, that the query seemed to run fine with only one date
parameter, but when the > and < or the between was used. The query
runs slowwwwww.....

Thank you,
Randy