You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
16 lines
557 B
16 lines
557 B
ALTER PROCEDURE [dbo].[OSP_OTB_HR_CheckAskLeave_GetModel]
|
|
@OrganizationID VARCHAR(50) ,
|
|
@AskLeaveGuid CHAR(36)
|
|
AS
|
|
SELECT CheckUserID ,
|
|
dbo.OFN_SYS_MemberNameByMemberID(CheckUserID, @OrganizationID) AS CheckUserName ,
|
|
CheckGuid ,
|
|
ParentGuid ,
|
|
CheckStatue ,
|
|
Memo ,
|
|
'Upd' AS [Action] ,
|
|
AskLeaveGuid
|
|
FROM [OTB_HR_CheckAskLeave]
|
|
WHERE OrganizationID = @OrganizationID
|
|
AND AskLeaveGuid = @AskLeaveGuid
|
|
ORDER BY CreateDate DESC
|