If you think this is a Perl/DBI error, then please add the Perl code that produced the error, and not just the query. Was it concatted together? Did you use bind params? We can't tell.
The error as it stands, thinks it cant see/read a file called p.frm in your prod database, since that should be an alias for projectedvolume, I would guess that your query in the perl code is not what you think it is.