DBA Data[Home] [Help]

APPS.CSE_ASSET_CREATION_PKG dependencies on FA_CATEGORY_BOOK_DEFAULTS

Line 3221: FROM fa_category_book_defaults fcgd

3217: AND book_type_code = c_book_type_code ;
3218:
3219: CURSOR prorate_convention_cur (c_book_type_code IN VARCHAR2, c_asset_id IN NUMBER) IS
3220: SELECT fcgd.retirement_prorate_convention
3221: FROM fa_category_book_defaults fcgd
3222: ,fa_books fb
3223: ,fa_additions_b fab
3224: WHERE fb.date_placed_in_service BETWEEN fcgd.start_dpis AND
3225: NVL(fcgd.end_dpis, fb.date_placed_in_service)