DBA Data[Home] [Help]

APPS.FA_MASSADD_CREATE_PKG dependencies on FA_CATEGORY_BOOK_DEFAULTS

Line 458: from fa_category_book_defaults CBD

454: set depreciate_flag =
455: (select decode(gt.asset_type
456: ,'EXPENSED','NO'
457: ,nvl(CBD.depreciate_flag, 'YES'))
458: from fa_category_book_defaults CBD
459: where CBD.book_type_code(+) = p_book_type_code
460: and CBD.category_id(+)= gt.asset_category_id
461: and p_def_dpis_dt between CBD.start_DPIS(+)
462: and nvl(CBD.end_DPIS(+),p_def_dpis_dt)),