Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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');
- 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 =TO_DATE('00/00/0000','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='0000496');
- 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');
- 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');
- 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');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement