eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FA_CALC_DEPRN_BASIS2_PKG dependencies on FA_DEPRN_SUMMARY

Line 228: from fa_deprn_summary

224: h_set_of_books_id number; /*Bug# 6933726 to hold value of set_of_books_id for MRC */
225:
226: cursor GET_RESERVE is
227: select nvl(deprn_reserve,0), nvl(ytd_deprn,0)
228: from fa_deprn_summary
229: where asset_id = px_rule_in.asset_id
230: and period_counter = l_amort_period;
231:
232: cursor GET_RESERVE_M is

Line 234: from fa_deprn_summary_mrc_v

230: and period_counter = l_amort_period;
231:
232: cursor GET_RESERVE_M is
233: select nvl(deprn_reserve,0), nvl(ytd_deprn,0)
234: from fa_deprn_summary_mrc_v
235: where asset_id = px_rule_in.asset_id
236: and period_counter = l_amort_period;
237:
238: -- Replace original queries to cursors

Line 327: from fa_deprn_summary

323: -- Select reserve at Method Change (Reserve at the beginning of fy of Method Change)
324: cursor C_MTC_SUM (p_method_change_date date)
325: is
326: select nvl(deprn_reserve,0) - nvl(ytd_deprn,0)
327: from fa_deprn_summary
328: where book_type_code = px_rule_in.book_type_code
329: and asset_id = px_rule_in.asset_id
330: and period_counter =
331: (select period_counter

Line 340: from fa_deprn_summary_mrc_v

336:
337: cursor C_MTC_SUM_M (p_method_change_date date)
338: is
339: select nvl(deprn_reserve,0) - nvl(ytd_deprn,0)
340: from fa_deprn_summary_mrc_v
341: where book_type_code = px_rule_in.book_type_code
342: and asset_id = px_rule_in.asset_id
343: and period_counter =
344: (select period_counter

Line 410: FA_DEPRN_SUMMARY DS

406: nvl(sum(BK.salvage_value),0) fully_rsv_salvage_value,
407: nvl(sum(BK.recoverable_cost),0) fully_rsv_recoverable_cost,
408: nvl(sum(DS.deprn_reserve),0) fully_rsv_deprn_reserve
409: from FA_BOOKS BK,
410: FA_DEPRN_SUMMARY DS
411: where BK.ASSET_ID = DS.ASSET_ID
412: and BK.BOOK_TYPE_CODE = DS.BOOK_TYPE_CODE
413: and BK.PERIOD_COUNTER_FULLY_RESERVED = DS.PERIOD_COUNTER
414: and BK.GROUP_ASSET_ID = px_rule_in.asset_id

Line 428: FA_DEPRN_SUMMARY_MRC_V DS

424: nvl(sum(BK.salvage_value),0) fully_rsv_salvage_value,
425: nvl(sum(BK.recoverable_cost),0) fully_rsv_recoverable_cost,
426: nvl(sum(DS.deprn_reserve),0) fully_rsv_deprn_reserve
427: from FA_BOOKS_MRC_V BK,
428: FA_DEPRN_SUMMARY_MRC_V DS
429: where BK.ASSET_ID = DS.ASSET_ID
430: and BK.BOOK_TYPE_CODE = DS.BOOK_TYPE_CODE
431: and BK.PERIOD_COUNTER_FULLY_RESERVED = DS.PERIOD_COUNTER
432: and BK.GROUP_ASSET_ID = px_rule_in.asset_id