DBA Data[Home] [Help]

APPS.FA_MASSADD_SPECIAL_PKG dependencies on FA_CATEGORY_BOOK_DEFAULTS

Line 142: FROM fa_category_book_defaults

138: /* Fix for bug 6597560 Starts here */
139: BEGIN
140: SELECT deprn_method,life_in_months
141: INTO l_method_code, l_life
142: FROM fa_category_book_defaults
143: WHERE book_type_code =p_mass_add_rec.book_type_code
144: AND category_id = p_mass_add_rec.asset_category_id
145: /* Fix for bug 6884668 Starts here */ -- When multiple defaults exist for different from-date to-date ranges, pick correct one based on DPIS
146: AND p_mass_add_rec.date_placed_in_service BETWEEN start_dpis AND NVL(end_dpis,p_mass_add_rec.date_placed_in_service + 1);