YES NO SQL PROCEDURE

CREATE PROC yesno1                         
(                           
 @uds_code       VARCHAR(255),                                                                             
 @screen_id      VARCHAR(255),                                                                                          
 @company_code     VARCHAR(10),                                                                                         
 @location_code      VARCHAR(16),                                                                                         
 @lang_id        INT,                                                                                         
 @mode           INT,                                                                                         
 @keyvalue      varchar(255), 
 @material_type varchar(20),
 @issue char(5),           
 @loan char(5),           
 @chargeable_issue char(5),           
 @foc char(5)                                          
)                           
AS
BEGIN 
IF (@mode!=2)                        
BEGIN 
IF EXISTS (SELECT * FROM isu_typ where @issue='Select') 
BEGIN         
SELECT '99999',                 
4,Select 
END
IF EXISTS (SELECT * FROM isu_typ where @issue='Yes') 
BEGIN         
SELECT '99999',                 
4,Yes 
END 
IF EXISTS (SELECT * FROM isu_typ where @issue='No') 
BEGIN         
SELECT '99999',                 
4,No 
END
END 

BEGIN 
IF EXISTS (SELECT * FROM isu_typ where @loan='Select') 
BEGIN         
SELECT '99999',                 
5,Select 
END
IF EXISTS (SELECT * FROM isu_typ where @loan='Yes') 
BEGIN         
SELECT '99999',                 
5,Yes 
END 
IF EXISTS (SELECT * FROM isu_typ where @loan='No') 
BEGIN         
SELECT '99999',                 
5,No 
END
END 

BEGIN 
IF EXISTS (SELECT * FROM isu_typ where @chargeable_issue='Select') 
BEGIN         
SELECT '99999',                 
6,Select 
END
IF EXISTS (SELECT * FROM isu_typ where @chargeable_issue='Yes') 
BEGIN         
SELECT '99999',                 
6,Yes 
END 
IF EXISTS (SELECT * FROM isu_typ where @chargeable_issue='No') 
BEGIN         
SELECT '99999',                 
6,No 
END
END 

BEGIN 
IF EXISTS (SELECT * FROM isu_typ where @foc='Select') 
BEGIN         
SELECT '99999',                 
7,Select 
END
IF EXISTS (SELECT * FROM isu_typ where @foc='Yes') 
BEGIN         
SELECT '99999',                 
7,Yes 
END 
IF EXISTS (SELECT * FROM isu_typ where @foc='No') 
BEGIN         
SELECT '99999',                 
7,No 
END
END
END