View submissions to SelectPay for an employee

SELECT TOP 100 PERCENT pD.[Informal Name],     pEPR.[Payroll Number],     pEPR.[Employee Payroll Request Number],     pEPR.[Audit Number],     pEPR.[Payroll Company],     pEPR.[Submitted Date],     pEPR.[Response Date],     pEPR.Error,     pEPR.Period,     pEPR.[Person Number],     pEPR.[Tax Year],     pEC.[Employee Change Number],     pEC.[Employee Change Request Number],     pEC.AddressLine1,     pEC.AddressLine2,     pEC.AddressLine3,     pEC.AddressLine4,     pEC.BankAccountName,     pEC.BankAccountNumber,     pEC.BankBranch,     pEC.BankReference,     pEC.BankName,     pEC.BankSortCode,     pEC.ContractDaysPerWeek,     pEC.ContractHoursPerWeek,     pEC.Country,     pEC.DateOfBirth,     pEC.DepartmentCode,     pEC.EmploymentStartDate,     pEC.Forename1,     pEC.Forename2,     pEC.Forename3,     pEC.Gender,     pEC.HolidayAccrualType,     pEC.HolidayDays,     pEC.HolidayEntitlementAnnual,     pEC.HolidayEntitlementCurrent,     pEC.HolidayEntitlementDays,     pEC.HolidayEntitlementTaken,     pEC.HolidayEntitlementPeriods,     pEC.JobTitle,     pEC.NILetter,     pEC.MaritalStatus,     pEC.NINumber,     pEC.PassportNumber,     pEC.PayFrequency,     pEC.PayMethod,     pEC.PostCode,     pEC.Surname,     pEC.TelephoneNumber,     pEC.Title,     pEC.LeavingDate,     pEC.TupeDate,     pEC.EmailAddress,     pEC.SspQualifyingDays FROM PAYROLLAUDIT.[EMPLOYEE PAYROLL REQUEST] pEPR INNER JOIN PAYROLLAUDIT.[EMPLOYEE CHANGE REQUEST] pECR ON pEPR.[Employee Payroll Request Number] = pECR.[EMPLOYEE PAYROLL REQUEST NUMBER] INNER JOIN PAYROLLAUDIT.[EMPLOYEE CHANGE] pEC ON pECR.[Employee Change Request Number] = pEC.[EMPLOYEE CHANGE REQUEST NUMBER] INNER JOIN PERSON.DETAILS pD ON pEPR.[Person Number] = pD.[PERSON NUMBER] WHERE pEPR.[Payroll Number] = 'CHANGEME' ORDER BY pEPR.[Employee Payroll Request Number] DESC