postgresql7.4 SELECT uos_id FROM ct_degree_uos_map WHERE degree_id = :degree_id SELECT ga_id FROM ct_uos_ga_map WHERE uos_id = :uos_id SELECT ct_uos__del (:uos_id) DELETE FROM ct_degree_uos_map WHERE uos_id = :uos_id SELECT ct_ga__del (:ga_id) DELETE FROM ct_uos_ga_map WHERE ga_id = :ga_id SELECT ct_degree__del (:degree_id)