DBA Data[Home] [Help]

APPS.FA_MASSADD_CREATE_PKG dependencies on FA_CATEGORY_BOOK_DEFAULTS

Line 1287: from fa_category_book_defaults CBD

1283: set depreciate_flag =
1284: (select decode(gt.asset_type
1285: ,'EXPENSED','NO'
1286: ,nvl(CBD.depreciate_flag, 'YES'))
1287: from fa_category_book_defaults CBD
1288: where CBD.book_type_code(+) = p_book_type_code
1289: and CBD.category_id(+)= gt.asset_category_id
1290: and p_def_dpis_dt between CBD.start_DPIS(+)
1291: and nvl(CBD.end_DPIS(+),p_def_dpis_dt)),