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)