API tools faq
paste
Advertisement
psi_mmobile

Untitled

psi_mmobile
Apr 21st, 2023
1,383
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 221.51 KB | None | 0 0
raw download clone embed print report
  1. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('07/03/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('07/03/2024','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000001' AND person_status_id = 0);
  2. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('19/10/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('19/10/2023','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000395' AND person_status_id = 0);
  3. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('24/10/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('24/10/2024','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000713' AND person_status_id = 0);
  4. UPDATE person SET last_med_visit_medical_center = 'OMT Office de la Médecine du Travail - Monaco', last_med_visit_date =NULL, vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =NULL,last_med_visit_reason=NULL, last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001382' AND person_status_id = 0);
  5. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('25/02/2019','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('25/02/2021','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000730' AND person_status_id = 0);
  6. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('10/05/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('24/01/2024','DD/MM/YYYY'),last_med_visit_reason='DEMANDE MEDECIN DU TRAVAIL', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000773' AND person_status_id = 0);
  7. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('02/02/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('02/02/2024','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001110' AND person_status_id = 0);
  8. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('21/07/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('21/07/2023','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000723' AND person_status_id = 0);
  9. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('30/08/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('30/08/2023','DD/MM/YYYY'),last_med_visit_reason='DEMANDE MEDECIN DU TRAVAIL', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000779' AND person_status_id = 0);
  10. UPDATE person SET last_med_visit_medical_center = 'SMIBTP (60)', last_med_visit_date =TO_DATE('22/11/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('22/11/2024','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001407' AND person_status_id = 0);
  11. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('22/06/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('24/06/2024','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000658' AND person_status_id = 0);
  12. --update person set last_med_visit_medical_center = 'ACMS', last_med_visit_date =null, vo_medical_follow_up_type_id =(select vo_medical_follow_up_type_id from vo_medical_follow_up_type where vehicle_owner_id=101420 and short_code='SMR'), last_med_visit_exp =null,last_med_visit_reason=null, last_med_visit_status_id=100 where person_id=(select p.person_id from person p, vo_person_category vopc where p.vo_person_category_id = vopc.vo_person_category_id and vopc.vehicle_owner_id=101420 and p.company_nr='0001433' and person_status_id = 0);
  13. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('13/12/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMS'), last_med_visit_exp =TO_DATE('14/12/2026','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001302' AND person_status_id = 0);
  14. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('27/04/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('29/04/2024','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001339' AND person_status_id = 0);
  15. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('29/11/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('29/11/2023','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001248' AND person_status_id = 0);
  16. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('01/12/2020','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('01/12/2022','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000216' AND person_status_id = 0);
  17. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =NULL, vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =NULL,last_med_visit_reason=NULL, last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001428' AND person_status_id = 0);
  18. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('27/12/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('28/03/2022','DD/MM/YYYY'),last_med_visit_reason='DEMANDE MEDECIN DU TRAVAIL', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000757' AND person_status_id = 0);
  19. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('06/03/2023','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('06/06/2023','DD/MM/YYYY'),last_med_visit_reason='VISITE DE REPRISE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000614' AND person_status_id = 0);
  20. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('09/01/2023','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('09/01/2025','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000329' AND person_status_id = 0);
  21. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('28/02/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMS'), last_med_visit_exp =TO_DATE('03/02/2025','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001376' AND person_status_id = 0);
  22. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('27/01/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('27/01/2023','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000756' AND person_status_id = 0);
  23. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('20/07/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('22/07/2024','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001366' AND person_status_id = 0);
  24. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('26/09/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('26/09/2024','DD/MM/YYYY'),last_med_visit_reason='DEMANDE MEDECIN DU TRAVAIL', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000434' AND person_status_id = 0);
  25. UPDATE person SET last_med_visit_medical_center = 'APST BTP 06', last_med_visit_date =TO_DATE('19/12/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('02/12/2024','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000446' AND person_status_id = 0);
  26. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('05/05/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('05/05/2023','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000781' AND person_status_id = 0);
  27. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('03/05/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('16/05/2022','DD/MM/YYYY'),last_med_visit_reason='VISITE DE PRE-REPRISE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000811' AND person_status_id = 0);
  28. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('25/02/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('01/02/2024','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001411' AND person_status_id = 0);
  29. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('01/03/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('01/03/2024','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000731' AND person_status_id = 0);
  30. --update person set last_med_visit_medical_center = 'OMT Office de la Médecine du Travail - Monaco', last_med_visit_date =null, vo_medical_follow_up_type_id =(select vo_medical_follow_up_type_id from vo_medical_follow_up_type where vehicle_owner_id=101420 and short_code='SMR'), last_med_visit_exp =null,last_med_visit_reason=null, last_med_visit_status_id=100 where person_id=(select p.person_id from person p, vo_person_category vopc where p.vo_person_category_id = vopc.vo_person_category_id and vopc.vehicle_owner_id=101420 and p.company_nr='0001395' and person_status_id = 0);
  31. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('10/03/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMS'), last_med_visit_exp =TO_DATE('10/03/2025','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMS', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000029' AND person_status_id = 0);
  32. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('14/03/2023','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('14/03/2025','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000546' AND person_status_id = 0);
  33. UPDATE person SET last_med_visit_medical_center = 'OMT Office de la Médecine du Travail - Monaco', last_med_visit_date =TO_DATE('01/03/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('01/09/2022','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000701' AND person_status_id = 0);
  34. UPDATE person SET last_med_visit_medical_center = 'OMT Office de la Médecine du Travail - Monaco', last_med_visit_date =NULL, vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =NULL,last_med_visit_reason=NULL, last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001352' AND person_status_id = 0);
  35. UPDATE person SET last_med_visit_medical_center = 'OMT Office de la Médecine du Travail - Monaco', last_med_visit_date =NULL, vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =NULL,last_med_visit_reason=NULL, last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001401' AND person_status_id = 0);
  36. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('10/02/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('10/02/2023','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000732' AND person_status_id = 0);
  37. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('19/10/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('21/10/2024','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001332' AND person_status_id = 0);
  38. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =NULL, vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =NULL,last_med_visit_reason=NULL, last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001219' AND person_status_id = 0);
  39. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('25/01/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('25/01/2024','DD/MM/YYYY'),last_med_visit_reason='VISITE DE REPRISE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000032' AND person_status_id = 0);
  40. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('28/12/2020','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('28/12/2022','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000492' AND person_status_id = 0);
  41. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('04/02/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('05/02/2024','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000624' AND person_status_id = 0);
  42. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('19/01/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('19/01/2024','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001282' AND person_status_id = 0);
  43. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('10/02/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('12/02/2024','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001324' AND person_status_id = 0);
  44. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('23/11/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('23/11/2023','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000529' AND person_status_id = 0);
  45. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('10/11/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('10/11/2023','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000530' AND person_status_id = 0);
  46. --update person set last_med_visit_medical_center = 'ACMS', last_med_visit_date =to_date('25/10/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(select vo_medical_follow_up_type_id from vo_medical_follow_up_type where vehicle_owner_id=101420 and short_code='SMR'), last_med_visit_exp =to_date('25/10/2023','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 where person_id=(select p.person_id from person p, vo_person_category vopc where p.vo_person_category_id = vopc.vo_person_category_id and vopc.vehicle_owner_id=101420 and p.company_nr='UK' and person_status_id = 0);
  47. UPDATE person SET last_med_visit_medical_center = 'SMIBTP (60)', last_med_visit_date =TO_DATE('22/11/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('22/11/2024','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001405' AND person_status_id = 0);
  48. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('01/12/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('01/12/2023','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000733' AND person_status_id = 0);
  49. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('06/07/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('06/07/2023','DD/MM/YYYY'),last_med_visit_reason='DEMANDE MEDECIN DU TRAVAIL', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001061' AND person_status_id = 0);
  50. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('31/05/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('31/05/2024','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000656' AND person_status_id = 0);
  51. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('30/05/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('30/05/2024','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000601' AND person_status_id = 0);
  52. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('06/10/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMS'), last_med_visit_exp =TO_DATE('06/10/2026','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001297' AND person_status_id = 0);
  53. --update person set last_med_visit_medical_center = 'ACMS', last_med_visit_date =to_date('23/11/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(select vo_medical_follow_up_type_id from vo_medical_follow_up_type where vehicle_owner_id=101420 and short_code='SMR'), last_med_visit_exp =to_date('25/11/2024','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 where person_id=(select p.person_id from person p, vo_person_category vopc where p.vo_person_category_id = vopc.vo_person_category_id and vopc.vehicle_owner_id=101420 and p.company_nr='0001391' and person_status_id = 0);
  54. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('02/02/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMS'), last_med_visit_exp =TO_DATE('02/02/2024','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMS', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000431' AND person_status_id = 0);
  55. --update person set last_med_visit_medical_center = 'ACMS', last_med_visit_date =to_date('05/01/2023','DD/MM/YYYY'), vo_medical_follow_up_type_id =(select vo_medical_follow_up_type_id from vo_medical_follow_up_type where vehicle_owner_id=101420 and short_code='SMR'), last_med_visit_exp =to_date('06/01/2025','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 where person_id=(select p.person_id from person p, vo_person_category vopc where p.vo_person_category_id = vopc.vo_person_category_id and vopc.vehicle_owner_id=101420 and p.company_nr='0000693' and person_status_id = 0);
  56. --update person set last_med_visit_medical_center = 'ACMS', last_med_visit_date =to_date('09/10/2020','DD/MM/YYYY'), vo_medical_follow_up_type_id =(select vo_medical_follow_up_type_id from vo_medical_follow_up_type where vehicle_owner_id=101420 and short_code='SMS'), last_med_visit_exp =to_date('09/10/2025','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMS', last_med_visit_status_id=100 where person_id=(select p.person_id from person p, vo_person_category vopc where p.vo_person_category_id = vopc.vo_person_category_id and vopc.vehicle_owner_id=101420 and p.company_nr='0000373' and person_status_id = 0);
  57. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('05/09/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('05/05/2023','DD/MM/YYYY'),last_med_visit_reason='VISITE MI-CARRIERE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000613' AND person_status_id = 0);
  58. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('06/10/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('06/10/2023','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001260' AND person_status_id = 0);
  59. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('02/02/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMS'), last_med_visit_exp =TO_DATE('02/02/2027','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMS', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000387' AND person_status_id = 0);
  60. UPDATE person SET last_med_visit_medical_center = 'SMIBTP (60)', last_med_visit_date =TO_DATE('22/11/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('22/11/2024','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001409' AND person_status_id = 0);
  61. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('16/02/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('16/02/2024','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000788' AND person_status_id = 0);
  62. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('13/10/2020','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('13/01/2021','DD/MM/YYYY'),last_med_visit_reason='DEMANDE EMPLOYEUR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000277' AND person_status_id = 0);
  63. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('02/01/2023','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('02/01/2024','DD/MM/YYYY'),last_med_visit_reason='VISITE DE PRE-REPRISE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000753' AND person_status_id = 0);
  64. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('03/03/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('04/03/2024','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000024' AND person_status_id = 0);
  65. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('08/09/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('08/09/2023','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001041' AND person_status_id = 0);
  66. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('06/07/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('08/07/2024','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001069' AND person_status_id = 0);
  67. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('04/03/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('04/03/2024','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000400' AND person_status_id = 0);
  68. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('31/08/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('02/09/2024','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001079' AND person_status_id = 0);
  69. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('17/11/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('18/11/2024','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000822' AND person_status_id = 0);
  70. UPDATE person SET last_med_visit_medical_center = 'SMIBTP (60)', last_med_visit_date =TO_DATE('22/02/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('01/02/2024','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001427' AND person_status_id = 0);
  71. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('18/11/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('20/11/2023','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001225' AND person_status_id = 0);
  72. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('08/09/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('08/09/2023','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001111' AND person_status_id = 0);
  73. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('09/09/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('09/09/2027','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001381' AND person_status_id = 0);
  74. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('21/02/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('21/02/2024','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000764' AND person_status_id = 0);
  75. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('08/12/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('08/12/2023','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000775' AND person_status_id = 0);
  76. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('17/11/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('17/11/2023','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001299' AND person_status_id = 0);
  77. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('26/09/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMS'), last_med_visit_exp =TO_DATE('27/09/2027','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMS', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000390' AND person_status_id = 0);
  78. UPDATE person SET last_med_visit_medical_center = 'APST BTP 06', last_med_visit_date =TO_DATE('20/06/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('20/06/2024','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000685' AND person_status_id = 0);
  79. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('28/07/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('28/07/2023','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001045' AND person_status_id = 0);
  80. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('02/05/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('02/05/2024','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000577' AND person_status_id = 0);
  81. UPDATE person SET last_med_visit_medical_center = 'OMT Office de la Médecine du Travail - Monaco', last_med_visit_date =TO_DATE('24/03/2023','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('24/03/2025','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000660' AND person_status_id = 0);
  82. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('10/01/2023','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('10/01/2025','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001054' AND person_status_id = 0);
  83. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('10/05/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('10/05/2024','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000608' AND person_status_id = 0);
  84. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('30/03/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('01/04/2024','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000598' AND person_status_id = 0);
  85. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('20/12/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('20/12/2023','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001205' AND person_status_id = 0);
  86. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('04/10/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('04/10/2023','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001211' AND person_status_id = 0);
  87. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('22/06/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMS'), last_med_visit_exp =TO_DATE('05/06/2026','DD/MM/YYYY'),last_med_visit_reason='VISITE DE REPRISE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001254' AND person_status_id = 0);
  88. UPDATE person SET last_med_visit_medical_center = 'OMT Office de la Médecine du Travail - Monaco', last_med_visit_date =TO_DATE('28/10/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('28/10/2024','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000697' AND person_status_id = 0);
  89. --update person set last_med_visit_medical_center = 'ACMS', last_med_visit_date =to_date('13/09/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(select vo_medical_follow_up_type_id from vo_medical_follow_up_type where vehicle_owner_id=101420 and short_code='SMR'), last_med_visit_exp =to_date('13/09/2023','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 where person_id=(select p.person_id from person p, vo_person_category vopc where p.vo_person_category_id = vopc.vo_person_category_id and vopc.vehicle_owner_id=101420 and p.company_nr='UK' and person_status_id = 0);
  90. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('20/12/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMS'), last_med_visit_exp =TO_DATE('20/12/2027','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001417' AND person_status_id = 0);
  91. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('08/03/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('08/03/2024','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000022' AND person_status_id = 0);
  92. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('15/07/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('17/07/2023','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000702' AND person_status_id = 0);
  93. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('12/12/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('12/12/2024','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001102' AND person_status_id = 0);
  94. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('03/01/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('03/01/2024','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000440' AND person_status_id = 0);
  95. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('03/01/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('03/01/2024','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001312' AND person_status_id = 0);
  96. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('14/10/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('16/10/2023','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000312' AND person_status_id = 0);
  97. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('30/06/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('01/07/2024','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000023' AND person_status_id = 0);
  98. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('19/01/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('03/11/2025','DD/MM/YYYY'),last_med_visit_reason='DEMANDE MEDECIN DU TRAVAIL', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001085' AND person_status_id = 0);
  99. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('14/03/2023','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('14/04/2023','DD/MM/YYYY'),last_med_visit_reason='VISITE DE REPRISE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000455' AND person_status_id = 0);
  100. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('22/02/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('22/02/2024','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000279' AND person_status_id = 0);
  101. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('19/10/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('19/10/2023','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000734' AND person_status_id = 0);
  102. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('20/09/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('20/09/2023','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000269' AND person_status_id = 0);
  103. UPDATE person SET last_med_visit_medical_center = 'APST BTP 06', last_med_visit_date =TO_DATE('15/04/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('01/04/2024','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001394' AND person_status_id = 0);
  104. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('19/01/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('19/01/2024','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001077' AND person_status_id = 0);
  105. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('02/06/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('03/06/2024','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001056' AND person_status_id = 0);
  106. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('10/03/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('11/03/2024','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000004' AND person_status_id = 0);
  107. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('27/04/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMS'), last_med_visit_exp =TO_DATE('27/04/2026','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001063' AND person_status_id = 0);
  108. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('04/03/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('06/03/2023','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000037' AND person_status_id = 0);
  109. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('24/05/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('07/11/2023','DD/MM/YYYY'),last_med_visit_reason='VISITE DE REPRISE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001257' AND person_status_id = 0);
  110. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('04/07/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('04/07/2024','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001082' AND person_status_id = 0);
  111. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('10/05/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('10/05/2023','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001319' AND person_status_id = 0);
  112. UPDATE person SET last_med_visit_medical_center = 'OMT Office de la Médecine du Travail - Monaco', last_med_visit_date =NULL, vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =NULL,last_med_visit_reason=NULL, last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001418' AND person_status_id = 0);
  113. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('02/02/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMS'), last_med_visit_exp =TO_DATE('02/02/2027','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001328' AND person_status_id = 0);
  114. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('31/07/2020','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMS'), last_med_visit_exp =TO_DATE('31/07/2025','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001081' AND person_status_id = 0);
  115. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('24/05/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMS'), last_med_visit_exp =TO_DATE('24/05/2027','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000281' AND person_status_id = 0);
  116. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('08/02/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('08/02/2024','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000735' AND person_status_id = 0);
  117. UPDATE person SET last_med_visit_medical_center = 'OMT Office de la Médecine du Travail - Monaco', last_med_visit_date =TO_DATE('16/03/2023','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('17/03/2025','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001277' AND person_status_id = 0);
  118. UPDATE person SET last_med_visit_medical_center = 'OMT Office de la Médecine du Travail - Monaco', last_med_visit_date =TO_DATE('16/03/2023','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('16/03/2025','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001344' AND person_status_id = 0);
  119. UPDATE person SET last_med_visit_medical_center = 'APST BTP 06', last_med_visit_date =TO_DATE('05/11/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('01/05/2024','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001343' AND person_status_id = 0);
  120. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('15/06/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMS'), last_med_visit_exp =TO_DATE('15/06/2027','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001351' AND person_status_id = 0);
  121. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('10/03/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('11/03/2024','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000432' AND person_status_id = 0);
  122. UPDATE person SET last_med_visit_medical_center = 'OMT Office de la Médecine du Travail - Monaco', last_med_visit_date =NULL, vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =NULL,last_med_visit_reason=NULL, last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001402' AND person_status_id = 0);
  123. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('01/07/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('01/07/2023','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001373' AND person_status_id = 0);
  124. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('05/01/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('05/01/2023','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000493' AND person_status_id = 0);
  125. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('27/09/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMS'), last_med_visit_exp =TO_DATE('27/09/2024','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000490' AND person_status_id = 0);
  126. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('22/11/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('22/11/2023','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000596' AND person_status_id = 0);
  127. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('13/09/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('13/09/2023','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001280' AND person_status_id = 0);
  128. UPDATE person SET last_med_visit_medical_center = 'OMT Office de la Médecine du Travail - Monaco', last_med_visit_date =TO_DATE('25/09/2018','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('25/09/2021','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001367' AND person_status_id = 0);
  129. UPDATE person SET last_med_visit_medical_center = 'OMT Office de la Médecine du Travail - Monaco', last_med_visit_date =NULL, vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =NULL,last_med_visit_reason=NULL, last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001419' AND person_status_id = 0);
  130. --update person set last_med_visit_medical_center = 'ACMS', last_med_visit_date =to_date('03/10/2018','DD/MM/YYYY'), vo_medical_follow_up_type_id =(select vo_medical_follow_up_type_id from vo_medical_follow_up_type where vehicle_owner_id=101420 and short_code='SMR'), last_med_visit_exp =to_date('03/10/2023','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMS', last_med_visit_status_id=100 where person_id=(select p.person_id from person p, vo_person_category vopc where p.vo_person_category_id = vopc.vo_person_category_id and vopc.vehicle_owner_id=101420 and p.company_nr='UK' and person_status_id = 0);
  131. UPDATE person SET last_med_visit_medical_center = 'SMIBTP (60)', last_med_visit_date =TO_DATE('10/01/2023','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('10/01/2025','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001421' AND person_status_id = 0);
  132. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('25/10/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('25/10/2024','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001060' AND person_status_id = 0);
  133. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('02/12/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('16/06/2023','DD/MM/YYYY'),last_med_visit_reason='DEMANDE MEDECIN DU TRAVAIL', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000005' AND person_status_id = 0);
  134. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('15/06/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('17/06/2024','DD/MM/YYYY'),last_med_visit_reason='DEMANDE MEDECIN DU TRAVAIL', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000798' AND person_status_id = 0);
  135. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('28/10/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('30/10/2023','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000689' AND person_status_id = 0);
  136. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('21/03/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMS'), last_med_visit_exp =TO_DATE('22/03/2027','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMS', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000033' AND person_status_id = 0);
  137. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('23/03/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('25/03/2024','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000785' AND person_status_id = 0);
  138. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('28/06/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('28/06/2024','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001347' AND person_status_id = 0);
  139. UPDATE person SET last_med_visit_medical_center = 'APST BTP 06', last_med_visit_date =TO_DATE('26/09/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMS'), last_med_visit_exp =TO_DATE('01/09/2025','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001377' AND person_status_id = 0);
  140. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('19/12/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMS'), last_med_visit_exp =TO_DATE('20/12/2027','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001422' AND person_status_id = 0);
  141. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('13/12/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('13/07/2023','DD/MM/YYYY'),last_med_visit_reason='DEMANDE MEDECIN DU TRAVAIL', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000755' AND person_status_id = 0);
  142. UPDATE person SET last_med_visit_medical_center = 'OMT Office de la Médecine du Travail - Monaco', last_med_visit_date =TO_DATE('01/05/2018','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('01/05/2020','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001362' AND person_status_id = 0);
  143. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('29/07/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('31/07/2023','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001241' AND person_status_id = 0);
  144. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('04/01/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('04/01/2024','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001310' AND person_status_id = 0);
  145. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('22/03/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('22/03/2023','DD/MM/YYYY'),last_med_visit_reason='DEMANDE MEDECIN DU TRAVAIL', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000578' AND person_status_id = 0);
  146. UPDATE person SET last_med_visit_medical_center = 'OMT Office de la Médecine du Travail - Monaco', last_med_visit_date =TO_DATE('02/11/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('02/05/2022','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001363' AND person_status_id = 0);
  147. UPDATE person SET last_med_visit_medical_center = 'OMT Office de la Médecine du Travail - Monaco', last_med_visit_date =TO_DATE('01/05/2018','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('01/05/2020','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001383' AND person_status_id = 0);
  148. UPDATE person SET last_med_visit_medical_center = 'OMT Office de la Médecine du Travail - Monaco', last_med_visit_date =NULL, vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =NULL,last_med_visit_reason=NULL, last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001385' AND person_status_id = 0);
  149. UPDATE person SET last_med_visit_medical_center = 'OMT Office de la Médecine du Travail - Monaco', last_med_visit_date =NULL, vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =NULL,last_med_visit_reason=NULL, last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001392' AND person_status_id = 0);
  150. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('16/05/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('16/11/2022','DD/MM/YYYY'),last_med_visit_reason='DEMANDE MEDECIN DU TRAVAIL', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000303' AND person_status_id = 0);
  151. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('05/01/2023','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('06/01/2025','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000793' AND person_status_id = 0);
  152. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('15/04/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('17/04/2023','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000034' AND person_status_id = 0);
  153. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =NULL, vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =NULL,last_med_visit_reason=NULL, last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001425' AND person_status_id = 0);
  154. UPDATE person SET last_med_visit_medical_center = 'OMT Office de la Médecine du Travail - Monaco', last_med_visit_date =NULL, vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =NULL,last_med_visit_reason=NULL, last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001439' AND person_status_id = 0);
  155. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('01/08/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMS'), last_med_visit_exp =TO_DATE('02/08/2027','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001370' AND person_status_id = 0);
  156. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('22/04/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('24/04/2023','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000036' AND person_status_id = 0);
  157. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('27/05/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('29/05/2023','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000320' AND person_status_id = 0);
  158. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('16/04/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('17/04/2023','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000603' AND person_status_id = 0);
  159. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('22/02/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('22/02/2023','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000728' AND person_status_id = 0);
  160. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('05/01/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('05/01/2024','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001251' AND person_status_id = 0);
  161. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('28/09/2018','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('28/09/2023','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001246' AND person_status_id = 0);
  162. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('06/01/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('05/01/2024','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001331' AND person_status_id = 0);
  163. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('26/11/2013','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('01/11/2015','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000365' AND person_status_id = 0);
  164. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('10/01/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('10/01/2024','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001253' AND person_status_id = 0);
  165. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('18/02/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('20/02/2023','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000345' AND person_status_id = 0);
  166. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('17/06/2019','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('17/06/2021','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001066' AND person_status_id = 0);
  167. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('15/10/2020','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('17/10/2022','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000582' AND person_status_id = 0);
  168. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('17/06/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('19/06/2023','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001228' AND person_status_id = 0);
  169. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('10/01/2023','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('10/01/2025','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000592' AND person_status_id = 0);
  170. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('14/09/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('14/09/2023','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001283' AND person_status_id = 0);
  171. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('19/02/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('20/02/2023','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000366' AND person_status_id = 0);
  172. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('30/09/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('02/10/2023','DD/MM/YYYY'),last_med_visit_reason='VISITE DE REPRISE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000711' AND person_status_id = 0);
  173. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('21/07/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('21/07/2023','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001244' AND person_status_id = 0);
  174. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('12/09/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMS'), last_med_visit_exp =TO_DATE('12/02/2025','DD/MM/YYYY'),last_med_visit_reason='VISITE MI-CARRIERE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001029' AND person_status_id = 0);
  175. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('10/10/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('10/01/2023','DD/MM/YYYY'),last_med_visit_reason='VISITE DE REPRISE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000471' AND person_status_id = 0);
  176. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('14/12/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('14/12/2023','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001031' AND person_status_id = 0);
  177. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('12/05/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('12/05/2023','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000392' AND person_status_id = 0);
  178. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('27/10/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('27/10/2023','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001025' AND person_status_id = 0);
  179. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('20/05/2020','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMS'), last_med_visit_exp =TO_DATE('20/05/2025','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001058' AND person_status_id = 0);
  180. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('18/11/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('18/11/2024','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001410' AND person_status_id = 0);
  181. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('01/02/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('01/02/2024','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001275' AND person_status_id = 0);
  182. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('10/02/2023','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('10/02/2025','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001412' AND person_status_id = 0);
  183. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('10/02/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('12/02/2024','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001317' AND person_status_id = 0);
  184. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('20/04/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('20/04/2023','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001048' AND person_status_id = 0);
  185. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('16/11/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('16/11/2023','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000295' AND person_status_id = 0);
  186. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('05/10/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMS'), last_med_visit_exp =TO_DATE('07/10/2024','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001068' AND person_status_id = 0);
  187. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('21/02/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('21/02/2024','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001030' AND person_status_id = 0);
  188. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('01/09/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('01/09/2025','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000018' AND person_status_id = 0);
  189. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('16/04/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('17/04/2023','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000738' AND person_status_id = 0);
  190. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('21/02/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMS'), last_med_visit_exp =TO_DATE('22/02/2027','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001327' AND person_status_id = 0);
  191. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('20/07/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('20/07/2023','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000680' AND person_status_id = 0);
  192. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('28/09/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('28/09/2023','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000547' AND person_status_id = 0);
  193. UPDATE person SET last_med_visit_medical_center = 'APST BTP 06', last_med_visit_date =TO_DATE('20/06/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('20/06/2024','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000447' AND person_status_id = 0);
  194. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =NULL, vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =NULL,last_med_visit_reason=NULL, last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001424' AND person_status_id = 0);
  195. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('09/02/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('09/02/2024','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001330' AND person_status_id = 0);
  196. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('25/10/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('25/11/2022','DD/MM/YYYY'),last_med_visit_reason='VISITE DE REPRISE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000360' AND person_status_id = 0);
  197. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('18/11/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('18/11/2024','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001397' AND person_status_id = 0);
  198. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('01/08/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('01/08/2024','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001358' AND person_status_id = 0);
  199. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('05/09/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('06/03/2023','DD/MM/YYYY'),last_med_visit_reason='VISITE DE REPRISE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000691' AND person_status_id = 0);
  200. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('16/12/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('16/11/2023','DD/MM/YYYY'),last_med_visit_reason='DEMANDE MEDECIN DU TRAVAIL', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000007' AND person_status_id = 0);
  201. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('13/09/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('13/09/2023','DD/MM/YYYY'),last_med_visit_reason='DEMANDE MEDECIN DU TRAVAIL', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000335' AND person_status_id = 0);
  202. UPDATE person SET last_med_visit_medical_center = 'SMIBTP (60)', last_med_visit_date =NULL, vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =NULL,last_med_visit_reason=NULL, last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001437' AND person_status_id = 0);
  203. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('04/01/2023','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('06/01/2025','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000607' AND person_status_id = 0);
  204. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('18/02/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('19/02/2024','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000739' AND person_status_id = 0);
  205. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('28/09/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('30/09/2024','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001379' AND person_status_id = 0);
  206. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('08/11/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('08/11/2024','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000600' AND person_status_id = 0);
  207. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('10/05/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('10/11/2023','DD/MM/YYYY'),last_med_visit_reason='DEMANDE MEDECIN DU TRAVAIL', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000791' AND person_status_id = 0);
  208. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('12/01/2023','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('13/01/2025','DD/MM/YYYY'),last_med_visit_reason='DEMANDE MEDECIN DU TRAVAIL', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000595' AND person_status_id = 0);
  209. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('12/05/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('12/05/2023','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000810' AND person_status_id = 0);
  210. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('02/12/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('04/12/2023','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000709' AND person_status_id = 0);
  211. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('31/03/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('01/04/2024','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000572' AND person_status_id = 0);
  212. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('18/02/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('19/02/2024','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000433' AND person_status_id = 0);
  213. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('29/11/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('29/11/2023','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000035' AND person_status_id = 0);
  214. UPDATE person SET last_med_visit_medical_center = 'APST BTP 06', last_med_visit_date =TO_DATE('03/11/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('03/11/2023','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000799' AND person_status_id = 0);
  215. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('15/11/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMS'), last_med_visit_exp =TO_DATE('15/11/2027','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001388' AND person_status_id = 0);
  216. UPDATE person SET last_med_visit_medical_center = 'OMT Office de la Médecine du Travail - Monaco', last_med_visit_date =TO_DATE('01/05/2018','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('01/05/2020','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001393' AND person_status_id = 0);
  217. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('03/03/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('04/03/2024','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000008' AND person_status_id = 0);
  218. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('26/07/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('26/07/2023','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001231' AND person_status_id = 0);
  219. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('10/03/2023','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('11/09/2023','DD/MM/YYYY'),last_med_visit_reason='VISITE DE REPRISE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000554' AND person_status_id = 0);
  220. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('27/04/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('27/11/2023','DD/MM/YYYY'),last_med_visit_reason='DEMANDE MEDECIN DU TRAVAIL', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001049' AND person_status_id = 0);
  221. UPDATE person SET last_med_visit_medical_center = 'OMT Office de la Médecine du Travail - Monaco', last_med_visit_date =TO_DATE('22/10/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('22/10/2023','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001434' AND person_status_id = 0);
  222. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('14/03/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('14/03/2024','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001335' AND person_status_id = 0);
  223. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('29/07/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('31/07/2023','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000642' AND person_status_id = 0);
  224. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('05/09/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('05/01/2024','DD/MM/YYYY'),last_med_visit_reason='DEMANDE MEDECIN DU TRAVAIL', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001245' AND person_status_id = 0);
  225. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('01/09/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('01/09/2023','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001291' AND person_status_id = 0);
  226. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('15/04/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('17/04/2023','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000009' AND person_status_id = 0);
  227. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('10/05/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('10/11/2023','DD/MM/YYYY'),last_med_visit_reason='DEMANDE MEDECIN DU TRAVAIL', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000765' AND person_status_id = 0);
  228. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('30/11/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('30/11/2023','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000591' AND person_status_id = 0);
  229. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('22/04/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('24/04/2023','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001105' AND person_status_id = 0);
  230. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('23/11/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('23/11/2023','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000010' AND person_status_id = 0);
  231. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('27/07/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('27/07/2023','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001233' AND person_status_id = 0);
  232. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('29/11/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('29/11/2023','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000776' AND person_status_id = 0);
  233. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('16/09/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('16/09/2024','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001076' AND person_status_id = 0);
  234. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('06/12/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('06/12/2023','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000766' AND person_status_id = 0);
  235. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('16/12/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('18/12/2023','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000754' AND person_status_id = 0);
  236. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('26/10/2020','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('28/10/2024','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001104' AND person_status_id = 0);
  237. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('09/05/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('03/06/2022','DD/MM/YYYY'),last_med_visit_reason='VISITE DE PRE-REPRISE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000809' AND person_status_id = 0);
  238. UPDATE person SET last_med_visit_medical_center = 'SMIBTP (60)', last_med_visit_date =TO_DATE('09/03/2023','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('09/03/2025','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001430' AND person_status_id = 0);
  239. --update person set last_med_visit_medical_center = 'ACMS', last_med_visit_date =to_date('15/11/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(select vo_medical_follow_up_type_id from vo_medical_follow_up_type where vehicle_owner_id=101420 and short_code='SMS'), last_med_visit_exp =to_date('15/11/2027','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 where person_id=(select p.person_id from person p, vo_person_category vopc where p.vo_person_category_id = vopc.vo_person_category_id and vopc.vehicle_owner_id=101420 and p.company_nr='0001398' and person_status_id = 0);
  240. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('16/05/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMS'), last_med_visit_exp =TO_DATE('01/05/2024','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001378' AND person_status_id = 0);
  241. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('29/07/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('31/07/2023','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001235' AND person_status_id = 0);
  242. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('24/10/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('24/10/2024','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000597' AND person_status_id = 0);
  243. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('15/02/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('15/02/2024','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000570' AND person_status_id = 0);
  244. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('06/12/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('06/12/2024','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001413' AND person_status_id = 0);
  245. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('17/01/2023','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('17/01/2025','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001028' AND person_status_id = 0);
  246. UPDATE person SET last_med_visit_medical_center = 'SMIBTP (60)', last_med_visit_date =TO_DATE('10/01/2023','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('10/01/2025','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001414' AND person_status_id = 0);
  247. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('10/01/2023','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('26/06/2023','DD/MM/YYYY'),last_med_visit_reason='DEMANDE MEDECIN DU TRAVAIL', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000752' AND person_status_id = 0);
  248. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('19/07/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMS'), last_med_visit_exp =TO_DATE('20/07/2026','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001274' AND person_status_id = 0);
  249. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('16/03/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('18/03/2024','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000762' AND person_status_id = 0);
  250. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('10/02/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('10/02/2024','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001323' AND person_status_id = 0);
  251. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('01/03/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('01/03/2024','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000300' AND person_status_id = 0);
  252. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('15/04/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('17/04/2023','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000025' AND person_status_id = 0);
  253. UPDATE person SET last_med_visit_medical_center = 'APST BTP 06', last_med_visit_date =TO_DATE('27/02/2023','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('27/02/2025','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001355' AND person_status_id = 0);
  254. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('20/05/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMS'), last_med_visit_exp =TO_DATE('19/05/2027','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001371' AND person_status_id = 0);
  255. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('12/01/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('12/01/2024','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001313' AND person_status_id = 0);
  256. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('13/10/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMS'), last_med_visit_exp =TO_DATE('13/10/2026','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMS', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000814' AND person_status_id = 0);
  257. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('03/12/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('04/12/2023','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001015' AND person_status_id = 0);
  258. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('02/02/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('02/02/2024','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000401' AND person_status_id = 0);
  259. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('15/04/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('17/04/2023','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000011' AND person_status_id = 0);
  260. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('16/05/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('16/05/2024','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000706' AND person_status_id = 0);
  261. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('05/09/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('05/09/2024','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000368' AND person_status_id = 0);
  262. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('19/06/2017','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('01/06/2019','DD/MM/YYYY'),last_med_visit_reason='DEMANDE SALARIE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000325' AND person_status_id = 0);
  263. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('19/07/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('19/09/2022','DD/MM/YYYY'),last_med_visit_reason='DEMANDE SALARIE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000326' AND person_status_id = 0);
  264. UPDATE person SET last_med_visit_medical_center = 'OMT Office de la Médecine du Travail - Monaco', last_med_visit_date =TO_DATE('13/03/2023','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('13/03/2025','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001390' AND person_status_id = 0);
  265. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('16/12/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMS'), last_med_visit_exp =TO_DATE('16/12/2026','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001033' AND person_status_id = 0);
  266. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('13/10/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMS'), last_med_visit_exp =TO_DATE('14/10/2024','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000823' AND person_status_id = 0);
  267. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('09/08/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('28/02/2023','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001387' AND person_status_id = 0);
  268. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('19/11/2020','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMS'), last_med_visit_exp =TO_DATE('19/11/2025','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMS', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000448' AND person_status_id = 0);
  269. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('08/10/2019','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMS'), last_med_visit_exp =TO_DATE('08/10/2024','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000821' AND person_status_id = 0);
  270. UPDATE person SET last_med_visit_medical_center = 'OMT Office de la Médecine du Travail - Monaco', last_med_visit_date =TO_DATE('13/12/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('13/12/2023','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000824' AND person_status_id = 0);
  271. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('02/06/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('02/06/2023','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000563' AND person_status_id = 0);
  272. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('10/03/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('11/03/2024','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001333' AND person_status_id = 0);
  273. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =NULL, vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =NULL,last_med_visit_reason=NULL, last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001296' AND person_status_id = 0);
  274. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('31/01/2023','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('31/07/2023','DD/MM/YYYY'),last_med_visit_reason='VISITE DE REPRISE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001046' AND person_status_id = 0);
  275. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('13/09/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('13/09/2024','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000692' AND person_status_id = 0);
  276. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('28/03/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('28/03/2024','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000369' AND person_status_id = 0);
  277. UPDATE person SET last_med_visit_medical_center = 'OMT Office de la Médecine du Travail - Monaco', last_med_visit_date =TO_DATE('04/10/2018','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('01/10/2023','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000659' AND person_status_id = 0);
  278. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('09/06/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('10/06/2024','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001350' AND person_status_id = 0);
  279. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('21/03/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('23/10/2023','DD/MM/YYYY'),last_med_visit_reason='VISITE DE REPRISE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001087' AND person_status_id = 0);
  280. UPDATE person SET last_med_visit_medical_center = NULL, last_med_visit_date =NULL, vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code=''), last_med_visit_exp =NULL,last_med_visit_reason=NULL, last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001372' AND person_status_id = 0);
  281. UPDATE person SET last_med_visit_medical_center = NULL, last_med_visit_date =NULL, vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code=''), last_med_visit_exp =NULL,last_med_visit_reason=NULL, last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001024' AND person_status_id = 0);
  282. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('01/12/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('01/12/2023','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000812' AND person_status_id = 0);
  283. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('17/09/2020','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMS'), last_med_visit_exp =TO_DATE('17/09/2025','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001293' AND person_status_id = 0);
  284. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('11/10/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('11/10/2023','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000759' AND person_status_id = 0);
  285. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('15/09/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('16/09/2024','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000327' AND person_status_id = 0);
  286. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('16/05/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('30/05/2025','DD/MM/YYYY'),last_med_visit_reason='DEMANDE MEDECIN DU TRAVAIL', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000571' AND person_status_id = 0);
  287. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('09/02/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('09/02/2024','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001326' AND person_status_id = 0);
  288. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('16/05/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('16/05/2024','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000362' AND person_status_id = 0);
  289. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('25/02/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('26/02/2024','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000344' AND person_status_id = 0);
  290. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('30/08/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('30/08/2023','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001026' AND person_status_id = 0);
  291. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('07/12/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMS'), last_med_visit_exp =TO_DATE('07/12/2026','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001314' AND person_status_id = 0);
  292. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('22/11/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('22/11/2024','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001396' AND person_status_id = 0);
  293. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('02/11/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('04/11/2024','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001403' AND person_status_id = 0);
  294. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('04/11/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('06/11/2023','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001055' AND person_status_id = 0);
  295. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('24/01/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('24/01/2024','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001318' AND person_status_id = 0);
  296. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('02/12/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('04/12/2023','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000012' AND person_status_id = 0);
  297. UPDATE person SET last_med_visit_medical_center = 'OMT Office de la Médecine du Travail - Monaco', last_med_visit_date =TO_DATE('13/03/2023','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('13/03/2025','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001384' AND person_status_id = 0);
  298. UPDATE person SET last_med_visit_medical_center = 'OMT Office de la Médecine du Travail - Monaco', last_med_visit_date =TO_DATE('01/05/2018','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('01/05/2020','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001364' AND person_status_id = 0);
  299. --update person set last_med_visit_medical_center = 'ACMS', last_med_visit_date =to_date('18/10/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(select vo_medical_follow_up_type_id from vo_medical_follow_up_type where vehicle_owner_id=101420 and short_code='SMS'), last_med_visit_exp =to_date('18/10/2027','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMS', last_med_visit_status_id=100 where person_id=(select p.person_id from person p, vo_person_category vopc where p.vo_person_category_id = vopc.vo_person_category_id and vopc.vehicle_owner_id=101420 and p.company_nr='0001084' and person_status_id = 0);
  300. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('30/05/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('30/05/2024','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000307' AND person_status_id = 0);
  301. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('20/12/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('20/12/2024','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000690' AND person_status_id = 0);
  302. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('01/02/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('01/02/2023','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000438' AND person_status_id = 0);
  303. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('18/10/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('18/10/2024','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001348' AND person_status_id = 0);
  304. --update person set last_med_visit_medical_center = 'ACMS', last_med_visit_date =to_date('06/10/2020','DD/MM/YYYY'), vo_medical_follow_up_type_id =(select vo_medical_follow_up_type_id from vo_medical_follow_up_type where vehicle_owner_id=101420 and short_code='SMS'), last_med_visit_exp =to_date('06/10/2025','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 where person_id=(select p.person_id from person p, vo_person_category vopc where p.vo_person_category_id = vopc.vo_person_category_id and vopc.vehicle_owner_id=101420 and p.company_nr='0001093' and person_status_id = 0);
  305. UPDATE person SET last_med_visit_medical_center = 'OMT Office de la Médecine du Travail - Monaco', last_med_visit_date =TO_DATE('13/03/2023','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('13/03/2025','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001279' AND person_status_id = 0);
  306. UPDATE person SET last_med_visit_medical_center = 'OMT Office de la Médecine du Travail - Monaco', last_med_visit_date =NULL, vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =NULL,last_med_visit_reason=NULL, last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001356' AND person_status_id = 0);
  307. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('07/09/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('07/09/2023','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001308' AND person_status_id = 0);
  308. --update person set last_med_visit_medical_center = 'OMT Office de la Médecine du Travail - Monaco', last_med_visit_date =null, vo_medical_follow_up_type_id =(select vo_medical_follow_up_type_id from vo_medical_follow_up_type where vehicle_owner_id=101420 and short_code='SMR'), last_med_visit_exp =null,last_med_visit_reason=null, last_med_visit_status_id=100 where person_id=(select p.person_id from person p, vo_person_category vopc where p.vo_person_category_id = vopc.vo_person_category_id and vopc.vehicle_owner_id=101420 and p.company_nr='0001416' and person_status_id = 0);
  309. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('04/03/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('06/03/2023','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000308' AND person_status_id = 0);
  310. UPDATE person SET last_med_visit_medical_center = 'SMIBTP (60)', last_med_visit_date =TO_DATE('10/01/2023','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMS'), last_med_visit_exp =TO_DATE('10/01/2025','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001408' AND person_status_id = 0);
  311. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('27/07/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('29/07/2024','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001059' AND person_status_id = 0);
  312. UPDATE person SET last_med_visit_medical_center = 'OMT Office de la Médecine du Travail - Monaco', last_med_visit_date =TO_DATE('19/10/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('18/10/2024','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001389' AND person_status_id = 0);
  313. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('24/10/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('24/10/2024','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001098' AND person_status_id = 0);
  314. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('27/04/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMS'), last_med_visit_exp =TO_DATE('27/04/2026','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001223' AND person_status_id = 0);
  315. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('24/01/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('24/01/2024','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001325' AND person_status_id = 0);
  316. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('14/02/2023','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('14/02/2025','DD/MM/YYYY'),last_med_visit_reason='VISITE DE REPRISE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000254' AND person_status_id = 0);
  317. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('29/11/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('29/11/2023','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000783' AND person_status_id = 0);
  318. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('30/03/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('30/03/2023','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001051' AND person_status_id = 0);
  319. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('09/12/2020','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMS'), last_med_visit_exp =TO_DATE('09/12/2025','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMS', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000430' AND person_status_id = 0);
  320. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('08/06/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('10/06/2024','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001349' AND person_status_id = 0);
  321. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('04/03/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMS'), last_med_visit_exp =TO_DATE('04/03/2025','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMS', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000028' AND person_status_id = 0);
  322. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('26/10/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('28/10/2024','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000606' AND person_status_id = 0);
  323. UPDATE person SET last_med_visit_medical_center = 'APST BTP 06', last_med_visit_date =TO_DATE('16/10/2018','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('01/10/2023','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000542' AND person_status_id = 0);
  324. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('03/02/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('05/02/2024','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000778' AND person_status_id = 0);
  325. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('02/12/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('04/12/2023','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000816' AND person_status_id = 0);
  326. UPDATE person SET last_med_visit_medical_center = 'SMIBTP (60)', last_med_visit_date =TO_DATE('27/07/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('27/01/2023','DD/MM/YYYY'),last_med_visit_reason='DEMANDE MEDECIN DU TRAVAIL', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001044' AND person_status_id = 0);
  327. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('28/04/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('29/04/2024','DD/MM/YYYY'),last_med_visit_reason='DEMANDE MEDECIN DU TRAVAIL', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000474' AND person_status_id = 0);
  328. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('05/08/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('07/08/2023','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001273' AND person_status_id = 0);
  329. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('29/03/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('29/03/2024','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000808' AND person_status_id = 0);
  330. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('09/12/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('11/12/2023','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000746' AND person_status_id = 0);
  331. UPDATE person SET last_med_visit_medical_center = 'OMT Office de la Médecine du Travail - Monaco', last_med_visit_date =NULL, vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =NULL,last_med_visit_reason=NULL, last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001386' AND person_status_id = 0);
  332. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('20/10/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('20/09/2023','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001240' AND person_status_id = 0);
  333. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('19/10/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('21/10/2024','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000696' AND person_status_id = 0);
  334. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('14/05/2019','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('02/05/2023','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000710' AND person_status_id = 0);
  335. UPDATE person SET last_med_visit_medical_center = 'SMIBTP (60)', last_med_visit_date =TO_DATE('09/06/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('09/06/2023','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001404' AND person_status_id = 0);
  336. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('06/12/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('06/12/2023','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000014' AND person_status_id = 0);
  337. UPDATE person SET last_med_visit_medical_center = 'APST BTP 06', last_med_visit_date =TO_DATE('05/05/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('05/05/2023','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001239' AND person_status_id = 0);
  338. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('09/06/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('10/06/2024','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000802' AND person_status_id = 0);
  339. UPDATE person SET last_med_visit_medical_center = 'OMT Office de la Médecine du Travail - Monaco', last_med_visit_date =NULL, vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =NULL,last_med_visit_reason=NULL, last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001365' AND person_status_id = 0);
  340. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('19/05/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('20/05/2024','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000758' AND person_status_id = 0);
  341. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('17/01/2023','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMS'), last_med_visit_exp =TO_DATE('17/01/2028','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMS', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000718' AND person_status_id = 0);
  342. UPDATE person SET last_med_visit_medical_center = NULL, last_med_visit_date =NULL, vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code=''), last_med_visit_exp =NULL,last_med_visit_reason=NULL, last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001003' AND person_status_id = 0);
  343. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('17/01/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('17/01/2024','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001043' AND person_status_id = 0);
  344. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('04/10/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('04/10/2023','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000747' AND person_status_id = 0);
  345. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('02/02/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('02/02/2024','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001309' AND person_status_id = 0);
  346. UPDATE person SET last_med_visit_medical_center = 'OMT Office de la Médecine du Travail - Monaco', last_med_visit_date =TO_DATE('13/03/2023','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('13/03/2025','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001040' AND person_status_id = 0);
  347. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('08/02/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('08/02/2024','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001321' AND person_status_id = 0);
  348. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('16/12/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('18/12/2023','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000715' AND person_status_id = 0);
  349. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('24/05/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('24/05/2024','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000726' AND person_status_id = 0);
  350. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('20/06/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('20/06/2024','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001078' AND person_status_id = 0);
  351. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('28/12/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('28/12/2023','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001249' AND person_status_id = 0);
  352. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('15/06/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('17/06/2024','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000748' AND person_status_id = 0);
  353. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('10/10/2019','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMS'), last_med_visit_exp =TO_DATE('10/10/2024','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000827' AND person_status_id = 0);
  354. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =NULL, vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =NULL,last_med_visit_reason=NULL, last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001440' AND person_status_id = 0);
  355. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('16/11/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('16/11/2023','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000646' AND person_status_id = 0);
  356. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('14/10/2019','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('14/10/2024','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001242' AND person_status_id = 0);
  357. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('16/09/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('16/09/2023','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000749' AND person_status_id = 0);
  358. UPDATE person SET last_med_visit_medical_center = 'APST BTP 06', last_med_visit_date =TO_DATE('15/12/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('02/12/2024','DD/MM/YYYY'),last_med_visit_reason='DEMANDE EMPLOYEUR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000444' AND person_status_id = 0);
  359. UPDATE person SET last_med_visit_medical_center = 'OMT Office de la Médecine du Travail - Monaco', last_med_visit_date =TO_DATE('13/03/2023','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('13/03/2025','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000581' AND person_status_id = 0);
  360. UPDATE person SET last_med_visit_medical_center = 'APST BTP 06', last_med_visit_date =TO_DATE('20/04/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('01/04/2023','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001250' AND person_status_id = 0);
  361. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('20/01/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('22/02/2024','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001042' AND person_status_id = 0);
  362. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('12/01/2023','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('13/01/2025','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000016' AND person_status_id = 0);
  363. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('09/11/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('09/11/2023','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000435' AND person_status_id = 0);
  364. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('21/03/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('21/03/2024','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000681' AND person_status_id = 0);
  365. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('31/03/2021','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMS'), last_med_visit_exp =TO_DATE('31/03/2026','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001238' AND person_status_id = 0);
  366. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('08/03/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('08/03/2024','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001334' AND person_status_id = 0);
  367. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('13/06/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =NULL,last_med_visit_reason='VISITE DE PRE-REPRISE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000496' AND person_status_id = 0);
  368. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('08/11/2022','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('08/11/2024','DD/MM/YYYY'),last_med_visit_reason='EXAMEN PERIODIQUE SMR', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001101' AND person_status_id = 0);
  369. UPDATE person SET last_med_visit_medical_center = 'ACMS', last_med_visit_date =TO_DATE('03/03/2023','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('05/06/2023','DD/MM/YYYY'),last_med_visit_reason='VISITE DE REPRISE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0000556' AND person_status_id = 0);
  370. UPDATE person SET last_med_visit_medical_center = 'OMT Office de la Médecine du Travail - Monaco', last_med_visit_date =TO_DATE('13/03/2023','DD/MM/YYYY'), vo_medical_follow_up_type_id =(SELECT vo_medical_follow_up_type_id FROM vo_medical_follow_up_type WHERE vehicle_owner_id=101420 AND short_code='SMR'), last_med_visit_exp =TO_DATE('13/03/2025','DD/MM/YYYY'),last_med_visit_reason='EMBAUCHE', last_med_visit_status_id=100 WHERE person_id=(SELECT p.person_id FROM person p, vo_person_category vopc WHERE p.vo_person_category_id = vopc.vo_person_category_id AND vopc.vehicle_owner_id=101420 AND p.company_nr='0001415' AND person_status_id = 0);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!