Query to get the user list for which the task is getting failed based onm date

SELECT distinct USR.USR_LOGIN as UserLogin,OIU.ORC_KEY as ProcessInstKey,MIL.MIL_NAME,OBJ.OBJ_NAME,MIL.MIL_key as taskKey FROM OSI,SCH,STA,MIL,TOS,PKG,OIU,USR,OBJ,OST WHERE OSI.MIL_KEY=MIL.MIL_KEY AND SCH.SCH_KEY=OSI.SCH_KEY AND STA.STA_STATUS=SCH.SCH_STATUS AND TOS.PKG_KEY=PKG.PKG_KEY    AND MIL.TOS_KEY=TOS.TOS_KEY         AND OIU.USR_KEY=USR.USR_KEY      AND OIU.OST_KEY=OST.OST_KEY         AND OST.OBJ_KEY=OBJ.OBJ_KEY       AND OSI.ORC_KEY=OIU.ORC_KEY        AND OBJ.OBJ_NAME in (%RESOURCE_NAME%) AND OST.OST_STATUS in ('Provisioned','Enabled') AND STA.STA_BUCKET = 'Rejected' and STA.STA_BUCKET not in ('Completed') AND MIL_NAME in (%TASK_NAME%) AND trunc(OIU.OIU_UPDATE) = trunc(sysdate-%DATE_DIFF%)