to give you a hint: have a look at:

select appln,
upddt-applndt as TotalDaysgone,
MONTHS_BETWEEN (upddt,applndt) as Totalmonthsgone,
trunc(MONTHS_BETWEEN (upddt,applndt)/12) as Yearsgone,
MONTHS_BETWEEN (upddt,applndt) - trunc(MONTHS_BETWEEN (upddt,applndt)/12)*12 as RestOfMonths,
trunc(MONTHS_BETWEEN (upddt,applndt) - trunc(MONTHS_BETWEEN (upddt,applndt)/12)*12) as Monthsgone
from test;

you could/would need the same nesting for days and hours etc.
personally I would rather write a stored procedure (or package) to achieve the same job.
rgds