DBA Data[Home] [Help]

APPS.FA_CALC_DEPRN_BASIS2_PKG dependencies on FA_DEPRN_SUMMARY

Line 265: from fa_deprn_summary

261: h_set_of_books_id number; /*Bug# 7462260 to hold value of set_of_books_id for MRC */
262:
263: cursor GET_RESERVE is
264: select nvl(deprn_reserve,0), nvl(ytd_deprn,0)
265: from fa_deprn_summary
266: where asset_id = px_rule_in.asset_id
267: and period_counter = l_amort_period;
268:
269: cursor GET_RESERVE_M is

Line 420: from fa_deprn_summary

416: -- Select reserve at Method Change (Reserve at the beginning of fy of Method Change)
417: cursor C_MTC_SUM (p_method_change_date date)
418: is
419: select nvl(deprn_reserve,0) - nvl(ytd_deprn,0)
420: from fa_deprn_summary
421: where book_type_code = px_rule_in.book_type_code
422: and asset_id = px_rule_in.asset_id
423: and period_counter =
424: (select period_counter

Line 433: from fa_deprn_summary

429:
430: cursor C_MTC_SUM_M (p_method_change_date date)
431: is
432: select nvl(deprn_reserve,0) - nvl(ytd_deprn,0)
433: from fa_deprn_summary
434: where book_type_code = px_rule_in.book_type_code
435: and asset_id = px_rule_in.asset_id
436: and period_counter =
437: (select period_counter

Line 504: FA_DEPRN_SUMMARY DS

500: nvl(sum(BK.salvage_value),0) fully_rsv_salvage_value,
501: nvl(sum(BK.recoverable_cost),0) fully_rsv_recoverable_cost,
502: nvl(sum(DS.deprn_reserve),0) fully_rsv_deprn_reserve
503: from FA_BOOKS BK,
504: FA_DEPRN_SUMMARY DS
505: where BK.ASSET_ID = DS.ASSET_ID
506: and BK.BOOK_TYPE_CODE = DS.BOOK_TYPE_CODE
507: and BK.PERIOD_COUNTER_FULLY_RESERVED = DS.PERIOD_COUNTER
508: and BK.GROUP_ASSET_ID = px_rule_in.asset_id