The example you show does not declare the variable types, for example:

DECLARE @l_deleted_status INT

I really dont know if this will make a difference but it might...