DBA Data[Home] [Help]

APPS.FA_CALC_DEPRN_BASIS2_PKG dependencies on FA_METHODS

Line 102: exclude salvage value flag will be checked for all JP-250DB methods in fa_methods*/

98: (px_rule_in.method_code like 'JP%') and
99: (NVL(px_rule_in.transaction_flag,'XX') <> 'JI')then
100:
101: /*Bug 9718441 added impairment reserve and salvage value. Added salvage vaue because from now on after phase5
102: exclude salvage value flag will be checked for all JP-250DB methods in fa_methods*/
103:
104: px_rule_out.new_adjusted_cost := px_rule_in.cost - ( px_rule_in.current_total_rsv - px_rule_in.current_total_ytd)
105: - NVL(px_rule_in.impairment_reserve,0) - NVL(px_rule_in.salvage_value,0);
106:

Line 298: from FA_BOOKS bk, FA_METHODS dm

294: nvl(bk.adjusted_recoverable_cost,0),
295: nvl(bk.cost,0),
296: nvl(bk.deprn_limit_type,'X'), -- Bug 12833731
297: nvl(bk.allowed_deprn_limit_amount,0) -- Bug 12833731
298: from FA_BOOKS bk, FA_METHODS dm
299: where bk.deprn_method_code = dm.method_code
300: and nvl(bk.life_in_months, 0) = nvl(dm.life_in_months,0)
301: and bk.asset_id = px_rule_in.asset_id
302: and bk.book_type_code = px_rule_in.book_type_code

Line 318: from FA_MC_BOOKS bk, FA_METHODS dm

314: nvl(bk.adjusted_recoverable_cost,0),
315: nvl(bk.cost,0),
316: nvl(bk.deprn_limit_type,'X'), -- Bug 12833731
317: nvl(bk.allowed_deprn_limit_amount,0) -- Bug 12833731
318: from FA_MC_BOOKS bk, FA_METHODS dm
319: where bk.deprn_method_code = dm.method_code
320: and nvl(bk.life_in_months, 0) = nvl(dm.life_in_months,0)
321: and bk.asset_id = px_rule_in.asset_id
322: and bk.book_type_code = px_rule_in.book_type_code

Line 339: from FA_BOOKS bk, FA_METHODS dm

335: nvl(bk.adjusted_recoverable_cost,0),
336: nvl(bk.cost,0),
337: nvl(bk.deprn_limit_type,'X'),
338: nvl(bk.allowed_deprn_limit_amount,0)
339: from FA_BOOKS bk, FA_METHODS dm
340: where bk.deprn_method_code = dm.method_code
341: and nvl(bk.life_in_months, 0) = nvl(dm.life_in_months,0)
342: and bk.asset_id = px_rule_in.asset_id
343: and bk.book_type_code = px_rule_in.book_type_code

Line 358: from FA_MC_BOOKS bk, FA_METHODS dm

354: nvl(bk.adjusted_recoverable_cost,0),
355: nvl(bk.cost,0),
356: nvl(bk.deprn_limit_type,'X'),
357: nvl(bk.allowed_deprn_limit_amount,0)
358: from FA_MC_BOOKS bk, FA_METHODS dm
359: where bk.deprn_method_code = dm.method_code
360: and nvl(bk.life_in_months, 0) = nvl(dm.life_in_months,0)
361: and bk.asset_id = px_rule_in.asset_id
362: and bk.book_type_code = px_rule_in.book_type_code

Line 387: fa_methods m

383: fa_books bk
384: where h.transaction_header_id =
385: (select max(transaction_header_id_out)
386: from fa_books b,
387: fa_methods m
388: where b.book_type_code = px_rule_in.book_type_code
389: and b.asset_id = px_rule_in.asset_id
390: and b.deprn_method_code = m.method_code
391: and m.deprn_basis_rule = 'NBV')

Line 405: fa_methods m

401: fa_mc_books bk
402: where h.transaction_header_id =
403: (select max(transaction_header_id_out)
404: from fa_mc_books b,
405: fa_methods m
406: where b.book_type_code = px_rule_in.book_type_code
407: and b.asset_id = px_rule_in.asset_id
408: and b.deprn_method_code = m.method_code
409: and b.set_of_books_id = px_rule_in.set_of_books_id