How do you pass parmaters to a procedure being executed on a linked server... (@BEG_DT, @END_DT are the paramaters!!)
INSERT INTO #TEMP
I would look at
OK, so OPENROWSET has been disallowed by your DBA. Fair enough.
Here's a useful-looking discussion: How to pass a variable to a linked server query - MS Support site
If that doesn't work, then