Create Stored Procedure For Select record

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

ALTER proc [dbo].[Get_Ind_UsedCarLoan]
(@pApplicationId int)
as
begin
select  VehicleName,
 VehicleNumber,
 YearOfManufacture,
 ValuationAmount,
 LoanAmount,
 Insurance,
 Suraksha,
 Others,
 TotalLoanAmount,
 ProccesingFee,
 StampDuty,
 SurakshaDeduction ,
 InsuranceDeduction ,
 AdvanceEmi ,
 Rta ,
 Valuation ,
 OthersDeduction ,
 NetDirsuburcementAmount ,
 LoanAmountDetails ,
 Tenure ,
 EmiAmount ,
 Tenure1 ,
 RateOfInterest ,
 LoadingAmount ,
 ExistingHypothecatedTo,
 ExistingLoanOutstanding,Notepad from Individual_UsedCarLoan where ApplicationId=@pApplicationId
end