Post date: Nov 16, 2012 9:58:29 AM
/* Formatted on 2012/11/16 15:39 (Formatter Plus v4.8.8) */
SELECT fds.deprn_reserve, fds.deprn_amount, fds.ytd_deprn
FROM fa_deprn_summary fds
WHERE fds.book_type_code = 'PGN_KP'
AND fds.asset_id = '21496'
AND fds.period_counter =
(SELECT MAX (fds.period_counter)
FROM fa_deprn_periods fdp, fa_deprn_summary fds
WHERE fdp.book_type_code = 'PGN_KP'
AND fds.asset_id = '21496'
AND TO_DATE (fdp.period_name, 'MON-YY') <=
TO_DATE ('FEB-12', 'MON-YY')
AND fds.book_type_code = fdp.book_type_code
AND fds.period_counter = fdp.period_counter);