[Home] [Help]
View: PAY_SRS_YEAR_PERIODS_V
View Text
SELECT PPF.BUSINESS_GROUP_ID
, TO_CHAR(PTP.START_DATE
, 'YYYY')
, MIN(TRUNC(PTP.START_DATE
, 'Y'))
, ADD_MONTHS(MIN(TRUNC(PTP.START_DATE
, 'Y'))
, 12) -1
FROM PER_TIME_PERIODS PTP
, PAY_PAYROLLS_F PPF
WHERE PTP.PAYROLL_ID = PPF.PAYROLL_ID GROUP BY TO_CHAR(PTP.START_DATE
, 'YYYY')
, PPF.BUSINESS_GROUP_ID
Columns
Name |
BUSINESS_GROUP_ID |
YEAR_NAME |
YEAR_START_DATE |
YEAR_END_DATE |