View: PER_ZA_TIME_PERIODS_V2

Product:	PER - Human Resources
Description:	Used in Tax Quarter Value Set
Implementation/DBA Data:	APPS.PER_ZA_TIME_PERIODS_V2

View Text

SELECT P2.PAYROLL_ID
, P2.START_DATE
, P2.END_DATE
, P1.PRD_INFORMATION2
FROM PER_TIME_PERIODS P1
, PER_TIME_PERIODS P2
WHERE P1.PAYROLL_ID = P2.PAYROLL_ID
AND P1.END_DATE = P2.START_DATE - 1 UNION SELECT P1.PAYROLL_ID
, P1.START_DATE
, P1.END_DATE
, P2.PRD_INFORMATION2
FROM PER_TIME_PERIODS P1
, PER_TIME_PERIODS P2
WHERE P1.PAYROLL_ID = P2.PAYROLL_ID
AND P2.START_DATE = P1.END_DATE + 1 UNION SELECT P1.PAYROLL_ID
, P1.START_DATE
, P1.END_DATE
, DECODE(P1.PRD_INFORMATION2
, '1'
, '4'
, '2'
, '1'
, '3'
, '2'
, '4'
, '3')
FROM PER_TIME_PERIODS P1
WHERE P1.START_DATE = ( SELECT MIN(START_DATE)
FROM PER_TIME_PERIODS P2
WHERE P2.PAYROLL_ID = P1.PAYROLL_ID ) UNION SELECT P1.PAYROLL_ID
, P1.START_DATE
, P1.END_DATE
, P1.PRD_INFORMATION2
FROM PER_TIME_PERIODS P1
WHERE P1.START_DATE = ( SELECT MIN(START_DATE)
FROM PER_TIME_PERIODS P2
WHERE P2.PAYROLL_ID = P1.PAYROLL_ID ) UNION SELECT P1.PAYROLL_ID
, P1.START_DATE
, P1.END_DATE
, DECODE(P1.PRD_INFORMATION2
, '1'
, '2'
, '2'
, '3'
, '3'
, '4'
, '4'
, '1')
FROM PER_TIME_PERIODS P1
WHERE P1.START_DATE = ( SELECT MAX(START_DATE)
FROM PER_TIME_PERIODS P2
WHERE P2.PAYROLL_ID = P1.PAYROLL_ID ) UNION SELECT P1.PAYROLL_ID
, P1.START_DATE
, P1.END_DATE
, P1.PRD_INFORMATION2
FROM PER_TIME_PERIODS P1
WHERE P1.START_DATE = ( SELECT MAX(START_DATE)
FROM PER_TIME_PERIODS P2
WHERE P2.PAYROLL_ID = P1.PAYROLL_ID )

Columns