psi_mmobile

Untitled

Mar 20th, 2020
245
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 56.33 KB | None | 0 0
  1. --INSERT INTO VO_GROUP_PERSON VALUES (2811,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='194' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  2. UPDATE VO_GROUP_PERSON SET VO_GROUP_ID = 2811, LM_COMMENT = 'PSI XLSX' WHERE PERSON_ID  = 116971;
  3. INSERT INTO VO_GROUP_PERSON VALUES (2811,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='195' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  4. INSERT INTO VO_GROUP_PERSON VALUES (2811,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='196' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  5. INSERT INTO VO_GROUP_PERSON VALUES (2811,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='197' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  6. INSERT INTO VO_GROUP_PERSON VALUES (2811,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='198' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  7. INSERT INTO VO_GROUP_PERSON VALUES (2811,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='200' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  8. INSERT INTO VO_GROUP_PERSON VALUES (2811,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='201' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  9. INSERT INTO VO_GROUP_PERSON VALUES (2811,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='207' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  10. INSERT INTO VO_GROUP_PERSON VALUES (2811,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='210' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  11. INSERT INTO VO_GROUP_PERSON VALUES (2811,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='211' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  12. INSERT INTO VO_GROUP_PERSON VALUES (2811,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='213' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  13. INSERT INTO VO_GROUP_PERSON VALUES (2811,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='203' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  14. INSERT INTO VO_GROUP_PERSON VALUES (2811,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='214' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  15. INSERT INTO VO_GROUP_PERSON VALUES (2811,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='215' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  16. INSERT INTO VO_GROUP_PERSON VALUES (2811,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='218' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  17. INSERT INTO VO_GROUP_PERSON VALUES (2811,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='220' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  18. INSERT INTO VO_GROUP_PERSON VALUES (2811,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='221' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  19. INSERT INTO VO_GROUP_PERSON VALUES (2811,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='222' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  20. INSERT INTO VO_GROUP_PERSON VALUES (2811,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='224' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  21. INSERT INTO VO_GROUP_PERSON VALUES (2811,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='227' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  22. INSERT INTO VO_GROUP_PERSON VALUES (2811,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='228' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  23. INSERT INTO VO_GROUP_PERSON VALUES (2811,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='229' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  24. INSERT INTO VO_GROUP_PERSON VALUES (2811,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='230' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  25. INSERT INTO VO_GROUP_PERSON VALUES (2811,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='231' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  26. INSERT INTO VO_GROUP_PERSON VALUES (2811,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='232' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  27. INSERT INTO VO_GROUP_PERSON VALUES (2811,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='236' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  28. INSERT INTO VO_GROUP_PERSON VALUES (2811,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='237' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  29. INSERT INTO VO_GROUP_PERSON VALUES (2811,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='238' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  30. INSERT INTO VO_GROUP_PERSON VALUES (2811,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='239' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  31. INSERT INTO VO_GROUP_PERSON VALUES (2811,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='240' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  32. INSERT INTO VO_GROUP_PERSON VALUES (2811,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='245' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  33. --INSERT INTO VO_GROUP_PERSON VALUES (2811,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='246' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  34. --INSERT INTO VO_GROUP_PERSON VALUES (2811,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='247' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  35. INSERT INTO VO_GROUP_PERSON VALUES (2811,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='1024' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  36. INSERT INTO VO_GROUP_PERSON VALUES (2811,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='1036' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  37. INSERT INTO VO_GROUP_PERSON VALUES (2811,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='1057' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  38. INSERT INTO VO_GROUP_PERSON VALUES (2811,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='1054' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  39. INSERT INTO VO_GROUP_PERSON VALUES (2811,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='1052' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  40. INSERT INTO VO_GROUP_PERSON VALUES (2811,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='977' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  41. INSERT INTO VO_GROUP_PERSON VALUES (2811,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='1061' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  42. INSERT INTO VO_GROUP_PERSON VALUES (2811,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='1051' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  43. INSERT INTO VO_GROUP_PERSON VALUES (2811,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='922' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  44. INSERT INTO VO_GROUP_PERSON VALUES (2811,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='940' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  45. INSERT INTO VO_GROUP_PERSON VALUES (2811,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='1043' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  46. INSERT INTO VO_GROUP_PERSON VALUES (2811,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='949' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  47. INSERT INTO VO_GROUP_PERSON VALUES (2811,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='1037' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  48. INSERT INTO VO_GROUP_PERSON VALUES (2811,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='1062' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  49. --INSERT INTO VO_GROUP_PERSON VALUES (2811,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='1000' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  50. INSERT INTO VO_GROUP_PERSON VALUES (2811,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='1007' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  51. INSERT INTO VO_GROUP_PERSON VALUES (2811,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='998' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  52. INSERT INTO VO_GROUP_PERSON VALUES (2811,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='909' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  53. INSERT INTO VO_GROUP_PERSON VALUES (2811,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='1010' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  54. --INSERT INTO VO_GROUP_PERSON VALUES (2811,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='1004' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  55. INSERT INTO VO_GROUP_PERSON VALUES (2811,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='1015' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  56. INSERT INTO VO_GROUP_PERSON VALUES (2811,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='989' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  57. --INSERT INTO VO_GROUP_PERSON VALUES (2811,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='1036' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  58. INSERT INTO VO_GROUP_PERSON VALUES (2811,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='915' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  59. INSERT INTO VO_GROUP_PERSON VALUES (2811,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='1060' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  60. INSERT INTO VO_GROUP_PERSON VALUES (2811,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='1016' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  61. INSERT INTO VO_GROUP_PERSON VALUES (2811,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='928' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  62. --INSERT INTO VO_GROUP_PERSON VALUES (2811,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='921' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  63. UPDATE VO_GROUP_PERSON SET VO_GROUP_ID = 2811, LM_COMMENT = 'PSI XLSX' WHERE PERSON_ID  = 177453;
  64. INSERT INTO VO_GROUP_PERSON VALUES (2811,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='1038' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  65. INSERT INTO VO_GROUP_PERSON VALUES (2811,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='1030' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  66. INSERT INTO VO_GROUP_PERSON VALUES (2811,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='968' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  67. INSERT INTO VO_GROUP_PERSON VALUES (2811,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='993' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  68. INSERT INTO VO_GROUP_PERSON VALUES (2811,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='1032' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  69. --INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='004' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  70. UPDATE VO_GROUP_PERSON SET VO_GROUP_ID = 2810, LM_COMMENT = 'PSI XLSX' WHERE PERSON_ID  = 105526;
  71. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='005' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  72. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='006' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  73. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='007' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  74. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='011' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  75. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='017' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  76. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='020' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  77. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='025' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  78. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='026' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  79. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='038' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  80. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='040' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  81. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='042' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  82. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='044' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  83. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='045' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  84. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='050' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  85. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='055' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  86. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='058' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  87. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='061' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  88. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='066' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  89. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='067' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  90. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='073' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  91. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='078' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  92. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='085' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  93. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='137' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  94. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='165' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  95. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='191' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  96. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='204' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  97. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='216' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  98. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='241' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  99. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='244' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  100. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='262' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  101. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='263' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  102. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='277' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  103. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='289' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  104. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='297' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  105. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='312' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  106. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='313' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  107. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='314' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  108. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='325' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  109. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='328' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  110. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='343' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  111. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='349' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  112. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='350' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  113. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='363' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  114. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='365' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  115. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='373' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  116. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='378' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  117. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='383' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  118. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='384' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  119. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='401' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  120. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='402' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  121. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='410' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  122. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='411' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  123. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='414' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  124. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='415' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  125. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='416' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  126. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='417' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  127. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='418' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  128. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='420' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  129. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='421' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  130. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='425' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  131. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='429' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  132. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='431' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  133. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='432' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  134. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='433' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  135. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='434' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  136. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='437' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  137. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='438' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  138. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='439' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  139. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='440' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  140. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='441' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  141. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='442' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  142. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='443' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  143. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='444' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  144. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='446' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  145. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='611' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  146. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='612' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  147. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='638' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  148. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='644' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  149. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='651' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  150. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='653' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  151. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='659' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  152. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='661' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  153. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='674' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  154. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='676' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  155. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='684' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  156. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='687' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  157. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='688' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  158. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='695' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  159. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='696' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID = 100699), 'PSI XLSX');
  160. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='929' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  161. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='903' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  162. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='954' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  163. --INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='902' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  164. UPDATE VO_GROUP_PERSON SET VO_GROUP_ID = 2810, LM_COMMENT = 'PSI XLSX' WHERE PERSON_ID  = 177468;
  165. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='935' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  166. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='912' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  167. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='952' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  168. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='1009' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  169. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='1008' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  170. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='904' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  171. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='981' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  172. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='964' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  173. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='974' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  174. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='1028' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  175. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='1020' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  176. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='1027' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  177. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='980' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  178. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='950' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  179. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='1011' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  180. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='917' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  181. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='1033' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  182. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='932' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  183. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='1042' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  184. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='941' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  185. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='986' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  186. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='931' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  187. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='967' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  188. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='910' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  189. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='951' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  190. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='916' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  191. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='969' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  192. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='990' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  193. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='963' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  194. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='936' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  195. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='1035' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  196. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='945' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  197. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='906' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  198. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='982' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  199. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='919' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  200. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='976' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  201. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='1044' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  202. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='1012' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  203. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='992' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  204. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='987' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  205. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='924' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  206. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='1001' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  207. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='1000' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  208. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='994' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  209. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='901' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  210. --INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='1066' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  211. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='1004' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  212. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='908' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  213. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='955' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  214. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='1031' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  215. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='1006' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  216. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='1039' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  217. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='1063' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  218. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='923' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  219. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='1064' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  220. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='1025' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  221. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='960' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  222. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='911' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  223. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='973' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  224. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='962' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  225. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='971' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  226. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='966' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  227. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='918' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  228. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='978' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  229. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='1045' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  230. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='905' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
  231. INSERT INTO VO_GROUP_PERSON VALUES (2810,(SELECT PERSON_ID FROM PERSON P, VO_PERSON_CATEGORY VP WHERE P.PERSON_STATUS_ID=0 AND P.COMPANY_NR='988' AND P.VO_PERSON_CATEGORY_ID=VP.VO_PERSON_CATEGORY_ID AND VP.VO_PERSON_CATEGORY_ID=103836), 'PSI XLSX');
Add Comment
Please, Sign In to add comment