Getting multiplication of column values on a joined table based on condition
Here's how I solved it:

   SELECT PA.PAID_YEAR,PA.PAID_AMOUNT,EXP(SUM(LN(YR.RATE)))*PA.PAID_AMOUNT
     FROM YEARLY_RATES YR, PERSON_ACCOUNT PA
     WHERE YR.RATE_YEAR&gt;=PA.PAID_YEAR
     GROUP BY PA.PAID_YEAR,PA.PAID_AMOUNT


EXP(SUM(LN(YR.RATE)))  is just a trick to get the multiplication of the column values as there's no ready function available in Oracle.