WHERE comptype='OWNER' LIMIT 1;
IF v_id != 0 THEN
RETURN CONCAT('DUPE - Company', in_name);
END IF;
WHERE comptype='OWNER' LIMIT 1;
IF v_id != 0 THEN
RETURN CONCAT('DUPE - Company', in_name);
END IF;
- INSERT INTO Companies (code, name, comptype, comptype_id) VALUES (
+ INSERT INTO core_company (code, name, comptype, comptype_id) VALUES (
in_code,in_name,'OWNER', core_enum_id_by_name('COMPTYPE', 'OWNER' )
);
in_code,in_name,'OWNER', core_enum_id_by_name('COMPTYPE', 'OWNER' )
);