DBA Data[Home] [Help]

APPS.FA_CALC_DEPRN_BASIS2_PKG dependencies on FA_METHODS

Line 252: from FA_BOOKS bk, FA_METHODS dm

248: -- to fix bug 2303276
249: -----------------------------------------
250: nvl(bk.adjusted_recoverable_cost,0),
251: nvl(bk.cost,0)
252: from FA_BOOKS bk, FA_METHODS dm
253: where bk.deprn_method_code = dm.method_code
254: and nvl(bk.life_in_months, 0) = nvl(dm.life_in_months,0)
255: and bk.asset_id = px_rule_in.asset_id
256: and bk.book_type_code = px_rule_in.book_type_code

Line 269: from FA_BOOKS_MRC_V bk, FA_METHODS dm

265: dm.deprn_basis_rule,
266: dm.rate_source_rule,
267: nvl(bk.adjusted_recoverable_cost,0),
268: nvl(bk.cost,0)
269: from FA_BOOKS_MRC_V bk, FA_METHODS dm
270: where bk.deprn_method_code = dm.method_code
271: and nvl(bk.life_in_months, 0) = nvl(dm.life_in_months,0)
272: and bk.asset_id = px_rule_in.asset_id
273: and bk.book_type_code = px_rule_in.book_type_code

Line 296: fa_methods m

292: fa_books bk
293: where h.transaction_header_id =
294: (select max(transaction_header_id_out)
295: from fa_books b,
296: fa_methods m
297: where b.book_type_code = px_rule_in.book_type_code
298: and b.asset_id = px_rule_in.asset_id
299: and b.deprn_method_code = m.method_code
300: and m.deprn_basis_rule = 'NBV')

Line 314: fa_methods m

310: fa_books bk
311: where h.transaction_header_id =
312: (select max(transaction_header_id_out)
313: from fa_books_mrc_v b,
314: fa_methods m
315: where b.book_type_code = px_rule_in.book_type_code
316: and b.asset_id = px_rule_in.asset_id
317: and b.deprn_method_code = m.method_code
318: and m.deprn_basis_rule = 'NBV')