[Home] [Help]
300: , least(fii.end_date+86399/86400, m.the_date) aging_date
301: , fii.start_date
302: , fii.end_date
303: , rank() over (partition by m.id order by fii.start_date desc ) rnk
304: from fii_time_ent_period fii
305: , (select
306: id
307: , case
308: when id = 10 then FII_TIME_API.ent_sd_lysper_end(l_collect_to_date_trunc)+86399/86400