View: PER_ZA_TIME_PERIODS_V3

Product:	PER - Human Resources
Description:	Used in Calendar Year Value Set
Implementation/DBA Data:	APPS.PER_ZA_TIME_PERIODS_V3

View Text

SELECT P2.PAYROLL_ID
, P2.START_DATE
, P2.END_DATE
, P1.PRD_INFORMATION3
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_INFORMATION3
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
, TO_CHAR(TO_NUMBER(P1.PRD_INFORMATION3) - 1)
FROM PER_TIME_PERIODS P1
WHERE P1.START_DATE = ( SELECT MIN(P2.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_INFORMATION3
FROM PER_TIME_PERIODS P1
WHERE P1.START_DATE = ( SELECT MIN(P2.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
, TO_CHAR(TO_NUMBER(P1.PRD_INFORMATION3) + 1)
FROM PER_TIME_PERIODS P1
WHERE P1.START_DATE = ( SELECT MAX(P2.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_INFORMATION3
FROM PER_TIME_PERIODS P1
WHERE P1.START_DATE = ( SELECT MAX(P2.START_DATE)
FROM PER_TIME_PERIODS P2
WHERE P2.PAYROLL_ID = P1.PAYROLL_ID )

Columns