I've got a couple parameterized views that could be reused without the parameter (for reporting purposes). Is it better to create a separate view without the parameter, or is it possible to massage the parameter somehow?

Select * from customer where custid = ?vp_custid

There's another view where the parameter is from a second table, how would I do that?

Select * from customer inner join address on customer.addressid = address.addressid where address.country = ?vp_country