how to copy data from one table to another using store proc?

Question

I have three table, In staging table there is raw data I want to transfer the data from staging table to active table. Active table has same column like staging just one extra that is staging ID.

In third table I have done mapping like there are 3 columns 

1st column has what i want to store in active table 

In 2nd column what raw values is in staging table.