1.declare @new_waiver_id int
exec uspInsert_Cwadoesp_waiver_requests 875118,0,2,0,1,0,0,0,0,0,0,'New York City Prevailing Wage Law : Pay rate is below required minimum pay rate for the position.',@new_waiver_id output
select @new_waiver_id as new_waiver_id
2.declare @temp_reg_hrs float ,@temp_ot_hrs float
exec tpweb_cwa_doe_get_order_total_hours 7,7,7,7,7,0,0,'09/16/2017','09/16/2017',@temp_reg_hrs output,@temp_ot_hrs output
select '@temp_reg_hrs'=@temp_reg_hrs,'@temp_ot_hrs'=@temp_ot_hrs
exec uspInsert_Cwadoesp_waiver_requests 875118,0,2,0,1,0,0,0,0,0,0,'New York City Prevailing Wage Law : Pay rate is below required minimum pay rate for the position.',@new_waiver_id output
select @new_waiver_id as new_waiver_id
2.declare @temp_reg_hrs float ,@temp_ot_hrs float
exec tpweb_cwa_doe_get_order_total_hours 7,7,7,7,7,0,0,'09/16/2017','09/16/2017',@temp_reg_hrs output,@temp_ot_hrs output
select '@temp_reg_hrs'=@temp_reg_hrs,'@temp_ot_hrs'=@temp_ot_hrs
No comments:
Post a Comment