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_PERIODS

Line 370: from fa_deprn_periods ap

366:
367: cursor C_AMORT_PERIOD
368: is
369: select ap.period_counter
370: from fa_deprn_periods ap
371: where ap.book_type_code = px_rule_in.book_type_code
372: and ap.calendar_period_open_date
373: <= trunc(px_rule_in.amortization_start_date)
374: and nvl(ap.calendar_period_close_date,sysdate)

Line 425: from fa_deprn_periods

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
425: from fa_deprn_periods
426: where book_type_code = px_rule_in.book_type_code
427: and calendar_period_open_date <= p_method_change_date
428: and nvl(calendar_period_close_date,sysdate) >= p_method_change_date);
429:

Line 438: from fa_deprn_periods

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
438: from fa_deprn_periods
439: where book_type_code = px_rule_in.book_type_code
440: and calendar_period_open_date <= p_method_change_date
441: and nvl(calendar_period_close_date,sysdate) >= p_method_change_date);
442:

Line 1428: fa_deprn_periods dp

1424: 'DR',adj.adjustment_amount,
1425: 'CR',-adj.adjustment_amount))),0) current_period_expense
1426: from fa_adjustments adj,
1427: fa_transaction_headers th,
1428: fa_deprn_periods dp
1429: where adj.asset_id = px_rule_in.asset_id
1430: and adj.book_type_code = px_rule_in.book_type_code
1431: and dp.book_type_code = px_rule_in.book_type_code
1432: and adj.transaction_header_id = th.transaction_header_id

Line 1780: FA_DEPRN_PERIODS DP,

1776: Cursor C_EOFY_RESERVE_RETIRED is
1777: select nvl(sum(RET.EOFY_RESERVE),0)
1778: from FA_RETIREMENTS RET,
1779: FA_TRANSACTION_HEADERS TH,
1780: FA_DEPRN_PERIODS DP,
1781: FA_FISCAL_YEAR FY,
1782: FA_BOOK_CONTROLS BC
1783: where RET.ASSET_ID= px_rule_in.asset_id
1784: and RET.BOOK_TYPE_CODE = px_rule_in.book_type_code

Line 1825: FA_DEPRN_PERIODS DP,

1821: Cursor GP_EOFY_RESERVE_RETIRED is
1822: select nvl(sum(RET.EOFY_RESERVE),0)
1823: from FA_RETIREMENTS RET,
1824: FA_TRANSACTION_HEADERS TH,
1825: FA_DEPRN_PERIODS DP,
1826: FA_FISCAL_YEAR FY,
1827: FA_BOOK_CONTROLS BC
1828: where TH.ASSET_ID= px_rule_in.asset_id
1829: and TH.BOOK_TYPE_CODE = px_rule_in.book_type_code