insert into MISSIONARY_SUB
Select
MISSIONARY_ID,SUPPORTER_ID,AMOUNT,CONTRIBUTION_DATE
from CONTRIBUTION
where UPPER(:P9_MISSIONARY_ID) = MISSIONARY_ID
and :P9_YEAR = to_number(to_char(CONTRIBUTION_DATE,'YYYY'))
order by SUPPORTER_ID,CONTRIBUTION_DATE;