VIEW: APPS.PAY_SRS_QUARTER_PERIODS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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