Hello,
In order to make an alert for "Ending Probation Period" I have created a periodic Alert, this alert will check daily if there is any employee already near to 80 days from hire date to sysdate it will send an e-mail alert to us... using the below query in the alert .... the query is verified and can run but no e-mails received
anybody can help ....
Regards
SELECT distinct
employee_number,
full_name,
original_date_of_hire,
date_of_birth,
national_identifier
INTO
&employee_number,
&full_name,
&original_date_of_hire,
&date_of_birth,
&national_identifier
FROM PER_ALL_PEOPLE_F
where sysdate BETWEEN effective_start_date and effective_end_date
and sysdate - original_date_of_hire < 85
and sysdate - original_date_of_hire > 80
] 
Blog
Search
Help
Members
Register
Login
Home
