would this work?

create or replace procedure delete_one_employee as

/*THIS SCRIPT DELETES AN ENTIRE EMPLOYEE'S "RECORD".
I.E. THE EMPLOYEE'S ROWS FROM ALL TABLES THAT
* HAVE AN EMPLOYEE_ID COLUMN.*/

BEGIN

delete from HRW_HEALTH_PLAN_DEPENDENTS where
health_plan_key in
(select health_plan_key from hrw_dependents where employee_id = '&&emp_id');

delete from HRW_INSURANCE_BENEFICIARIES where
insurance_key in
(select insurance_key from hrw_insurances where employee_id = '&&emp_id');

delete from HRW_INSURANCE_OFFERS where employee_id = '&&emp_id';
delete from HRW_MISC_OFFERS where employee_id = '&&emp_id';
delete from HRW_FLEX_SPEND_OFFERS where employee_id = '&&emp_id';

end;