ALTER PROCEDURE [dbo].[PRPTPAEMPLOYEECVPA29]
(
	@EmployeeID VARCHAR(8)
	,@CompanyID VARCHAR(20)
)
AS

--DECLARE @EmployeeID VARCHAR(20) = '20030999'
--DECLARE @CompanyID VARCHAR(20) = ''

SELECT * FROM dbo.PHRPA0029
WHERE EmployeeID = @EmployeeID
ORDER BY Period DESC