Code snippet:

SELECT @PAY_FREQ = EC.EECPAYPERIOD

,@PAY_FREQ_DIVIDER = CASE EC.EECPAYPERIOD

WHEN 'W' THEN 52

WHEN 'S' THEN 24

WHEN 'B' THEN 26

WHEN 'M' THEN 12

ELSE 26

END

,@ANN_SALARY = EC.EECANNSALARY

,@FT_PT = EC.EECFULLTIMEORPARTTIME

,@REG_TMP = EC.EECEETYPE

,@SAL_HRLY = CASE

WHEN EC.EECSALARYORHOURLY = 'H' AND

((EC.EECUNIONLOCAL IS NULL OR EC.EECUNIONLOCAL = '') AND (EC.EECUNIONNATIONAL IS NULL OR EC.EECUNIONNATIONAL = ''))

THEN 'N'

WHEN EC.EECSALARYORHOURLY = 'H' AND

((EC.EECUNIONLOCAL IS NOT NULL AND EC.EECUNIONLOCAL <> '') OR (EC.EECUNIONNATIONAL IS NOT NULL AND EC.EECUNIONNATIONAL <> ''))

THEN 'U'

WHEN EC.EECSALARYORHOURLY = 'S'

THEN 'S'

WHEN EC.EECSALARYORHOURLY = 'A'

THEN 'A'

END

,@LOC_UNION = EC.EECUNIONLOCAL

,@NAT_UNION = EC.EECUNIONNATIONAL

FROM EMPCOMP EC WITH (NOLOCK)

WHERE EC.EECCOID = @COID

AND EC.EECEEID = @EEID

What is the value of this column, EC.EECPAYPERIOD, in EMPCOMP for the parameters @COID and @EEID passed to this function where the calculations are incorrect.