create or replace trigger delete_trigger1

after delete on contracting_party

 for each row

 begin

   if deleting then

    delete Account_Info

  where party_no=:old.party_no;

 end if;

end;

/

create or replace trigger delete_trigger2

after delete on contracting_party

  for each row

  begin

    if deleting then

     delete contracting_party_relation

    WHERE party_no=:old.party_no;

  end if;

end;