'Zero out the participant\'s payment_instructions.'

def clear_payment_instructions(self, cursor):

    teams = cursor.all(u'\n\n                                                SELECT    (    SELECT    teams.*::teams\n                                                                                            FROM    teams\n                                                                                        WHERE    id=team_id\n                                                                                )    AS    team\n                                                        FROM    current_payment_instructions\n                                                    WHERE    participant_id    =    %s\n                                                            AND    amount    >    0\n\n                                ', (self.id,))
    for team in teams:
        self.set_payment_instruction(team, u'0.00', update_self=False, cursor=cursor)
