|
3
|
exec sp_executesql N'EXEC @RETURN_VALUE = [dbo].[TR_REQ_ADVANCE_PAYMENT_Search] @p_REQ_PAY_ID = @p0, @p_REQ_PAY_CODE = @p1, @p_REQ_DT = @p2, @p_BRANCH_ID = @p3, @p_DEP_ID = @p4, @p_REQ_REASON = @p5, @p_REQ_TYPE = @p6, @P_REQ_ENTRIES = @p7, @p_REQ_DESCRIPTION = @p8, @p_REF_ID = @p9, @p_RECEIVER_PO = @p10, @p_RECEIVER_DEBIT = @p11, @p_REQ_PAY_TYPE = @p12, @p_REQ_TYPE_CURRENCY = @p13, @p_REQ_AMT = @p14, @p_REQ_TEMP_AMT = @p15, @p_MAKER_ID = @p16, @p_CREATE_DT = @p17, @p_EDITOR_ID = @p18, @p_AUTH_STATUS = @p19, @p_CHECKER_ID = @p20, @p_APPROVE_DT = @p21, @p_CREATE_DT_KT = @p22, @p_MAKER_ID_KT = @p23, @p_AUTH_STATUS_KT = @p24, @p_CHECKER_ID_KT = @p25, @p_APPROVE_DT_KT = @p26, @p_CORE_NOTE = @p27, @p_BRANCH_CREATE = @p28, @p_NOTES = @p29, @p_RECORD_STATUS = @p30, @p_TRANSFER_MAKER = @p31, @p_TRANSFER_DT = @p32, @p_TRASFER_USER_RECIVE = @p33, @p_PROCESS = @p34, @p_PAY_PHASE = @p35, @p_XMP_TEMP = @p36, @p_TOP = @p37, @p_LEVEL = @p38, @p_FRMDATE = @p39, @p_TODATE = @p40, @p_BRANCH_LOGIN = @p41, @p_IS_UPDATE_KT = @p42, @p_IS_TRANSFER = @p43, @p_DVDM_ID = @p44, @p_USER_LOGIN = @p45, @p_RATE = @p46, @p_FUNCTION = @p47, @p_TYPE_SEARCH = @p48, @p_TEMP_PAY_STATUS = @p49',N'@p0 varchar(8000),@p1 varchar(8000),@p2 varchar(8000),@p3 varchar(8000),@p4 varchar(8000),@p5 nvarchar(4000),@p6 varchar(8000),@p7 nvarchar(4000),@p8 nvarchar(4000),@p9 varchar(8000),@p10 nvarchar(4000),@p11 nvarchar(4000),@p12 varchar(8000),@p13 nvarchar(4000),@p14 decimal(18,0),@p15 decimal(18,0),@p16 varchar(8000),@p17 varchar(8000),@p18 varchar(8000),@p19 varchar(8000),@p20 varchar(8000),@p21 varchar(8000),@p22 varchar(8000),@p23 varchar(8000),@p24 varchar(8000),@p25 varchar(8000),@p26 varchar(8000),@p27 nvarchar(4000),@p28 varchar(8000),@p29 varchar(8000),@p30 varchar(8000),@p31 nvarchar(4000),@p32 varchar(8000),@p33 varchar(8000),@p34 varchar(8000),@p35 varchar(8000),@p36 xml,@p37 int,@p38 varchar(8000),@p39 varchar(8000),@p40 varchar(8000),@p41 varchar(8000),@p42 varchar(8000),@p43 varchar(8000),@p44 varchar(8000),@p45 varchar(8000),@p46 decimal(18,0),@p47 varchar(8000),@p48 varchar(8000),@p49 varchar(8000),@RETURN_VALUE int output',@p0=NULL,@p1=NULL,@p2='',@p3='DV0001',@p4=NULL,@p5=NULL,@p6='',@p7=NULL,@p8=NULL,@p9=NULL,@p10=NULL,@p11=NULL,@p12=NULL,@p13=NULL,@p14=NULL,@p15=NULL,@p16=NULL,@p17='',@p18=NULL,@p19='U',@p20=NULL,@p21='',@p22='',@p23=NULL,@p24='',@p25=NULL,@p26='',@p27=NULL,@p28='DV0001',@p29=NULL,@p30=NULL,@p31=NULL,@p32='',@p33=NULL,@p34=NULL,@p35=NULL,@p36=NULL,@p37=100,@p38='ALL',@p39='08/12/2020',@p40='08/01/2021',@p41='DV0001',@p42='',@p43='',@p44=NULL,@p45='tunt',@p46=NULL,@p47='',@p48='HC',@p49='',@RETURN_VALUE=@p53 output
|