Answer Happy

SELECT STATE , OU , INSURANCEFROM (SELECT DISTINCT TRIM(NVL(COALESCE(TO_CHAR(L.JOB_ID, 999999), WO.WO_ID), '--')) ID , DECODE(LENGTH(TRIM(COALESCE(TO_CHAR(L.JOB_ID, 999999), WO.WO_ID))), 6, NVL(JU.INSURANCE, '--'), 5, 'CO', '--') INSURANCE , COALESCE(J.NAME, WO.DESCR) JW_NAME , NVL(COALESCE(P.ST_CD, PK_JOB.F_MAINSTCD(L.JOB_ID)), '--') STATE , L.OU_ID OU -- || ' - ' -- || OU.NAME , SUM(L.REG_HRS + L.TH_HRS + L.DT_HRS) hrs -- ,l.reg_hrs, l.th_hrs, l.dt_hrs , L.D_WORK_DATE , L.CREATION_DATE FROM LO_SMY L LEFT OUTER JOIN WO_DISTR WOD ON L.WO_DISTR_NUM = WOD.WO_DISTR_NUM LEFT OUTER JOIN WORK_ORDER WO ON WOD.WO_SA_NUM = WO.WO_SA_NUM LEFT OUTER JOIN JOB J ON L.JOB_ID = J.JOB_ID LEFT OUTER JOIN JOB_UDF JU ON L.JOB_ID = JU.JOB_ID LEFT OUTER JOIN CUS_PLACE CP ON WO.CUS_ID = CP.CUS_ID AND WO.CUS_LOC_CD = CP.CUS_LOC_CD LEFT OUTER JOIN PLACE P ON CP.PLACE_GUID = P.PLACE_GUID LEFT OUTER JOIN ORGANIZATION_UNIT OU ON L.OU_ID = OU.OU_ID WHERE l.d_work_date < SYSDATE + 45 GROUP BY COALESCE(TO_CHAR(L.JOB_ID, 999999), WO.WO_ID) , COALESCE(P.ST_CD, PK_JOB.F_MAINSTCD(L.JOB_ID)) , L.OU_ID -- || ' - ' -- || OU.NAME , L.D_WORK_DATE , L.CREATION_DATE , DECODE(LENGTH(TRIM(COALESCE(TO_CHAR(L.JOB_ID, 999999), WO.WO_ID))), 6, NVL(JU.INSURANCE, '--'), 5, 'CO', '--') , COALESCE(J.NAME, WO.DESCR) ORDER BY L.D_WORK_DATE , L.CREATION_DATE)
GROUP BY STATE , OU , INSURANCEORDER BY OU , STATE , INSURANCE
I need to add these requirements listed below to the query shown above. What would that look like?
Process runs on Payroll Calendar Year.
Start of payroll month is previous Monday to first Sunday in a month.
End of payroll month is last Sunday in the month
Payroll year would be January payroll month start date (usually in December) and December payroll month end date.
Need all labor data values payroll year to date.