[Home] [Help]
435: l_error_msg varchar2(2000);
436:
437: CURSOR prorate_convention_cur ( c_book_type_code IN VARCHAR2, c_asset_id IN NUMBER) IS
438: SELECT fcgd.retirement_prorate_convention
439: FROM fa_category_book_defaults fcgd,
440: fa_books fb,
441: fa_additions_b fa
442: WHERE fa.asset_id = c_asset_id
443: AND fb.asset_id = fa.asset_id