[Home] [Help]
View: PAY_SRS_QUARTER_PERIODS_V
View Text
SELECT PPF.BUSINESS_GROUP_ID
, MIN(TRUNC(PTP.START_DATE
, 'Q'))
, ADD_MONTHS(MIN(TRUNC(PTP.START_DATE
, 'Q'))
, 3) -1
, 'QUARTER '||TO_CHAR(PTP.START_DATE
, 'Q')||' '||TO_CHAR(PTP.START_DATE
, 'YYYY')
, MIN(TRUNC(PTP.START_DATE
, 'Q'))
, 'XX'
FROM PER_TIME_PERIODS PTP
, PAY_PAYROLLS_F PPF
WHERE PTP.PAYROLL_ID = PPF.PAYROLL_ID GROUP BY 'QUARTER '||TO_CHAR(PTP.START_DATE
, 'Q')||' '||TO_CHAR(PTP.START_DATE
, 'YYYY')
, PPF.BUSINESS_GROUP_ID UNION ALL SELECT PPF.BUSINESS_GROUP_ID
, MIN(TRUNC(PTP.START_DATE
, 'Q'))
, ADD_MONTHS(MIN(TRUNC(PTP.START_DATE
, 'Q'))
, 3) -1
, 'QUARTER '||TO_CHAR(PTP.START_DATE
, 'Q')||' '||TO_CHAR(PTP.START_DATE
, 'YYYY')
, DECODE(TO_CHAR(MIN(TRUNC(PTP.START_DATE
, 'Q'))
, 'Q')
, 4
, TRUNC(MIN(TRUNC(PTP.START_DATE
, 'Q'))
, 'Y')
, MIN(TRUNC(PTP.START_DATE
, 'Q')))
, PUS.STATE_ABBREV
FROM PER_TIME_PERIODS PTP
, PAY_PAYROLLS_F PPF
, PAY_US_STATES PUS
WHERE PTP.PAYROLL_ID = PPF.PAYROLL_ID
AND PUS.STATE_ABBREV = 'NY' GROUP BY 'QUARTER '||TO_CHAR(PTP.START_DATE
, 'Q')||' '||TO_CHAR(PTP.START_DATE
, 'YYYY')
, PPF.BUSINESS_GROUP_ID
, PUS.STATE_ABBREV
Columns
Name |
BUSINESS_GROUP_ID |
QUARTER_START_DATE |
QUARTER_END_DATE |
QUARTER_NAME |
QUARTER_START_DATE_NYQ4 |
QUARTER_STATE_FLAG |