API tools faq
paste
Advertisement
psi_mmobile

Untitled

psi_mmobile
Mar 8th, 2024
1,301
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 127.17 KB | None | 0 0
raw download clone embed print report
  1. -- day_id = 1
  2. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=1 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_01');
  3. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=1 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_01');
  4. UPDATE working_schedule_day SET nbr_hr_am=2 WHERE day_id=1 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_02');
  5. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=1 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_02');
  6. UPDATE working_schedule_day SET nbr_hr_am=3.5 WHERE day_id=1 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_03');
  7. UPDATE working_schedule_day SET nbr_hr_pm=3.5 WHERE day_id=1 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_03');
  8. UPDATE working_schedule_day SET nbr_hr_am=3.5 WHERE day_id=1 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_04');
  9. UPDATE working_schedule_day SET nbr_hr_pm=3.5 WHERE day_id=1 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_04');
  10. UPDATE working_schedule_day SET nbr_hr_am=4 WHERE day_id=1 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_05');
  11. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=1 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_05');
  12. UPDATE working_schedule_day SET nbr_hr_am=3.5 WHERE day_id=1 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_06');
  13. UPDATE working_schedule_day SET nbr_hr_pm=3.5 WHERE day_id=1 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_06');
  14. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=1 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_07');
  15. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=1 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_07');
  16. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=1 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_08');
  17. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=1 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_08');
  18. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=1 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_09');
  19. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=1 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_09');
  20. UPDATE working_schedule_day SET nbr_hr_am=5 WHERE day_id=1 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_10');
  21. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=1 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_10');
  22. UPDATE working_schedule_day SET nbr_hr_am=3.5 WHERE day_id=1 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_11');
  23. UPDATE working_schedule_day SET nbr_hr_pm=3.5 WHERE day_id=1 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_11');
  24. UPDATE working_schedule_day SET nbr_hr_am=4 WHERE day_id=1 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_12');
  25. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=1 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_12');
  26. UPDATE working_schedule_day SET nbr_hr_am=3.5 WHERE day_id=1 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_13');
  27. UPDATE working_schedule_day SET nbr_hr_pm=3.5 WHERE day_id=1 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_13');
  28. UPDATE working_schedule_day SET nbr_hr_am=5.8 WHERE day_id=1 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_14');
  29. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=1 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_14');
  30. UPDATE working_schedule_day SET nbr_hr_am=4 WHERE day_id=1 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_15');
  31. UPDATE working_schedule_day SET nbr_hr_pm=4 WHERE day_id=1 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_15');
  32. UPDATE working_schedule_day SET nbr_hr_am=4 WHERE day_id=1 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_16');
  33. UPDATE working_schedule_day SET nbr_hr_pm=2.25 WHERE day_id=1 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_16');
  34. UPDATE working_schedule_day SET nbr_hr_am=4 WHERE day_id=1 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_17');
  35. UPDATE working_schedule_day SET nbr_hr_pm=4 WHERE day_id=1 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_17');
  36. UPDATE working_schedule_day SET nbr_hr_am=4 WHERE day_id=1 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_18');
  37. UPDATE working_schedule_day SET nbr_hr_pm=4 WHERE day_id=1 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_18');
  38. UPDATE working_schedule_day SET nbr_hr_am=3.5 WHERE day_id=1 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_19');
  39. UPDATE working_schedule_day SET nbr_hr_pm=3 WHERE day_id=1 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_19');
  40. UPDATE working_schedule_day SET nbr_hr_am=4 WHERE day_id=1 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_20');
  41. UPDATE working_schedule_day SET nbr_hr_pm=4 WHERE day_id=1 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_20');
  42. UPDATE working_schedule_day SET nbr_hr_am=4 WHERE day_id=1 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_21');
  43. UPDATE working_schedule_day SET nbr_hr_pm=4 WHERE day_id=1 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_21');
  44. UPDATE working_schedule_day SET nbr_hr_am=3.5 WHERE day_id=1 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_22');
  45. UPDATE working_schedule_day SET nbr_hr_pm=3.5 WHERE day_id=1 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_22');
  46. UPDATE working_schedule_day SET nbr_hr_am=3.5 WHERE day_id=1 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_23');
  47. UPDATE working_schedule_day SET nbr_hr_pm=3.5 WHERE day_id=1 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_23');
  48. UPDATE working_schedule_day SET nbr_hr_am=4 WHERE day_id=1 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_24');
  49. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=1 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_24');
  50. UPDATE working_schedule_day SET nbr_hr_am=4 WHERE day_id=1 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_25');
  51. UPDATE working_schedule_day SET nbr_hr_pm=4 WHERE day_id=1 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_25');
  52. UPDATE working_schedule_day SET nbr_hr_am=4 WHERE day_id=1 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_26');
  53. UPDATE working_schedule_day SET nbr_hr_pm=4 WHERE day_id=1 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_26');
  54. UPDATE working_schedule_day SET nbr_hr_am=4 WHERE day_id=1 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_27');
  55. UPDATE working_schedule_day SET nbr_hr_pm=4 WHERE day_id=1 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_27');
  56. UPDATE working_schedule_day SET nbr_hr_am=4.5 WHERE day_id=1 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_28');
  57. UPDATE working_schedule_day SET nbr_hr_pm=4.5 WHERE day_id=1 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_28');
  58. UPDATE working_schedule_day SET nbr_hr_am=4.75 WHERE day_id=1 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_29');
  59. UPDATE working_schedule_day SET nbr_hr_pm=4 WHERE day_id=1 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_29');
  60. UPDATE working_schedule_day SET nbr_hr_am=4.75 WHERE day_id=1 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_30');
  61. UPDATE working_schedule_day SET nbr_hr_pm=4 WHERE day_id=1 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_30');
  62. UPDATE working_schedule_day SET nbr_hr_am=5 WHERE day_id=1 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_31');
  63. UPDATE working_schedule_day SET nbr_hr_pm=5 WHERE day_id=1 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_31');
  64. UPDATE working_schedule_day SET nbr_hr_am=3.7 WHERE day_id=1 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_32');
  65. UPDATE working_schedule_day SET nbr_hr_pm=3.7 WHERE day_id=1 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_32');
  66. UPDATE working_schedule_day SET nbr_hr_am=4 WHERE day_id=1 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_33');
  67. UPDATE working_schedule_day SET nbr_hr_pm=4 WHERE day_id=1 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_33');
  68. UPDATE working_schedule_day SET nbr_hr_am=4 WHERE day_id=1 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_34');
  69. UPDATE working_schedule_day SET nbr_hr_pm=4 WHERE day_id=1 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_34');
  70. UPDATE working_schedule_day SET nbr_hr_am=4 WHERE day_id=1 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_35');
  71. UPDATE working_schedule_day SET nbr_hr_pm=4 WHERE day_id=1 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_35');
  72. UPDATE working_schedule_day SET nbr_hr_am=4 WHERE day_id=1 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_36');
  73. UPDATE working_schedule_day SET nbr_hr_pm=3.5 WHERE day_id=1 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_36');
  74. UPDATE working_schedule_day SET nbr_hr_am=4 WHERE day_id=1 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_37');
  75. UPDATE working_schedule_day SET nbr_hr_pm=3.25 WHERE day_id=1 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_37');
  76. UPDATE working_schedule_day SET nbr_hr_am=3.25 WHERE day_id=1 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_38');
  77. UPDATE working_schedule_day SET nbr_hr_pm=4 WHERE day_id=1 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_38');
  78.  
  79. COMMIT;
  80.  
  81. -- day_id = 2
  82.  
  83. UPDATE working_schedule_day SET nbr_hr_am=1.5 WHERE day_id=2 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_01');
  84. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=2 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_01');
  85. UPDATE working_schedule_day SET nbr_hr_am=2 WHERE day_id=2 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_02');
  86. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=2 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_02');
  87. UPDATE working_schedule_day SET nbr_hr_am=3.5 WHERE day_id=2 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_03');
  88. UPDATE working_schedule_day SET nbr_hr_pm=3.5 WHERE day_id=2 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_03');
  89. UPDATE working_schedule_day SET nbr_hr_am=3.5 WHERE day_id=2 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_04');
  90. UPDATE working_schedule_day SET nbr_hr_pm=3.5 WHERE day_id=2 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_04');
  91. UPDATE working_schedule_day SET nbr_hr_am=4 WHERE day_id=2 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_05');
  92. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=2 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_05');
  93. UPDATE working_schedule_day SET nbr_hr_am=3.5 WHERE day_id=2 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_06');
  94. UPDATE working_schedule_day SET nbr_hr_pm=3.5 WHERE day_id=2 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_06');
  95. UPDATE working_schedule_day SET nbr_hr_am=3.5 WHERE day_id=2 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_07');
  96. UPDATE working_schedule_day SET nbr_hr_pm=3.5 WHERE day_id=2 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_07');
  97. UPDATE working_schedule_day SET nbr_hr_am=3.5 WHERE day_id=2 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_08');
  98. UPDATE working_schedule_day SET nbr_hr_pm=3.5 WHERE day_id=2 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_08');
  99. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=2 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_09');
  100. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=2 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_09');
  101. UPDATE working_schedule_day SET nbr_hr_am=5 WHERE day_id=2 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_10');
  102. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=2 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_10');
  103. UPDATE working_schedule_day SET nbr_hr_am=3.5 WHERE day_id=2 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_11');
  104. UPDATE working_schedule_day SET nbr_hr_pm=3.5 WHERE day_id=2 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_11');
  105. UPDATE working_schedule_day SET nbr_hr_am=4 WHERE day_id=2 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_12');
  106. UPDATE working_schedule_day SET nbr_hr_pm=4 WHERE day_id=2 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_12');
  107. UPDATE working_schedule_day SET nbr_hr_am=3.5 WHERE day_id=2 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_13');
  108. UPDATE working_schedule_day SET nbr_hr_pm=3.5 WHERE day_id=2 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_13');
  109. UPDATE working_schedule_day SET nbr_hr_am=5.8 WHERE day_id=2 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_14');
  110. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=2 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_14');
  111. UPDATE working_schedule_day SET nbr_hr_am=4 WHERE day_id=2 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_15');
  112. UPDATE working_schedule_day SET nbr_hr_pm=4 WHERE day_id=2 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_15');
  113. UPDATE working_schedule_day SET nbr_hr_am=4 WHERE day_id=2 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_16');
  114. UPDATE working_schedule_day SET nbr_hr_pm=2.25 WHERE day_id=2 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_16');
  115. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=2 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_17');
  116. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=2 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_17');
  117. UPDATE working_schedule_day SET nbr_hr_am=4 WHERE day_id=2 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_18');
  118. UPDATE working_schedule_day SET nbr_hr_pm=4 WHERE day_id=2 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_18');
  119. UPDATE working_schedule_day SET nbr_hr_am=3.5 WHERE day_id=2 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_19');
  120. UPDATE working_schedule_day SET nbr_hr_pm=3 WHERE day_id=2 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_19');
  121. UPDATE working_schedule_day SET nbr_hr_am=4 WHERE day_id=2 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_20');
  122. UPDATE working_schedule_day SET nbr_hr_pm=4 WHERE day_id=2 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_20');
  123. UPDATE working_schedule_day SET nbr_hr_am=4 WHERE day_id=2 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_21');
  124. UPDATE working_schedule_day SET nbr_hr_pm=4 WHERE day_id=2 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_21');
  125. UPDATE working_schedule_day SET nbr_hr_am=3.5 WHERE day_id=2 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_22');
  126. UPDATE working_schedule_day SET nbr_hr_pm=3.5 WHERE day_id=2 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_22');
  127. UPDATE working_schedule_day SET nbr_hr_am=3.5 WHERE day_id=2 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_23');
  128. UPDATE working_schedule_day SET nbr_hr_pm=3.5 WHERE day_id=2 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_23');
  129. UPDATE working_schedule_day SET nbr_hr_am=4.5 WHERE day_id=2 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_24');
  130. UPDATE working_schedule_day SET nbr_hr_pm=4.5 WHERE day_id=2 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_24');
  131. UPDATE working_schedule_day SET nbr_hr_am=4 WHERE day_id=2 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_25');
  132. UPDATE working_schedule_day SET nbr_hr_pm=4 WHERE day_id=2 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_25');
  133. UPDATE working_schedule_day SET nbr_hr_am=4 WHERE day_id=2 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_26');
  134. UPDATE working_schedule_day SET nbr_hr_pm=4 WHERE day_id=2 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_26');
  135. UPDATE working_schedule_day SET nbr_hr_am=4 WHERE day_id=2 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_27');
  136. UPDATE working_schedule_day SET nbr_hr_pm=4 WHERE day_id=2 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_27');
  137. UPDATE working_schedule_day SET nbr_hr_am=4.5 WHERE day_id=2 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_28');
  138. UPDATE working_schedule_day SET nbr_hr_pm=4.5 WHERE day_id=2 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_28');
  139. UPDATE working_schedule_day SET nbr_hr_am=4.75 WHERE day_id=2 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_29');
  140. UPDATE working_schedule_day SET nbr_hr_pm=4 WHERE day_id=2 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_29');
  141. UPDATE working_schedule_day SET nbr_hr_am=4.75 WHERE day_id=2 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_30');
  142. UPDATE working_schedule_day SET nbr_hr_pm=4 WHERE day_id=2 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_30');
  143. UPDATE working_schedule_day SET nbr_hr_am=5 WHERE day_id=2 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_31');
  144. UPDATE working_schedule_day SET nbr_hr_pm=5 WHERE day_id=2 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_31');
  145. UPDATE working_schedule_day SET nbr_hr_am=3.7 WHERE day_id=2 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_32');
  146. UPDATE working_schedule_day SET nbr_hr_pm=3.7 WHERE day_id=2 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_32');
  147. UPDATE working_schedule_day SET nbr_hr_am=4 WHERE day_id=2 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_33');
  148. UPDATE working_schedule_day SET nbr_hr_pm=4 WHERE day_id=2 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_33');
  149. UPDATE working_schedule_day SET nbr_hr_am=4 WHERE day_id=2 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_34');
  150. UPDATE working_schedule_day SET nbr_hr_pm=4 WHERE day_id=2 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_34');
  151. UPDATE working_schedule_day SET nbr_hr_am=4 WHERE day_id=2 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_35');
  152. UPDATE working_schedule_day SET nbr_hr_pm=4 WHERE day_id=2 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_35');
  153. UPDATE working_schedule_day SET nbr_hr_am=4 WHERE day_id=2 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_36');
  154. UPDATE working_schedule_day SET nbr_hr_pm=3.5 WHERE day_id=2 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_36');
  155. UPDATE working_schedule_day SET nbr_hr_am=4 WHERE day_id=2 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_37');
  156. UPDATE working_schedule_day SET nbr_hr_pm=3.25 WHERE day_id=2 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_37');
  157. UPDATE working_schedule_day SET nbr_hr_am=3.25 WHERE day_id=2 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_38');
  158. UPDATE working_schedule_day SET nbr_hr_pm=4 WHERE day_id=2 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_38');
  159.  
  160. COMMIT;
  161.  
  162. -- day_id = 3
  163.  
  164. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=3 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_01');
  165. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=3 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_01');
  166. UPDATE working_schedule_day SET nbr_hr_am=2 WHERE day_id=3 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_02');
  167. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=3 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_02');
  168. UPDATE working_schedule_day SET nbr_hr_am=3.5 WHERE day_id=3 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_03');
  169. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=3 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_03');
  170. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=3 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_04');
  171. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=3 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_04');
  172. UPDATE working_schedule_day SET nbr_hr_am=4 WHERE day_id=3 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_05');
  173. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=3 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_05');
  174. UPDATE working_schedule_day SET nbr_hr_am=3.5 WHERE day_id=3 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_06');
  175. UPDATE working_schedule_day SET nbr_hr_pm=3.5 WHERE day_id=3 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_06');
  176. UPDATE working_schedule_day SET nbr_hr_am=3.5 WHERE day_id=3 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_07');
  177. UPDATE working_schedule_day SET nbr_hr_pm=3.5 WHERE day_id=3 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_07');
  178. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=3 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_08');
  179. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=3 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_08');
  180. UPDATE working_schedule_day SET nbr_hr_am=3.5 WHERE day_id=3 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_09');
  181. UPDATE working_schedule_day SET nbr_hr_pm=3.5 WHERE day_id=3 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_09');
  182. UPDATE working_schedule_day SET nbr_hr_am=5 WHERE day_id=3 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_10');
  183. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=3 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_10');
  184. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=3 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_11');
  185. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=3 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_11');
  186. UPDATE working_schedule_day SET nbr_hr_am=4 WHERE day_id=3 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_12');
  187. UPDATE working_schedule_day SET nbr_hr_pm=4 WHERE day_id=3 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_12');
  188. UPDATE working_schedule_day SET nbr_hr_am=3.5 WHERE day_id=3 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_13');
  189. UPDATE working_schedule_day SET nbr_hr_pm=3.5 WHERE day_id=3 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_13');
  190. UPDATE working_schedule_day SET nbr_hr_am=5.8 WHERE day_id=3 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_14');
  191. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=3 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_14');
  192. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=3 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_15');
  193. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=3 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_15');
  194. UPDATE working_schedule_day SET nbr_hr_am=4 WHERE day_id=3 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_16');
  195. UPDATE working_schedule_day SET nbr_hr_pm=2.25 WHERE day_id=3 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_16');
  196. UPDATE working_schedule_day SET nbr_hr_am=4 WHERE day_id=3 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_17');
  197. UPDATE working_schedule_day SET nbr_hr_pm=4 WHERE day_id=3 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_17');
  198. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=3 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_18');
  199. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=3 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_18');
  200. UPDATE working_schedule_day SET nbr_hr_am=3.5 WHERE day_id=3 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_19');
  201. UPDATE working_schedule_day SET nbr_hr_pm=3 WHERE day_id=3 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_19');
  202. UPDATE working_schedule_day SET nbr_hr_am=4 WHERE day_id=3 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_20');
  203. UPDATE working_schedule_day SET nbr_hr_pm=4 WHERE day_id=3 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_20');
  204. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=3 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_21');
  205. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=3 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_21');
  206. UPDATE working_schedule_day SET nbr_hr_am=5 WHERE day_id=3 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_22');
  207. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=3 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_22');
  208. UPDATE working_schedule_day SET nbr_hr_am=3.5 WHERE day_id=3 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_23');
  209. UPDATE working_schedule_day SET nbr_hr_pm=3.5 WHERE day_id=3 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_23');
  210. UPDATE working_schedule_day SET nbr_hr_am=4.5 WHERE day_id=3 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_24');
  211. UPDATE working_schedule_day SET nbr_hr_pm=4.5 WHERE day_id=3 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_24');
  212. UPDATE working_schedule_day SET nbr_hr_am=3 WHERE day_id=3 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_25');
  213. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=3 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_25');
  214. UPDATE working_schedule_day SET nbr_hr_am=4 WHERE day_id=3 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_26');
  215. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=3 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_26');
  216. UPDATE working_schedule_day SET nbr_hr_am=4 WHERE day_id=3 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_27');
  217. UPDATE working_schedule_day SET nbr_hr_pm=4 WHERE day_id=3 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_27');
  218. UPDATE working_schedule_day SET nbr_hr_am=4.5 WHERE day_id=3 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_28');
  219. UPDATE working_schedule_day SET nbr_hr_pm=4.5 WHERE day_id=3 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_28');
  220. UPDATE working_schedule_day SET nbr_hr_am=4.75 WHERE day_id=3 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_29');
  221. UPDATE working_schedule_day SET nbr_hr_pm=4 WHERE day_id=3 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_29');
  222. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=3 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_30');
  223. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=3 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_30');
  224. UPDATE working_schedule_day SET nbr_hr_am=5 WHERE day_id=3 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_31');
  225. UPDATE working_schedule_day SET nbr_hr_pm=5 WHERE day_id=3 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_31');
  226. UPDATE working_schedule_day SET nbr_hr_am=3.7 WHERE day_id=3 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_32');
  227. UPDATE working_schedule_day SET nbr_hr_pm=3.7 WHERE day_id=3 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_32');
  228. UPDATE working_schedule_day SET nbr_hr_am=4 WHERE day_id=3 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_33');
  229. UPDATE working_schedule_day SET nbr_hr_pm=4 WHERE day_id=3 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_33');
  230. UPDATE working_schedule_day SET nbr_hr_am=4 WHERE day_id=3 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_34');
  231. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=3 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_34');
  232. UPDATE working_schedule_day SET nbr_hr_am=4 WHERE day_id=3 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_35');
  233. UPDATE working_schedule_day SET nbr_hr_pm=4 WHERE day_id=3 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_35');
  234. UPDATE working_schedule_day SET nbr_hr_am=4 WHERE day_id=3 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_36');
  235. UPDATE working_schedule_day SET nbr_hr_pm=3.5 WHERE day_id=3 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_36');
  236. UPDATE working_schedule_day SET nbr_hr_am=4 WHERE day_id=3 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_37');
  237. UPDATE working_schedule_day SET nbr_hr_pm=3.25 WHERE day_id=3 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_37');
  238. UPDATE working_schedule_day SET nbr_hr_am=3.25 WHERE day_id=3 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_38');
  239. UPDATE working_schedule_day SET nbr_hr_pm=4 WHERE day_id=3 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_38');
  240.  
  241. COMMIT;
  242.  
  243. -- day_id = 4
  244.  
  245. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=4 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_01');
  246. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=4 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_01');
  247. UPDATE working_schedule_day SET nbr_hr_am=4 WHERE day_id=4 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_02');
  248. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=4 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_02');
  249. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=4 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_03');
  250. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=4 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_03');
  251. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=4 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_04');
  252. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=4 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_04');
  253. UPDATE working_schedule_day SET nbr_hr_am=4 WHERE day_id=4 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_05');
  254. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=4 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_05');
  255. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=4 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_06');
  256. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=4 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_06');
  257. UPDATE working_schedule_day SET nbr_hr_am=3.5 WHERE day_id=4 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_07');
  258. UPDATE working_schedule_day SET nbr_hr_pm=3.5 WHERE day_id=4 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_07');
  259. UPDATE working_schedule_day SET nbr_hr_am=3.5 WHERE day_id=4 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_08');
  260. UPDATE working_schedule_day SET nbr_hr_pm=3.5 WHERE day_id=4 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_08');
  261. UPDATE working_schedule_day SET nbr_hr_am=3.5 WHERE day_id=4 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_09');
  262. UPDATE working_schedule_day SET nbr_hr_pm=3.5 WHERE day_id=4 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_09');
  263. UPDATE working_schedule_day SET nbr_hr_am=5 WHERE day_id=4 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_10');
  264. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=4 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_10');
  265. UPDATE working_schedule_day SET nbr_hr_am=3.5 WHERE day_id=4 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_11');
  266. UPDATE working_schedule_day SET nbr_hr_pm=3.5 WHERE day_id=4 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_11');
  267. UPDATE working_schedule_day SET nbr_hr_am=4 WHERE day_id=4 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_12');
  268. UPDATE working_schedule_day SET nbr_hr_pm=4 WHERE day_id=4 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_12');
  269. UPDATE working_schedule_day SET nbr_hr_am=3.5 WHERE day_id=4 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_13');
  270. UPDATE working_schedule_day SET nbr_hr_pm=3.5 WHERE day_id=4 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_13');
  271. UPDATE working_schedule_day SET nbr_hr_am=5.8 WHERE day_id=4 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_14');
  272. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=4 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_14');
  273. UPDATE working_schedule_day SET nbr_hr_am=4 WHERE day_id=4 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_15');
  274. UPDATE working_schedule_day SET nbr_hr_pm=4 WHERE day_id=4 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_15');
  275. UPDATE working_schedule_day SET nbr_hr_am=4 WHERE day_id=4 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_16');
  276. UPDATE working_schedule_day SET nbr_hr_pm=2.25 WHERE day_id=4 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_16');
  277. UPDATE working_schedule_day SET nbr_hr_am=4 WHERE day_id=4 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_17');
  278. UPDATE working_schedule_day SET nbr_hr_pm=4 WHERE day_id=4 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_17');
  279. UPDATE working_schedule_day SET nbr_hr_am=4 WHERE day_id=4 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_18');
  280. UPDATE working_schedule_day SET nbr_hr_pm=4 WHERE day_id=4 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_18');
  281. UPDATE working_schedule_day SET nbr_hr_am=3.5 WHERE day_id=4 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_19');
  282. UPDATE working_schedule_day SET nbr_hr_pm=3 WHERE day_id=4 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_19');
  283. UPDATE working_schedule_day SET nbr_hr_am=4 WHERE day_id=4 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_20');
  284. UPDATE working_schedule_day SET nbr_hr_pm=4 WHERE day_id=4 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_20');
  285. UPDATE working_schedule_day SET nbr_hr_am=4 WHERE day_id=4 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_21');
  286. UPDATE working_schedule_day SET nbr_hr_pm=4 WHERE day_id=4 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_21');
  287. UPDATE working_schedule_day SET nbr_hr_am=3.5 WHERE day_id=4 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_22');
  288. UPDATE working_schedule_day SET nbr_hr_pm=3.5 WHERE day_id=4 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_22');
  289. UPDATE working_schedule_day SET nbr_hr_am=3.5 WHERE day_id=4 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_23');
  290. UPDATE working_schedule_day SET nbr_hr_pm=3.5 WHERE day_id=4 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_23');
  291. UPDATE working_schedule_day SET nbr_hr_am=4.5 WHERE day_id=4 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_24');
  292. UPDATE working_schedule_day SET nbr_hr_pm=4.5 WHERE day_id=4 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_24');
  293. UPDATE working_schedule_day SET nbr_hr_am=4 WHERE day_id=4 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_25');
  294. UPDATE working_schedule_day SET nbr_hr_pm=4 WHERE day_id=4 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_25');
  295. UPDATE working_schedule_day SET nbr_hr_am=4 WHERE day_id=4 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_26');
  296. UPDATE working_schedule_day SET nbr_hr_pm=4 WHERE day_id=4 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_26');
  297. UPDATE working_schedule_day SET nbr_hr_am=4 WHERE day_id=4 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_27');
  298. UPDATE working_schedule_day SET nbr_hr_pm=4 WHERE day_id=4 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_27');
  299. UPDATE working_schedule_day SET nbr_hr_am=4 WHERE day_id=4 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_28');
  300. UPDATE working_schedule_day SET nbr_hr_pm=4 WHERE day_id=4 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_28');
  301. UPDATE working_schedule_day SET nbr_hr_am=4.75 WHERE day_id=4 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_29');
  302. UPDATE working_schedule_day SET nbr_hr_pm=4 WHERE day_id=4 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_29');
  303. UPDATE working_schedule_day SET nbr_hr_am=4.75 WHERE day_id=4 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_30');
  304. UPDATE working_schedule_day SET nbr_hr_pm=4 WHERE day_id=4 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_30');
  305. UPDATE working_schedule_day SET nbr_hr_am=4.5 WHERE day_id=4 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_31');
  306. UPDATE working_schedule_day SET nbr_hr_pm=4.5 WHERE day_id=4 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_31');
  307. UPDATE working_schedule_day SET nbr_hr_am=3.7 WHERE day_id=4 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_32');
  308. UPDATE working_schedule_day SET nbr_hr_pm=3.7 WHERE day_id=4 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_32');
  309. UPDATE working_schedule_day SET nbr_hr_am=4 WHERE day_id=4 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_33');
  310. UPDATE working_schedule_day SET nbr_hr_pm=4 WHERE day_id=4 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_33');
  311. UPDATE working_schedule_day SET nbr_hr_am=4 WHERE day_id=4 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_34');
  312. UPDATE working_schedule_day SET nbr_hr_pm=4 WHERE day_id=4 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_34');
  313. UPDATE working_schedule_day SET nbr_hr_am=4 WHERE day_id=4 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_35');
  314. UPDATE working_schedule_day SET nbr_hr_pm=4 WHERE day_id=4 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_35');
  315. UPDATE working_schedule_day SET nbr_hr_am=4 WHERE day_id=4 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_36');
  316. UPDATE working_schedule_day SET nbr_hr_pm=3.5 WHERE day_id=4 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_36');
  317. UPDATE working_schedule_day SET nbr_hr_am=4 WHERE day_id=4 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_37');
  318. UPDATE working_schedule_day SET nbr_hr_pm=3.25 WHERE day_id=4 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_37');
  319. UPDATE working_schedule_day SET nbr_hr_am=3.25 WHERE day_id=4 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_38');
  320. UPDATE working_schedule_day SET nbr_hr_pm=4 WHERE day_id=4 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_38');
  321.  
  322. COMMIT;
  323.  
  324. -- day_id = 5
  325.  
  326. UPDATE working_schedule_day SET nbr_hr_am=1.5 WHERE day_id=5 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_01');
  327. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=5 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_01');
  328. UPDATE working_schedule_day SET nbr_hr_am=2 WHERE day_id=5 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_02');
  329. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=5 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_02');
  330. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=5 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_03');
  331. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=5 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_03');
  332. UPDATE working_schedule_day SET nbr_hr_am=3.5 WHERE day_id=5 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_04');
  333. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=5 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_04');
  334. UPDATE working_schedule_day SET nbr_hr_am=4 WHERE day_id=5 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_05');
  335. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=5 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_05');
  336. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=5 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_06');
  337. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=5 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_06');
  338. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=5 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_07');
  339. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=5 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_07');
  340. UPDATE working_schedule_day SET nbr_hr_am=3.5 WHERE day_id=5 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_08');
  341. UPDATE working_schedule_day SET nbr_hr_pm=3.5 WHERE day_id=5 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_08');
  342. UPDATE working_schedule_day SET nbr_hr_am=3.5 WHERE day_id=5 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_09');
  343. UPDATE working_schedule_day SET nbr_hr_pm=3.5 WHERE day_id=5 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_09');
  344. UPDATE working_schedule_day SET nbr_hr_am=5 WHERE day_id=5 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_10');
  345. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=5 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_10');
  346. UPDATE working_schedule_day SET nbr_hr_am=3.5 WHERE day_id=5 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_11');
  347. UPDATE working_schedule_day SET nbr_hr_pm=3.5 WHERE day_id=5 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_11');
  348. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=5 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_12');
  349. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=5 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_12');
  350. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=5 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_13');
  351. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=5 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_13');
  352. UPDATE working_schedule_day SET nbr_hr_am=5.8 WHERE day_id=5 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_14');
  353. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=5 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_14');
  354. UPDATE working_schedule_day SET nbr_hr_am=4 WHERE day_id=5 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_15');
  355. UPDATE working_schedule_day SET nbr_hr_pm=2 WHERE day_id=5 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_15');
  356. UPDATE working_schedule_day SET nbr_hr_am=4 WHERE day_id=5 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_16');
  357. UPDATE working_schedule_day SET nbr_hr_pm=2 WHERE day_id=5 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_16');
  358. UPDATE working_schedule_day SET nbr_hr_am=3.5 WHERE day_id=5 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_17');
  359. UPDATE working_schedule_day SET nbr_hr_pm=3.5 WHERE day_id=5 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_17');
  360. UPDATE working_schedule_day SET nbr_hr_am=3.5 WHERE day_id=5 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_18');
  361. UPDATE working_schedule_day SET nbr_hr_pm=3.5 WHERE day_id=5 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_18');
  362. UPDATE working_schedule_day SET nbr_hr_am=3.5 WHERE day_id=5 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_19');
  363. UPDATE working_schedule_day SET nbr_hr_pm=2 WHERE day_id=5 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_19');
  364. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=5 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_20');
  365. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=5 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_20');
  366. UPDATE working_schedule_day SET nbr_hr_am=4 WHERE day_id=5 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_21');
  367. UPDATE working_schedule_day SET nbr_hr_pm=4 WHERE day_id=5 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_21');
  368. UPDATE working_schedule_day SET nbr_hr_am=3.5 WHERE day_id=5 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_22');
  369. UPDATE working_schedule_day SET nbr_hr_pm=3.5 WHERE day_id=5 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_22');
  370. UPDATE working_schedule_day SET nbr_hr_am=3.5 WHERE day_id=5 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_23');
  371. UPDATE working_schedule_day SET nbr_hr_pm=3.5 WHERE day_id=5 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_23');
  372. UPDATE working_schedule_day SET nbr_hr_am=4 WHERE day_id=5 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_24');
  373. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=5 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_24');
  374. UPDATE working_schedule_day SET nbr_hr_am=4 WHERE day_id=5 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_25');
  375. UPDATE working_schedule_day SET nbr_hr_pm=4 WHERE day_id=5 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_25');
  376. UPDATE working_schedule_day SET nbr_hr_am=3.5 WHERE day_id=5 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_26');
  377. UPDATE working_schedule_day SET nbr_hr_pm=3.5 WHERE day_id=5 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_26');
  378. UPDATE working_schedule_day SET nbr_hr_am=3 WHERE day_id=5 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_27');
  379. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=5 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_27');
  380. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=5 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_28');
  381. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=5 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_28');
  382. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=5 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_29');
  383. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=5 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_29');
  384. UPDATE working_schedule_day SET nbr_hr_am=4.75 WHERE day_id=5 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_30');
  385. UPDATE working_schedule_day SET nbr_hr_pm=4 WHERE day_id=5 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_30');
  386. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=5 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_31');
  387. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=5 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_31');
  388. UPDATE working_schedule_day SET nbr_hr_am=3.7 WHERE day_id=5 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_32');
  389. UPDATE working_schedule_day SET nbr_hr_pm=3.7 WHERE day_id=5 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_32');
  390. UPDATE working_schedule_day SET nbr_hr_am=4 WHERE day_id=5 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_33');
  391. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=5 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_33');
  392. UPDATE working_schedule_day SET nbr_hr_am=4 WHERE day_id=5 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_34');
  393. UPDATE working_schedule_day SET nbr_hr_pm=4 WHERE day_id=5 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_34');
  394. UPDATE working_schedule_day SET nbr_hr_am=3.5 WHERE day_id=5 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_35');
  395. UPDATE working_schedule_day SET nbr_hr_pm=3.5 WHERE day_id=5 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_35');
  396. UPDATE working_schedule_day SET nbr_hr_am=5 WHERE day_id=5 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_36');
  397. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=5 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_36');
  398. UPDATE working_schedule_day SET nbr_hr_am=4 WHERE day_id=5 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_37');
  399. UPDATE working_schedule_day SET nbr_hr_pm=2 WHERE day_id=5 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_37');
  400. UPDATE working_schedule_day SET nbr_hr_am=3.25 WHERE day_id=5 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_38');
  401. UPDATE working_schedule_day SET nbr_hr_pm=2.75 WHERE day_id=5 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_38');
  402.  
  403. COMMIT;
  404.  
  405. -- day_id = 6
  406.  
  407. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=6 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_01');
  408. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=6 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_01');
  409. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=6 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_02');
  410. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=6 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_02');
  411. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=6 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_03');
  412. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=6 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_03');
  413. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=6 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_04');
  414. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=6 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_04');
  415. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=6 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_05');
  416. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=6 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_05');
  417. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=6 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_06');
  418. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=6 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_06');
  419. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=6 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_07');
  420. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=6 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_07');
  421. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=6 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_08');
  422. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=6 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_08');
  423. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=6 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_09');
  424. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=6 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_09');
  425. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=6 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_10');
  426. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=6 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_10');
  427. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=6 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_11');
  428. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=6 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_11');
  429. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=6 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_12');
  430. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=6 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_12');
  431. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=6 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_13');
  432. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=6 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_13');
  433. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=6 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_14');
  434. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=6 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_14');
  435. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=6 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_15');
  436. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=6 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_15');
  437. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=6 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_16');
  438. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=6 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_16');
  439. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=6 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_17');
  440. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=6 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_17');
  441. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=6 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_18');
  442. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=6 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_18');
  443. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=6 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_19');
  444. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=6 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_19');
  445. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=6 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_20');
  446. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=6 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_20');
  447. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=6 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_21');
  448. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=6 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_21');
  449. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=6 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_22');
  450. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=6 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_22');
  451. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=6 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_23');
  452. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=6 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_23');
  453. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=6 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_24');
  454. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=6 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_24');
  455. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=6 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_25');
  456. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=6 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_25');
  457. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=6 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_26');
  458. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=6 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_26');
  459. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=6 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_27');
  460. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=6 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_27');
  461. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=6 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_28');
  462. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=6 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_28');
  463. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=6 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_29');
  464. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=6 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_29');
  465. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=6 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_30');
  466. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=6 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_30');
  467. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=6 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_31');
  468. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=6 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_31');
  469. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=6 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_32');
  470. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=6 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_32');
  471. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=6 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_33');
  472. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=6 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_33');
  473. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=6 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_34');
  474. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=6 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_34');
  475. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=6 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_35');
  476. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=6 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_35');
  477. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=6 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_36');
  478. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=6 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_36');
  479. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=6 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_37');
  480. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=6 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_37');
  481. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=6 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_38');
  482. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=6 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_38');
  483.  
  484. COMMIT;
  485.  
  486. -- day_id = 7
  487.  
  488. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=7 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_01');
  489. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=7 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_01');
  490. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=7 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_02');
  491. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=7 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_02');
  492. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=7 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_03');
  493. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=7 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_03');
  494. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=7 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_04');
  495. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=7 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_04');
  496. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=7 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_05');
  497. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=7 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_05');
  498. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=7 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_06');
  499. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=7 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_06');
  500. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=7 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_07');
  501. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=7 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_07');
  502. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=7 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_08');
  503. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=7 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_08');
  504. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=7 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_09');
  505. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=7 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_09');
  506. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=7 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_10');
  507. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=7 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_10');
  508. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=7 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_11');
  509. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=7 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_11');
  510. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=7 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_12');
  511. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=7 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_12');
  512. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=7 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_13');
  513. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=7 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_13');
  514. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=7 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_14');
  515. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=7 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_14');
  516. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=7 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_15');
  517. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=7 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_15');
  518. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=7 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_16');
  519. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=7 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_16');
  520. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=7 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_17');
  521. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=7 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_17');
  522. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=7 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_18');
  523. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=7 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_18');
  524. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=7 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_19');
  525. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=7 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_19');
  526. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=7 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_20');
  527. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=7 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_20');
  528. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=7 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_21');
  529. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=7 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_21');
  530. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=7 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_22');
  531. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=7 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_22');
  532. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=7 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_23');
  533. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=7 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_23');
  534. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=7 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_24');
  535. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=7 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_24');
  536. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=7 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_25');
  537. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=7 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_25');
  538. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=7 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_26');
  539. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=7 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_26');
  540. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=7 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_27');
  541. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=7 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_27');
  542. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=7 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_28');
  543. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=7 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_28');
  544. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=7 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_29');
  545. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=7 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_29');
  546. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=7 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_30');
  547. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=7 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_30');
  548. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=7 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_31');
  549. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=7 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_31');
  550. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=7 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_32');
  551. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=7 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_32');
  552. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=7 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_33');
  553. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=7 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_33');
  554. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=7 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_34');
  555. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=7 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_34');
  556. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=7 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_35');
  557. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=7 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_35');
  558. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=7 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_36');
  559. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=7 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_36');
  560. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=7 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_37');
  561. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=7 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_37');
  562. UPDATE working_schedule_day SET nbr_hr_am=0 WHERE day_id=7 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_38');
  563. UPDATE working_schedule_day SET nbr_hr_pm=0 WHERE day_id=7 AND working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_38');
  564.  
  565. COMMIT;
  566.  
  567. -- contractual_week_hr & contractual_month_hr
  568.  
  569. UPDATE working_schedule SET lm_name='PSI',lm_date=SYSDATE,contractual_week_hr=3, contractual_month_hr=13 WHERE working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_01');
  570. UPDATE working_schedule SET lm_name='PSI',lm_date=SYSDATE,contractual_week_hr=12, contractual_month_hr=52 WHERE working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_02');
  571. UPDATE working_schedule SET lm_name='PSI',lm_date=SYSDATE,contractual_week_hr=17.5, contractual_month_hr=75.83 WHERE working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_03');
  572. UPDATE working_schedule SET lm_name='PSI',lm_date=SYSDATE,contractual_week_hr=17.5, contractual_month_hr=75.83 WHERE working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_04');
  573. UPDATE working_schedule SET lm_name='PSI',lm_date=SYSDATE,contractual_week_hr=20, contractual_month_hr=86.67 WHERE working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_05');
  574. UPDATE working_schedule SET lm_name='PSI',lm_date=SYSDATE,contractual_week_hr=21, contractual_month_hr=91 WHERE working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_06');
  575. UPDATE working_schedule SET lm_name='PSI',lm_date=SYSDATE,contractual_week_hr=21, contractual_month_hr=91 WHERE working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_07');
  576. UPDATE working_schedule SET lm_name='PSI',lm_date=SYSDATE,contractual_week_hr=21, contractual_month_hr=91 WHERE working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_08');
  577. UPDATE working_schedule SET lm_name='PSI',lm_date=SYSDATE,contractual_week_hr=21, contractual_month_hr=91 WHERE working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_09');
  578. UPDATE working_schedule SET lm_name='PSI',lm_date=SYSDATE,contractual_week_hr=25, contractual_month_hr=108.33 WHERE working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_10');
  579. UPDATE working_schedule SET lm_name='PSI',lm_date=SYSDATE,contractual_week_hr=28, contractual_month_hr=121.33 WHERE working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_11');
  580. UPDATE working_schedule SET lm_name='PSI',lm_date=SYSDATE,contractual_week_hr=28, contractual_month_hr=121.33 WHERE working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_12');
  581. UPDATE working_schedule SET lm_name='PSI',lm_date=SYSDATE,contractual_week_hr=28, contractual_month_hr=121.33 WHERE working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_13');
  582. UPDATE working_schedule SET lm_name='PSI',lm_date=SYSDATE,contractual_week_hr=29, contractual_month_hr=125.67 WHERE working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_14');
  583. UPDATE working_schedule SET lm_name='PSI',lm_date=SYSDATE,contractual_week_hr=30, contractual_month_hr=130 WHERE working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_15');
  584. UPDATE working_schedule SET lm_name='PSI',lm_date=SYSDATE,contractual_week_hr=31, contractual_month_hr=134.33 WHERE working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_16');
  585. UPDATE working_schedule SET lm_name='PSI',lm_date=SYSDATE,contractual_week_hr=31, contractual_month_hr=134.33 WHERE working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_17');
  586. UPDATE working_schedule SET lm_name='PSI',lm_date=SYSDATE,contractual_week_hr=31, contractual_month_hr=134.33 WHERE working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_18');
  587. UPDATE working_schedule SET lm_name='PSI',lm_date=SYSDATE,contractual_week_hr=31.5, contractual_month_hr=136.5 WHERE working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_19');
  588. UPDATE working_schedule SET lm_name='PSI',lm_date=SYSDATE,contractual_week_hr=32, contractual_month_hr=138.67 WHERE working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_20');
  589. UPDATE working_schedule SET lm_name='PSI',lm_date=SYSDATE,contractual_week_hr=32, contractual_month_hr=138.67 WHERE working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_21');
  590. UPDATE working_schedule SET lm_name='PSI',lm_date=SYSDATE,contractual_week_hr=33, contractual_month_hr=142.92 WHERE working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_22');
  591. UPDATE working_schedule SET lm_name='PSI',lm_date=SYSDATE,contractual_week_hr=35, contractual_month_hr=151.67 WHERE working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_23');
  592. UPDATE working_schedule SET lm_name='PSI',lm_date=SYSDATE,contractual_week_hr=35, contractual_month_hr=151.67 WHERE working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_24');
  593. UPDATE working_schedule SET lm_name='PSI',lm_date=SYSDATE,contractual_week_hr=35, contractual_month_hr=151.67 WHERE working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_25');
  594. UPDATE working_schedule SET lm_name='PSI',lm_date=SYSDATE,contractual_week_hr=35, contractual_month_hr=151.67 WHERE working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_26');
  595. UPDATE working_schedule SET lm_name='PSI',lm_date=SYSDATE,contractual_week_hr=35, contractual_month_hr=151.67 WHERE working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_27');
  596. UPDATE working_schedule SET lm_name='PSI',lm_date=SYSDATE,contractual_week_hr=35, contractual_month_hr=151.67 WHERE working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_28');
  597. UPDATE working_schedule SET lm_name='PSI',lm_date=SYSDATE,contractual_week_hr=35, contractual_month_hr=151.67 WHERE working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_29');
  598. UPDATE working_schedule SET lm_name='PSI',lm_date=SYSDATE,contractual_week_hr=35, contractual_month_hr=151.67 WHERE working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_30');
  599. UPDATE working_schedule SET lm_name='PSI',lm_date=SYSDATE,contractual_week_hr=39, contractual_month_hr=169 WHERE working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_31');
  600. UPDATE working_schedule SET lm_name='PSI',lm_date=SYSDATE,contractual_week_hr=37, contractual_month_hr=160.33 WHERE working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_32');
  601. UPDATE working_schedule SET lm_name='PSI',lm_date=SYSDATE,contractual_week_hr=36, contractual_month_hr=156 WHERE working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_33');
  602. UPDATE working_schedule SET lm_name='PSI',lm_date=SYSDATE,contractual_week_hr=36, contractual_month_hr=156 WHERE working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_34');
  603. UPDATE working_schedule SET lm_name='PSI',lm_date=SYSDATE,contractual_week_hr=39, contractual_month_hr=169 WHERE working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_35');
  604. UPDATE working_schedule SET lm_name='PSI',lm_date=SYSDATE,contractual_week_hr=35, contractual_month_hr=151.67 WHERE working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_36');
  605. UPDATE working_schedule SET lm_name='PSI',lm_date=SYSDATE,contractual_week_hr=35, contractual_month_hr=151.67 WHERE working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_37');
  606. UPDATE working_schedule SET lm_name='PSI',lm_date=SYSDATE,contractual_week_hr=35, contractual_month_hr=151.67 WHERE working_schedule_id=(SELECT working_schedule_id FROM working_schedule WHERE vehicle_owner_id=111549 AND is_active='Y' AND working_schedule_type_code='HPR_38');
  607.  
  608. COMMIT;
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!