I'm trying to use as select statment in a trigger to get info into another table when an update occurs on the table with the trigger, along with a couple constants. I can't get the pl/sql to work, any ideas on what I'm doing wrong? Thanks.

if (updating and ld.term_date <> :new.term_date) then
insert into employee_change (company, employee, emp_status, first_name, last_name, middle_init, nick_name, birthdate, sex, adj_hire_date, date_hired, wk_phone_nbr, wk_phone_ext, pager, email_address, term_date, typeofchange, change_dt, field_changed )
values (SELECT a.company,
a.employee,
a.EMP_STATUS,
a.FIRST_NAME,
a.LAST_NAME,
a.MIDDLE_INIT,
a.NICK_NAME,
test.PAEMPLOYEE.BIRTHDATE,
test.PAEMPLOYEE.SEX,
a.ADJ_HIRE_DATE,
a.DATE_HIRED,
test.PAEMPLOYEE.WK_PHONE_NBR,
test.PAEMPLOYEE.WK_PHONE_EXT,
test.hrcontnbr.PHONE AS Pager,
a.EMAIL_ADDRESS,
a.term_date
FROM test.EMPLOYEE a JOIN test.PAEMPLOYEE ON a.COMPANY = test.PAEMPLOYEE.COMPANY AND a.EMPLOYEE=test.PAEMPLOYEE.EMPLOYEE
left outer join test.HRCONTNBR on a.company = test.HRCONTNBR.COMPANY AND a.EMPLOYEE = test.HRCONTNBR.ID_NBR, 'U', sysdate, 'term_date');
end if;