declare
    @vProgramaSaudeId int = 1;
begin

delete from
PROGRAMASAUDE_PARTICIPAACOES
where exists (
    select 1
    from PROGRAMASAUDE_PARTICIPANTE PP
    where PP.PROGRAMASAUDEID = @vProgramaSaudeId
    and PP.CHV = PARTICIPANTEID);

delete from
PROGRAMASAUDE_PARTICIPANTE
where PROGRAMASAUDEID = @vProgramaSaudeId;

end