sql stored procedure

ALTER PROCEDURE [dbo].[ADMN_USER_RIGHTS]
	-- Add the parameters for the stored procedure here
	 @P_Condition Varchar(750) ,@P_Mode  varchar(250),@P_Entryby int,  
 @P_USER_ID int,@P_Opp  varchar(50),@P_Page  varchar(50)
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;
 If @P_Mode='rights' 
    Begin
  
   /*/ select distinct NEWROW,edit,deletion,viewing,accessing
 from admn_screenrolerights
 inner join ADMN_SCREEN_PATH_SETTINGS on ADMN_SCREEN_PATH_SETTINGS.SCREEN_ID=admn_screenrolerights.SCREEN_ID
 where ROLE_ID = '||P_USER_ID||' and admn_screenrolerights.ACTIVE = ''Y'' and ADMN_SCREEN_PATH_SETTINGS.URLPATH='''||P_Page||'''
 and ADMN_SCREEN_PATH_SETTINGS.ACTIVE = ''Y''
 and ADMN_SCREENROLERIGHTS.'||P_Opp||'=1;*/    
    
   
  select distinct NEWROW,edit,deletion,viewing,accessing
 from admn_screenrolerights
 inner join ADMN_SCREEN_PATH_SETTINGS on ADMN_SCREEN_PATH_SETTINGS.SCREEN_ID=admn_screenrolerights.SCREEN_ID
 where ROLE_ID =@P_USER_ID and admn_screenrolerights.ACTIVE = 'Y' 
 --and upper(ADMN_SCREEN_PATH_SETTINGS.URLPATH)=upper('''||P_Page||''')
 and upper(ADMN_SCREEN_PATH_SETTINGS.URLPATH) like upper(@P_Page)
 and ADMN_SCREEN_PATH_SETTINGS.ACTIVE = 'Y'
 and ADMN_SCREENROLERIGHTS.@P_Opp = 1;
  
    End;
  
   
	
END
GO