ELECT ID,
Nature_Vehicle,
Loan_Terms,
Loan_Name,
Interest_Rate,
Interest_Type,
Period_Type,
Period_Value,
Processing_Fee,
Late_Repayment_Charges,
Penal_Interest,
Liability_Type,
Required_Liability_Amount,
Grace_Period,
Mode_Repayment,
Initial_Payment_Loan,
Type_Property,
From_Date,
LockIn_Period,
PrePayment_Interest,
Is_Active,Valid_From ,Valid_To
FROM Loan_Type WHERE Loan_Type = 1 AND GETDATE() BETWEEN Valid_From AND Valid_To
AND Valid_To IS NOT NULL