View: HR_CERIDIAN_500_SEL_PAYROLL_V

Product:	PER - Human Resources
Description:	Ceridian Source 500 payroll interface view
Implementation/DBA Data:	APPS.HR_CERIDIAN_500_SEL_PAYROLL_V

View Text

SELECT DECODE(PTP.NUMBER_PER_FISCAL_YEAR
, 52
, 'W'
, 24
, 'S'
, 26
, 'B'
, 12
, 'M'
, PTP.NUMBER_PER_FISCAL_YEAR)
, PPR.PAYROLL_ID
FROM PAY_PAYROLLS_X PPR
, PER_TIME_PERIOD_TYPES PTP
WHERE PPR.PERIOD_TYPE = PTP.PERIOD_TYPE

Columns