Issue with Probation Period End Date Alerts
Summary:
Hi Everyone,
We have a requirement to create Probation period expiry alerts which will send an alert to Line Managers before Employee's Probation Period End Date.
This alert should trigger to Line Managers before 85 days , 20 Days and 10 Days to their Probation End Dates.
To achieve this requirement, we have taken resource as "Worker". and selected Match "Any" and added below conditions.
Ten
EXISTS(select 'X' from PER_ALL_ASSIGNMENTS_M paam,HR_LOCATIONS HL WHERE PAAM.LOCATION_ID = HL.LOCATION_ID AND SYSDATE BETWEEN PAAM.EFFECTIVE_START_DATE AND PAAM.EFFECTIVE_END_DATE AND paam.ASSIGNMENT_STATUS_TYPE = 'ACTIVE' AND TRUNC(paam.DATE_PROBATION_END) =TRUNC(SYSDATE+10) AND paam.ASSIGNMENT_TYPE = 'E' AND HL.COUNTRY = 'PH' AND paam.PERSON_ID = ${PersonId})