/*
  Programador | Solicitação | Descrição
  Juliano     | 12845       | Configuração de ISS Conam e Cadastro de atividades para VÁRZEA PAULISTA
*/
UPDATE OR INSERT INTO VEF_BASE_TTIPOISS (BDCODTIPOISS, BDDESTIPOISS, BDFORMULARIO, BDCODINTTPISS) VALUES (23, 'Conam', NULL, 1);

EXECUTE PROCEDURE SP_COPIA_ATIVIDADES_MUNICIPAIS(5413);

UPDATE OR INSERT INTO VEF_BASE_TVINCULOISS (BDCODCID, BDREFVINCISS, BDCODTIPOISS, BDCODTIPOISSEXP, BDIMPVARARQ) VALUES (5413, 201501, 23, 6, 'FALSE');
UPDATE OR INSERT INTO VEF_BASE_TVINCULOISS (BDCODCID, BDREFVINCISS, BDCODTIPOISS, BDCODTIPOISSEXP, BDIMPVARARQ) VALUES (4836, 201501, 23, 6, 'FALSE');
UPDATE OR INSERT INTO VEF_BASE_TVINCULOISS (BDCODCID, BDREFVINCISS, BDCODTIPOISS, BDCODTIPOISSEXP, BDIMPVARARQ) VALUES (4845, 201501, 23, 6, 'FALSE');
UPDATE OR INSERT INTO VEF_BASE_TVINCULOISS (BDCODCID, BDREFVINCISS, BDCODTIPOISS, BDCODTIPOISSEXP, BDIMPVARARQ) VALUES (4855, 201501, 23, 6, 'FALSE');
UPDATE OR INSERT INTO VEF_BASE_TVINCULOISS (BDCODCID, BDREFVINCISS, BDCODTIPOISS, BDCODTIPOISSEXP, BDIMPVARARQ) VALUES (4872, 201501, 23, 6, 'FALSE');
UPDATE OR INSERT INTO VEF_BASE_TVINCULOISS (BDCODCID, BDREFVINCISS, BDCODTIPOISS, BDCODTIPOISSEXP, BDIMPVARARQ) VALUES (4873, 201501, 23, 6, 'FALSE');
UPDATE OR INSERT INTO VEF_BASE_TVINCULOISS (BDCODCID, BDREFVINCISS, BDCODTIPOISS, BDCODTIPOISSEXP, BDIMPVARARQ) VALUES (4878, 201501, 23, 6, 'FALSE');
UPDATE OR INSERT INTO VEF_BASE_TVINCULOISS (BDCODCID, BDREFVINCISS, BDCODTIPOISS, BDCODTIPOISSEXP, BDIMPVARARQ) VALUES (4946, 201501, 23, 6, 'FALSE');
UPDATE OR INSERT INTO VEF_BASE_TVINCULOISS (BDCODCID, BDREFVINCISS, BDCODTIPOISS, BDCODTIPOISSEXP, BDIMPVARARQ) VALUES (5033, 201501, 23, 6, 'FALSE');
UPDATE OR INSERT INTO VEF_BASE_TVINCULOISS (BDCODCID, BDREFVINCISS, BDCODTIPOISS, BDCODTIPOISSEXP, BDIMPVARARQ) VALUES (5218, 201501, 23, 6, 'FALSE');
UPDATE OR INSERT INTO VEF_BASE_TVINCULOISS (BDCODCID, BDREFVINCISS, BDCODTIPOISS, BDCODTIPOISSEXP, BDIMPVARARQ) VALUES (5223, 201501, 23, 6, 'FALSE');
UPDATE OR INSERT INTO VEF_BASE_TVINCULOISS (BDCODCID, BDREFVINCISS, BDCODTIPOISS, BDCODTIPOISSEXP, BDIMPVARARQ) VALUES (5367, 201501, 23, 6, 'FALSE');
UPDATE OR INSERT INTO VEF_BASE_TVINCULOISS (BDCODCID, BDREFVINCISS, BDCODTIPOISS, BDCODTIPOISSEXP, BDIMPVARARQ) VALUES (5383, 201501, 23, 6, 'FALSE');
UPDATE OR INSERT INTO VEF_BASE_TVINCULOISS (BDCODCID, BDREFVINCISS, BDCODTIPOISS, BDCODTIPOISSEXP, BDIMPVARARQ) VALUES (2180, 201501, 23, 6, 'FALSE');
UPDATE OR INSERT INTO VEF_BASE_TVINCULOISS (BDCODCID, BDREFVINCISS, BDCODTIPOISS, BDCODTIPOISSEXP, BDIMPVARARQ) VALUES (3641, 201501, 23, 6, 'FALSE');
UPDATE OR INSERT INTO VEF_BASE_TVINCULOISS (BDCODCID, BDREFVINCISS, BDCODTIPOISS, BDCODTIPOISSEXP, BDIMPVARARQ) VALUES (4959, 201501, 23, 6, 'FALSE');
COMMIT WORK;

