create or replace procedure P_IB_CLIENT_AUTH_HISTORY as
begin

  INSERT INTO T_CLIENT_AUTH_HISTORY@HDW
  SELECT tis.start_date event_date,
             tiu.phone_number phone,
             tiu.cuid,
             CASE tis.device_id
               WHEN 'INTERNET' THEN
                'IB'
               ELSE
                'MB'
             END channel
        FROM hcbib.tbl_ib_session@hcbib tis
        LEFT JOIN hcbib.tbl_ib_user@hcbib tiu
          ON tiu.id = tis.user_id
         AND to_date(tis.start_date, 'DD/MM/YYYY') =
             to_date(sysdate - 1, 'DD/MM/YYYY');

  COMMIT;

end P_IB_CLIENT_AUTH_HISTORY;