Hi, I'm getting a "PLS-00402: alias required in SELECT list of cursor
to avoid duplicate column names" error when every single one of the
field in the SELECT clause have been aliased.

CURSOR
TREATMENT_CUR is

SELECT  t.treatment_procedure_id as treatment_procedure_id,
r.record_id as record_id,
tr.previous_flag as previous_flag,
c.primary_site as primary_site,
r.record_id as record_id,
r.major_record_subtype as major_record_subtype,
r.rx_hosp_screen_bx_proc1 as rx_hosp_screen_bx_proc1,
r.rx_hosp_screen_bx_proc2 as rx_hosp_screen_bx_proc2,
r.rx_hosp_screen_bx_proc3 as rx_hosp_screen_bx_proc3,
r.rx_hosp_screen_bx_proc4 as rx_hosp_screen_bx_proc4
FROM treatment_procedure t JOIN
treatment_procedure_registry tr ON (t.treatment_procedure_id =
tr.treatment_procedure_id)
JOIN
course cr ON (t.course_id = cr.course_id)
JOIN
ctc c ON (c.ctc_id = cr.ctc_id)
LEFT OUTER JOIN
record r on (t.record_id = r.record_id)
WHERE c.date_of_diagnosis_yyyy >= 1998;

Can someone please tell me what did I do wrong to cause the error?
I'm running Oracle 10g on SLES 9 (service pack 1), if this is relevent