305: reval_deprn_expense*p_split_factor
306: INTO l_asset_deprn_rec.ytd_deprn,
307: l_asset_deprn_rec.deprn_reserve,
308: l_asset_deprn_rec.reval_deprn_reserve
309: FROM okx_ast_dprtns_v
310: WHERE asset_id = p_asdt_rec.asset_id
311: AND book_type_code = p_asdt_rec.book_type_code
312: AND deprn_run_date = (SELECT max(deprn_run_date)
313: FROM okx_ast_dprtns_v
309: FROM okx_ast_dprtns_v
310: WHERE asset_id = p_asdt_rec.asset_id
311: AND book_type_code = p_asdt_rec.book_type_code
312: AND deprn_run_date = (SELECT max(deprn_run_date)
313: FROM okx_ast_dprtns_v
314: WHERE asset_id = p_asdt_rec.asset_id
315: AND book_type_code = p_asdt_rec.book_type_code);
316:
317: END IF;