DBA Data[Home] [Help]

APPS.CSE_ASSET_CREATION_PKG dependencies on FA_CATEGORY_BOOK_DEFAULTS

Line 3557: FROM fa_category_book_defaults fcgd

3553: AND book_type_code = c_book_type_code ;
3554:
3555: CURSOR prorate_convention_cur (c_book_type_code IN VARCHAR2, c_asset_id IN NUMBER) IS
3556: SELECT fcgd.retirement_prorate_convention
3557: FROM fa_category_book_defaults fcgd
3558: ,fa_books fb
3559: ,fa_additions_b fab
3560: WHERE fb.date_placed_in_service BETWEEN fcgd.start_dpis AND
3561: NVL(fcgd.end_dpis, fb.date_placed_in_service)