SELECT     GenPayEmployeeBudgetHour.*
FROM         GenPayEmployeeBudgetHour INNER JOIN
                      GenPayBudgetRegPeriod ON GenPayEmployeeBudgetHour.GenPayBudgetRegPeriodID = GenPayBudgetRegPeriod.GenPayBudgetRegPeriodID
WHERE     (GenPayEmployeeBudgetHour.EmployeeID IN
                          (SELECT     val
                            FROM          dbo.CustomSPLIT(@EmployeeIDs, ',') AS CustomSPLIT_1)) AND (GenPayBudgetRegPeriod.InputDate = @InputDate)
ORDER BY GenPayEmployeeBudgetHour.GenPayBudgetRegHeaderID
END