-- ------------------------------------------------ LOADING OF DATA: load_conta
--                                                                1999.04.22 ft
update LOAD_CONTA set institute_id   = 0         where institute_id    is NULL;
update LOAD_CONTA set    person_id   = 0         where    person_id    is NULL;
update LOAD_CONTA set contact_type='*not filled' where contact_type    is NULL;
--
insert into CONTACT (entry_id, institute_id, person_id,              contact_type_id)
  select             entry_id, institute_id, person_id, CONTACT_TYPE.contact_type_id 
  from LOAD_CONTA,CONTACT_TYPE
 where CONTACT_TYPE.contact_type=LOAD_CONTA.contact_TYPE;
