Advertisement
psi_mmobile

Untitled

Feb 28th, 2024
928
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 65.19 KB | None | 0 0
  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