Theta Correspondence, Periods and L-functions