public Static HcmPositionId EmpPositionId(RecId _RecId) { HcmPosition HcmPosition; HcmPositionWorkerAssignment HcmPositionWorkerAssignment; select HcmPosition join HcmPositionWorkerAssignment where HcmPositionWorkerAssignment.Position==HcmPosition.RecId && HcmPositionWorkerAssignment.ValidTo>=DateTimeUtil::getSystemDateTime() && HcmPositionWorkerAssignment.Worker==_RecId ; return HcmPosition.PositionId; }