API tools faq
paste
Advertisement
psi_mmobile

Untitled

psi_mmobile
Mar 20th, 2020
766
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 56.33 KB | None | 0 0
raw download clone embed print report
  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');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!