As I said, this is something really stupid (no offense here) I did such mistakes the time.
You miss the last END for the stored procedure:
CREATE PROCEDURE bpsp_fillbuspass
AS
BEGIN
END
And there is no need to create temp table before SP :-)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.