CREATE OR REPLACE TRIGGER td_inbound_pax
BEFORE DELETE ON inbound_pax
FOR EACH ROW
BEGIN

   /* delete all children in "inbound_bag" */
   DELETE
     FROM inbound_bag
    WHERE inbound_pax_id = :old.inbound_pax_id;

   /* delete all children in "inbound_pax_onward_dests" */
   DELETE
     FROM inbound_pax_onward_dests
    WHERE inbound_pax_id = :old.inbound_pax_id;

END;
/