API tools faq
paste
Advertisement
psi_mmobile

Untitled

psi_mmobile
Feb 28th, 2024
1,306
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 65.19 KB | None | 0 0
raw download clone embed print report
  1. SELECT
  2.     *
  3. FROM
  4.     vehicle_owner
  5. WHERE
  6.     company_name LIKE '%FAYAT%';--111549
  7.  
  8. SELECT
  9.     *
  10. FROM
  11.     working_schedule
  12. WHERE
  13.     vehicle_owner_id = 111549;
  14.  
  15. SELECT
  16.     *
  17. FROM
  18.     working_schedule_day
  19. WHERE
  20.     working_schedule_id = 120387;
  21.  
  22. INSERT INTO working_schedule (
  23.     working_schedule_id,
  24.     vehicle_owner_id,
  25.     name,
  26.     pause_min,
  27.     pause_morning_min,
  28.     pause_night_min,
  29.     min_hr_meal_allowance,
  30.     working_schedule_code,
  31.     working_schedule_type_code,
  32.     is_active,
  33.     order_num,
  34.     lm_name,
  35.     lm_date,
  36.     creation_date,
  37.     working_schedule_type_id,
  38.     erp_nbr_day_per_week
  39. ) VALUES (
  40.     seq_working_schedule_id.NEXTVAL,
  41.     111549,
  42.     'HPR_35',
  43.     0,
  44.     0,
  45.     0,
  46.     4,
  47.     'HPR_35',
  48.     'HPR_35',
  49.     'Y',
  50.     1034,
  51.     'PSI',
  52.     SYSDATE,
  53.     SYSDATE,
  54.     2,
  55.     5
  56. );
  57.  
  58. COMMIT;
  59.  
  60. INSERT INTO working_schedule_day (working_schedule_day_id,working_schedule_id,day_id,nbr_hr)
  61. VALUES (seq_working_schedule_day_id.NEXTVAL,120387,1,8);
  62. INSERT INTO working_schedule_day (working_schedule_day_id,working_schedule_id,day_id,nbr_hr)
  63. VALUES (seq_working_schedule_day_id.NEXTVAL,120387,2,8);
  64. INSERT INTO working_schedule_day (working_schedule_day_id,working_schedule_id,day_id,nbr_hr)
  65. VALUES (seq_working_schedule_day_id.NEXTVAL,120387,3,8);
  66. INSERT INTO working_schedule_day (working_schedule_day_id,working_schedule_id,day_id,nbr_hr)
  67. VALUES (seq_working_schedule_day_id.NEXTVAL,120387,4,8);
  68. INSERT INTO working_schedule_day (working_schedule_day_id,working_schedule_id,day_id,nbr_hr)
  69. VALUES (seq_working_schedule_day_id.NEXTVAL,120387,5,7);
  70. INSERT INTO working_schedule_day (working_schedule_day_id,working_schedule_id,day_id,nbr_hr)
  71. VALUES (seq_working_schedule_day_id.NEXTVAL,120387,6,0);
  72. INSERT INTO working_schedule_day (working_schedule_day_id,working_schedule_id,day_id,nbr_hr)
  73. VALUES (seq_working_schedule_day_id.NEXTVAL,120387,7,0);
  74.  
  75. UPDATE working_schedule SET contractual_week_hr=3,contractual_month_hr=13,erp_nbr_day_per_week=2,lm_name='PSI',lm_date=SYSDATE 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');
  76. UPDATE working_schedule SET contractual_week_hr=12,contractual_month_hr=52,erp_nbr_day_per_week=3,lm_name='PSI',lm_date=SYSDATE 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');
  77. UPDATE working_schedule SET contractual_week_hr=17.5,contractual_month_hr=75.83,erp_nbr_day_per_week=3,lm_name='PSI',lm_date=SYSDATE 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');
  78. UPDATE working_schedule SET contractual_week_hr=17.5,contractual_month_hr=75.83,erp_nbr_day_per_week=3,lm_name='PSI',lm_date=SYSDATE 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');
  79. UPDATE working_schedule SET contractual_week_hr=20,contractual_month_hr=86.67,erp_nbr_day_per_week=5,lm_name='PSI',lm_date=SYSDATE 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');
  80. UPDATE working_schedule SET contractual_week_hr=21,contractual_month_hr=91,erp_nbr_day_per_week=3,lm_name='PSI',lm_date=SYSDATE 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');
  81. UPDATE working_schedule SET contractual_week_hr=21,contractual_month_hr=91,erp_nbr_day_per_week=3,lm_name='PSI',lm_date=SYSDATE 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');
  82. UPDATE working_schedule SET contractual_week_hr=21,contractual_month_hr=91,erp_nbr_day_per_week=3,lm_name='PSI',lm_date=SYSDATE 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');
  83. UPDATE working_schedule SET contractual_week_hr=21,contractual_month_hr=91,erp_nbr_day_per_week=3,lm_name='PSI',lm_date=SYSDATE 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');
  84. UPDATE working_schedule SET contractual_week_hr=25,contractual_month_hr=108.33,erp_nbr_day_per_week=5,lm_name='PSI',lm_date=SYSDATE 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');
  85. UPDATE working_schedule SET contractual_week_hr=28,contractual_month_hr=121.33,erp_nbr_day_per_week=4,lm_name='PSI',lm_date=SYSDATE 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');
  86. UPDATE working_schedule SET contractual_week_hr=28,contractual_month_hr=121.33,erp_nbr_day_per_week=4,lm_name='PSI',lm_date=SYSDATE 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');
  87. UPDATE working_schedule SET contractual_week_hr=28,contractual_month_hr=121.33,erp_nbr_day_per_week=4,lm_name='PSI',lm_date=SYSDATE 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');
  88. UPDATE working_schedule SET contractual_week_hr=29,contractual_month_hr=125.67,erp_nbr_day_per_week=5,lm_name='PSI',lm_date=SYSDATE 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');
  89. UPDATE working_schedule SET contractual_week_hr=30,contractual_month_hr=130,erp_nbr_day_per_week=4,lm_name='PSI',lm_date=SYSDATE 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');
  90. UPDATE working_schedule SET contractual_week_hr=31,contractual_month_hr=134.33,erp_nbr_day_per_week=5,lm_name='PSI',lm_date=SYSDATE 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');
  91. UPDATE working_schedule SET contractual_week_hr=31,contractual_month_hr=134.33,erp_nbr_day_per_week=4,lm_name='PSI',lm_date=SYSDATE 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');
  92. UPDATE working_schedule SET contractual_week_hr=31,contractual_month_hr=134.33,erp_nbr_day_per_week=4,lm_name='PSI',lm_date=SYSDATE 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');
  93. UPDATE working_schedule SET contractual_week_hr=31.5,contractual_month_hr=136.5,erp_nbr_day_per_week=5,lm_name='PSI',lm_date=SYSDATE 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');
  94. UPDATE working_schedule SET contractual_week_hr=32,contractual_month_hr=138.67,erp_nbr_day_per_week=4,lm_name='PSI',lm_date=SYSDATE 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');
  95. UPDATE working_schedule SET contractual_week_hr=32,contractual_month_hr=138.67,erp_nbr_day_per_week=4,lm_name='PSI',lm_date=SYSDATE 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');
  96. UPDATE working_schedule SET contractual_week_hr=33,contractual_month_hr=142.92,erp_nbr_day_per_week=5,lm_name='PSI',lm_date=SYSDATE 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');
  97. UPDATE working_schedule SET contractual_week_hr=35,contractual_month_hr=151.67,erp_nbr_day_per_week=5,lm_name='PSI',lm_date=SYSDATE 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');
  98. UPDATE working_schedule SET contractual_week_hr=35,contractual_month_hr=151.67,erp_nbr_day_per_week=5,lm_name='PSI',lm_date=SYSDATE 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');
  99. UPDATE working_schedule SET contractual_week_hr=35,contractual_month_hr=151.67,erp_nbr_day_per_week=5,lm_name='PSI',lm_date=SYSDATE 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');
  100. UPDATE working_schedule SET contractual_week_hr=35,contractual_month_hr=151.67,erp_nbr_day_per_week=5,lm_name='PSI',lm_date=SYSDATE 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');
  101. UPDATE working_schedule SET contractual_week_hr=35,contractual_month_hr=151.67,erp_nbr_day_per_week=5,lm_name='PSI',lm_date=SYSDATE 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');
  102. UPDATE working_schedule SET contractual_week_hr=35,contractual_month_hr=151.67,erp_nbr_day_per_week=4,lm_name='PSI',lm_date=SYSDATE 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');
  103. UPDATE working_schedule SET contractual_week_hr=35,contractual_month_hr=151.67,erp_nbr_day_per_week=4,lm_name='PSI',lm_date=SYSDATE 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');
  104. UPDATE working_schedule SET contractual_week_hr=35,contractual_month_hr=151.67,erp_nbr_day_per_week=4,lm_name='PSI',lm_date=SYSDATE 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');
  105. UPDATE working_schedule SET contractual_week_hr=39,contractual_month_hr=169,erp_nbr_day_per_week=4,lm_name='PSI',lm_date=SYSDATE 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');
  106. UPDATE working_schedule SET contractual_week_hr=37,contractual_month_hr=160.33,erp_nbr_day_per_week=5,lm_name='PSI',lm_date=SYSDATE 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');
  107. UPDATE working_schedule SET contractual_week_hr=36,contractual_month_hr=156,erp_nbr_day_per_week=5,lm_name='PSI',lm_date=SYSDATE 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');
  108. UPDATE working_schedule SET contractual_week_hr=36,contractual_month_hr=156,erp_nbr_day_per_week=5,lm_name='PSI',lm_date=SYSDATE 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');
  109. UPDATE working_schedule SET contractual_week_hr=39,contractual_month_hr=169,erp_nbr_day_per_week=5,lm_name='PSI',lm_date=SYSDATE 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');
  110. // UPDATE mondays
  111. UPDATE working_schedule_day SET nbr_hr=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');
  112. UPDATE working_schedule_day SET nbr_hr=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');
  113. UPDATE working_schedule_day SET nbr_hr=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_03');
  114. UPDATE working_schedule_day SET nbr_hr=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_04');
  115. UPDATE working_schedule_day SET nbr_hr=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');
  116. UPDATE working_schedule_day SET nbr_hr=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_06');
  117. UPDATE working_schedule_day SET nbr_hr=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');
  118. UPDATE working_schedule_day SET nbr_hr=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');
  119. UPDATE working_schedule_day SET nbr_hr=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');
  120. UPDATE working_schedule_day SET nbr_hr=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');
  121. UPDATE working_schedule_day SET nbr_hr=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_11');
  122. UPDATE working_schedule_day SET nbr_hr=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');
  123. UPDATE working_schedule_day SET nbr_hr=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_13');
  124. UPDATE working_schedule_day SET nbr_hr=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');
  125. UPDATE working_schedule_day SET nbr_hr=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_15');
  126. UPDATE working_schedule_day SET nbr_hr=6.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');
  127. UPDATE working_schedule_day SET nbr_hr=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_17');
  128. UPDATE working_schedule_day SET nbr_hr=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_18');
  129. UPDATE working_schedule_day SET nbr_hr=6.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');
  130. UPDATE working_schedule_day SET nbr_hr=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_20');
  131. UPDATE working_schedule_day SET nbr_hr=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_21');
  132. UPDATE working_schedule_day SET nbr_hr=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_22');
  133. UPDATE working_schedule_day SET nbr_hr=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_23');
  134. UPDATE working_schedule_day SET nbr_hr=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');
  135. UPDATE working_schedule_day SET nbr_hr=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_25');
  136. UPDATE working_schedule_day SET nbr_hr=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_26');
  137. UPDATE working_schedule_day SET nbr_hr=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_27');
  138. UPDATE working_schedule_day SET nbr_hr=9 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');
  139. UPDATE working_schedule_day SET nbr_hr=8.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');
  140. UPDATE working_schedule_day SET nbr_hr=8.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');
  141. UPDATE working_schedule_day SET nbr_hr=10 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');
  142. UPDATE working_schedule_day SET nbr_hr=7.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_32');
  143. UPDATE working_schedule_day SET nbr_hr=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_33');
  144. UPDATE working_schedule_day SET nbr_hr=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_34');
  145. UPDATE working_schedule_day SET nbr_hr=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_35');
  146.  
  147. // UPDATE tuesdays
  148. UPDATE working_schedule_day SET nbr_hr=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');
  149. UPDATE working_schedule_day SET nbr_hr=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');
  150. UPDATE working_schedule_day SET nbr_hr=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_03');
  151. UPDATE working_schedule_day SET nbr_hr=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_04');
  152. UPDATE working_schedule_day SET nbr_hr=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');
  153. UPDATE working_schedule_day SET nbr_hr=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_06');
  154. UPDATE working_schedule_day SET nbr_hr=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_07');
  155. UPDATE working_schedule_day SET nbr_hr=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_08');
  156. UPDATE working_schedule_day SET nbr_hr=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');
  157. UPDATE working_schedule_day SET nbr_hr=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');
  158. UPDATE working_schedule_day SET nbr_hr=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_11');
  159. UPDATE working_schedule_day SET nbr_hr=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_12');
  160. UPDATE working_schedule_day SET nbr_hr=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_13');
  161. UPDATE working_schedule_day SET nbr_hr=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');
  162. UPDATE working_schedule_day SET nbr_hr=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_15');
  163. UPDATE working_schedule_day SET nbr_hr=6.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');
  164. UPDATE working_schedule_day SET nbr_hr=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');
  165. UPDATE working_schedule_day SET nbr_hr=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_18');
  166. UPDATE working_schedule_day SET nbr_hr=6.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');
  167. UPDATE working_schedule_day SET nbr_hr=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_20');
  168. UPDATE working_schedule_day SET nbr_hr=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_21');
  169. UPDATE working_schedule_day SET nbr_hr=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_22');
  170. UPDATE working_schedule_day SET nbr_hr=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_23');
  171. UPDATE working_schedule_day SET nbr_hr=9 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');
  172. UPDATE working_schedule_day SET nbr_hr=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_25');
  173. UPDATE working_schedule_day SET nbr_hr=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_26');
  174. UPDATE working_schedule_day SET nbr_hr=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_27');
  175. UPDATE working_schedule_day SET nbr_hr=9 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');
  176. UPDATE working_schedule_day SET nbr_hr=8.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');
  177. UPDATE working_schedule_day SET nbr_hr=8.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');
  178. UPDATE working_schedule_day SET nbr_hr=10 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');
  179. UPDATE working_schedule_day SET nbr_hr=7.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_32');
  180. UPDATE working_schedule_day SET nbr_hr=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_33');
  181. UPDATE working_schedule_day SET nbr_hr=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_34');
  182. UPDATE working_schedule_day SET nbr_hr=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_35');
  183.  
  184. // UPDATE wednesdays
  185. UPDATE working_schedule_day SET nbr_hr=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');
  186. UPDATE working_schedule_day SET nbr_hr=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');
  187. UPDATE working_schedule_day SET nbr_hr=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');
  188. UPDATE working_schedule_day SET nbr_hr=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');
  189. UPDATE working_schedule_day SET nbr_hr=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');
  190. UPDATE working_schedule_day SET nbr_hr=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_06');
  191. UPDATE working_schedule_day SET nbr_hr=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_07');
  192. UPDATE working_schedule_day SET nbr_hr=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');
  193. UPDATE working_schedule_day SET nbr_hr=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_09');
  194. UPDATE working_schedule_day SET nbr_hr=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');
  195. UPDATE working_schedule_day SET nbr_hr=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');
  196. UPDATE working_schedule_day SET nbr_hr=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_12');
  197. UPDATE working_schedule_day SET nbr_hr=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_13');
  198. UPDATE working_schedule_day SET nbr_hr=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');
  199. UPDATE working_schedule_day SET nbr_hr=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');
  200. UPDATE working_schedule_day SET nbr_hr=6.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');
  201. UPDATE working_schedule_day SET nbr_hr=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_17');
  202. UPDATE working_schedule_day SET nbr_hr=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');
  203. UPDATE working_schedule_day SET nbr_hr=6.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');
  204. UPDATE working_schedule_day SET nbr_hr=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_20');
  205. UPDATE working_schedule_day SET nbr_hr=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=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=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_23');
  208. UPDATE working_schedule_day SET nbr_hr=9 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');
  209. UPDATE working_schedule_day SET nbr_hr=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');
  210. UPDATE working_schedule_day SET nbr_hr=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');
  211. UPDATE working_schedule_day SET nbr_hr=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_27');
  212. UPDATE working_schedule_day SET nbr_hr=9 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');
  213. UPDATE working_schedule_day SET nbr_hr=8.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');
  214. UPDATE working_schedule_day SET nbr_hr=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');
  215. UPDATE working_schedule_day SET nbr_hr=10 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');
  216. UPDATE working_schedule_day SET nbr_hr=7.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_32');
  217. UPDATE working_schedule_day SET nbr_hr=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_33');
  218. UPDATE working_schedule_day SET nbr_hr=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');
  219. UPDATE working_schedule_day SET nbr_hr=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_35');
  220.  
  221. // UPDATE thursdays
  222. UPDATE working_schedule_day SET nbr_hr=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');
  223. UPDATE working_schedule_day SET nbr_hr=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');
  224. UPDATE working_schedule_day SET nbr_hr=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');
  225. UPDATE working_schedule_day SET nbr_hr=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');
  226. UPDATE working_schedule_day SET nbr_hr=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');
  227. UPDATE working_schedule_day SET nbr_hr=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');
  228. UPDATE working_schedule_day SET nbr_hr=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_07');
  229. UPDATE working_schedule_day SET nbr_hr=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_08');
  230. UPDATE working_schedule_day SET nbr_hr=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_09');
  231. UPDATE working_schedule_day SET nbr_hr=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');
  232. UPDATE working_schedule_day SET nbr_hr=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_11');
  233. UPDATE working_schedule_day SET nbr_hr=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_12');
  234. UPDATE working_schedule_day SET nbr_hr=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_13');
  235. UPDATE working_schedule_day SET nbr_hr=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');
  236. UPDATE working_schedule_day SET nbr_hr=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_15');
  237. UPDATE working_schedule_day SET nbr_hr=6.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');
  238. UPDATE working_schedule_day SET nbr_hr=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_17');
  239. UPDATE working_schedule_day SET nbr_hr=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_18');
  240. UPDATE working_schedule_day SET nbr_hr=6.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');
  241. UPDATE working_schedule_day SET nbr_hr=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_20');
  242. UPDATE working_schedule_day SET nbr_hr=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_21');
  243. UPDATE working_schedule_day SET nbr_hr=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_22');
  244. UPDATE working_schedule_day SET nbr_hr=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_23');
  245. UPDATE working_schedule_day SET nbr_hr=9 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');
  246. UPDATE working_schedule_day SET nbr_hr=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_25');
  247. UPDATE working_schedule_day SET nbr_hr=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_26');
  248. UPDATE working_schedule_day SET nbr_hr=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_27');
  249. UPDATE working_schedule_day SET nbr_hr=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_28');
  250. UPDATE working_schedule_day SET nbr_hr=8.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');
  251. UPDATE working_schedule_day SET nbr_hr=8.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');
  252. UPDATE working_schedule_day SET nbr_hr=9 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');
  253. UPDATE working_schedule_day SET nbr_hr=7.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_32');
  254. UPDATE working_schedule_day SET nbr_hr=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_33');
  255. UPDATE working_schedule_day SET nbr_hr=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_34');
  256. UPDATE working_schedule_day SET nbr_hr=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_35');
  257.  
  258. // UPDATE fridays
  259. UPDATE working_schedule_day SET nbr_hr=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');
  260. UPDATE working_schedule_day SET nbr_hr=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');
  261. UPDATE working_schedule_day SET nbr_hr=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');
  262. UPDATE working_schedule_day SET nbr_hr=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');
  263. UPDATE working_schedule_day SET nbr_hr=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');
  264. UPDATE working_schedule_day SET nbr_hr=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');
  265. UPDATE working_schedule_day SET nbr_hr=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');
  266. UPDATE working_schedule_day SET nbr_hr=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_08');
  267. UPDATE working_schedule_day SET nbr_hr=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_09');
  268. UPDATE working_schedule_day SET nbr_hr=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');
  269. UPDATE working_schedule_day SET nbr_hr=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_11');
  270. UPDATE working_schedule_day SET nbr_hr=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');
  271. UPDATE working_schedule_day SET nbr_hr=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');
  272. UPDATE working_schedule_day SET nbr_hr=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');
  273. UPDATE working_schedule_day SET nbr_hr=6 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');
  274. UPDATE working_schedule_day SET nbr_hr=6 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');
  275. UPDATE working_schedule_day SET nbr_hr=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_17');
  276. UPDATE working_schedule_day SET nbr_hr=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_18');
  277. UPDATE working_schedule_day SET nbr_hr=5.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');
  278. UPDATE working_schedule_day SET nbr_hr=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');
  279. UPDATE working_schedule_day SET nbr_hr=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_21');
  280. UPDATE working_schedule_day SET nbr_hr=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_22');
  281. UPDATE working_schedule_day SET nbr_hr=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_23');
  282. UPDATE working_schedule_day SET nbr_hr=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');
  283. UPDATE working_schedule_day SET nbr_hr=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_25');
  284. UPDATE working_schedule_day SET nbr_hr=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_26');
  285. UPDATE working_schedule_day SET nbr_hr=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');
  286. UPDATE working_schedule_day SET nbr_hr=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');
  287. UPDATE working_schedule_day SET nbr_hr=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');
  288. UPDATE working_schedule_day SET nbr_hr=8.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');
  289. UPDATE working_schedule_day SET nbr_hr=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');
  290. UPDATE working_schedule_day SET nbr_hr=7.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_32');
  291. UPDATE working_schedule_day SET nbr_hr=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');
  292. UPDATE working_schedule_day SET nbr_hr=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_34');
  293. UPDATE working_schedule_day SET nbr_hr=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_35');
  294.  
  295. // UPDATE saturdays
  296.  
  297. UPDATE working_schedule_day SET nbr_hr=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');
  298. UPDATE working_schedule_day SET nbr_hr=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');
  299. UPDATE working_schedule_day SET nbr_hr=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');
  300. UPDATE working_schedule_day SET nbr_hr=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');
  301. UPDATE working_schedule_day SET nbr_hr=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');
  302. UPDATE working_schedule_day SET nbr_hr=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');
  303. UPDATE working_schedule_day SET nbr_hr=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');
  304. UPDATE working_schedule_day SET nbr_hr=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');
  305. UPDATE working_schedule_day SET nbr_hr=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');
  306. UPDATE working_schedule_day SET nbr_hr=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');
  307. UPDATE working_schedule_day SET nbr_hr=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');
  308. UPDATE working_schedule_day SET nbr_hr=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');
  309. UPDATE working_schedule_day SET nbr_hr=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');
  310. UPDATE working_schedule_day SET nbr_hr=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');
  311. UPDATE working_schedule_day SET nbr_hr=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');
  312. UPDATE working_schedule_day SET nbr_hr=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');
  313. UPDATE working_schedule_day SET nbr_hr=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');
  314. UPDATE working_schedule_day SET nbr_hr=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');
  315. UPDATE working_schedule_day SET nbr_hr=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');
  316. UPDATE working_schedule_day SET nbr_hr=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');
  317. UPDATE working_schedule_day SET nbr_hr=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');
  318. UPDATE working_schedule_day SET nbr_hr=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');
  319. UPDATE working_schedule_day SET nbr_hr=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');
  320. UPDATE working_schedule_day SET nbr_hr=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');
  321. UPDATE working_schedule_day SET nbr_hr=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');
  322. UPDATE working_schedule_day SET nbr_hr=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');
  323. UPDATE working_schedule_day SET nbr_hr=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');
  324. UPDATE working_schedule_day SET nbr_hr=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');
  325. UPDATE working_schedule_day SET nbr_hr=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');
  326. UPDATE working_schedule_day SET nbr_hr=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');
  327. UPDATE working_schedule_day SET nbr_hr=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');
  328. UPDATE working_schedule_day SET nbr_hr=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');
  329. UPDATE working_schedule_day SET nbr_hr=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');
  330. UPDATE working_schedule_day SET nbr_hr=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');
  331. UPDATE working_schedule_day SET nbr_hr=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');
  332.  
  333. // UPDATE sundays
  334. UPDATE working_schedule_day SET nbr_hr=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');
  335. UPDATE working_schedule_day SET nbr_hr=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');
  336. UPDATE working_schedule_day SET nbr_hr=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');
  337. UPDATE working_schedule_day SET nbr_hr=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');
  338. UPDATE working_schedule_day SET nbr_hr=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');
  339. UPDATE working_schedule_day SET nbr_hr=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');
  340. UPDATE working_schedule_day SET nbr_hr=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');
  341. UPDATE working_schedule_day SET nbr_hr=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');
  342. UPDATE working_schedule_day SET nbr_hr=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');
  343. UPDATE working_schedule_day SET nbr_hr=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');
  344. UPDATE working_schedule_day SET nbr_hr=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');
  345. UPDATE working_schedule_day SET nbr_hr=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');
  346. UPDATE working_schedule_day SET nbr_hr=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');
  347. UPDATE working_schedule_day SET nbr_hr=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');
  348. UPDATE working_schedule_day SET nbr_hr=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');
  349. UPDATE working_schedule_day SET nbr_hr=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');
  350. UPDATE working_schedule_day SET nbr_hr=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');
  351. UPDATE working_schedule_day SET nbr_hr=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');
  352. UPDATE working_schedule_day SET nbr_hr=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');
  353. UPDATE working_schedule_day SET nbr_hr=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');
  354. UPDATE working_schedule_day SET nbr_hr=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');
  355. UPDATE working_schedule_day SET nbr_hr=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');
  356. UPDATE working_schedule_day SET nbr_hr=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');
  357. UPDATE working_schedule_day SET nbr_hr=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');
  358. UPDATE working_schedule_day SET nbr_hr=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');
  359. UPDATE working_schedule_day SET nbr_hr=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');
  360. UPDATE working_schedule_day SET nbr_hr=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');
  361. UPDATE working_schedule_day SET nbr_hr=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');
  362. UPDATE working_schedule_day SET nbr_hr=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');
  363. UPDATE working_schedule_day SET nbr_hr=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');
  364. UPDATE working_schedule_day SET nbr_hr=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');
  365. UPDATE working_schedule_day SET nbr_hr=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');
  366. UPDATE working_schedule_day SET nbr_hr=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');
  367. UPDATE working_schedule_day SET nbr_hr=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');
  368. UPDATE working_schedule_day SET nbr_hr=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');
  369.  
  370.  
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!