[Home] [Help]
View: PER_ZA_TIME_PERIODS_V
View Text
SELECT P2.PAYROLL_ID
, P2.START_DATE
, P2.END_DATE
, P1.PRD_INFORMATION1
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_INFORMATION1
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_INFORMATION1) - 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_INFORMATION1
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_INFORMATION1) + 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_INFORMATION1
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
Name |
PAYROLL_ID |
START_DATE |
END_DATE |
PRD_INFORMATION1 |