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 279: from fa_deprn_periods ap

275:
276: cursor C_AMORT_PERIOD
277: is
278: select ap.period_counter
279: from fa_deprn_periods ap
280: where ap.book_type_code = px_rule_in.book_type_code
281: and ap.calendar_period_open_date
282: <= trunc(px_rule_in.amortization_start_date)
283: and nvl(ap.calendar_period_close_date,sysdate)

Line 332: from fa_deprn_periods

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
332: from fa_deprn_periods
333: where book_type_code = px_rule_in.book_type_code
334: and calendar_period_open_date <= p_method_change_date
335: and nvl(calendar_period_close_date,sysdate) >= p_method_change_date);
336:

Line 345: from fa_deprn_periods

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
345: from fa_deprn_periods
346: where book_type_code = px_rule_in.book_type_code
347: and calendar_period_open_date <= p_method_change_date
348: and nvl(calendar_period_close_date,sysdate) >= p_method_change_date);
349:

Line 1248: fa_deprn_periods dp

1244: 'DR',adj.adjustment_amount,
1245: 'CR',-adj.adjustment_amount))),0) current_period_expense
1246: from fa_adjustments adj,
1247: fa_transaction_headers th,
1248: fa_deprn_periods dp
1249: where adj.asset_id = px_rule_in.asset_id
1250: and adj.book_type_code = px_rule_in.book_type_code
1251: and dp.book_type_code = px_rule_in.book_type_code
1252: and adj.transaction_header_id = th.transaction_header_id

Line 1266: fa_deprn_periods_mrc_v dp

1262: 'DR',adj.adjustment_amount,
1263: 'CR',-adj.adjustment_amount))),0) current_period_expense
1264: from fa_adjustments_mrc_v adj,
1265: fa_transaction_headers th,
1266: fa_deprn_periods_mrc_v dp
1267: where adj.asset_id = px_rule_in.asset_id
1268: and adj.book_type_code = px_rule_in.book_type_code
1269: and dp.book_type_code = px_rule_in.book_type_code
1270: and adj.transaction_header_id = th.transaction_header_id

Line 1608: FA_DEPRN_PERIODS DP,

1604: Cursor C_EOFY_RESERVE_RETIRED is
1605: select nvl(sum(RET.EOFY_RESERVE),0)
1606: from FA_RETIREMENTS RET,
1607: FA_TRANSACTION_HEADERS TH,
1608: FA_DEPRN_PERIODS DP,
1609: FA_FISCAL_YEAR FY,
1610: FA_BOOK_CONTROLS BC
1611: where RET.ASSET_ID= px_rule_in.asset_id
1612: and RET.BOOK_TYPE_CODE = px_rule_in.book_type_code

Line 1628: FA_DEPRN_PERIODS_MRC_V DP,

1624: Cursor C_EOFY_RESERVE_RETIRED_M is
1625: select nvl(sum(RET.EOFY_RESERVE),0)
1626: from FA_RETIREMENTS_MRC_V RET,
1627: FA_TRANSACTION_HEADERS TH,
1628: FA_DEPRN_PERIODS_MRC_V DP,
1629: FA_FISCAL_YEAR FY,
1630: FA_BOOK_CONTROLS_MRC_V BC
1631: where RET.ASSET_ID= px_rule_in.asset_id
1632: and RET.BOOK_TYPE_CODE = px_rule_in.book_type_code

Line 1648: FA_DEPRN_PERIODS DP,

1644: Cursor GP_EOFY_RESERVE_RETIRED is
1645: select nvl(sum(RET.EOFY_RESERVE),0)
1646: from FA_RETIREMENTS RET,
1647: FA_TRANSACTION_HEADERS TH,
1648: FA_DEPRN_PERIODS DP,
1649: FA_FISCAL_YEAR FY,
1650: FA_BOOK_CONTROLS BC
1651: where TH.ASSET_ID= px_rule_in.asset_id
1652: and TH.BOOK_TYPE_CODE = px_rule_in.book_type_code

Line 1674: FA_DEPRN_PERIODS_MRC_V DP,

1670: Cursor GP_EOFY_RESERVE_RETIRED_M is
1671: select nvl(sum(RET.EOFY_RESERVE),0)
1672: from FA_RETIREMENTS_MRC_V RET,
1673: FA_TRANSACTION_HEADERS TH,
1674: FA_DEPRN_PERIODS_MRC_V DP,
1675: FA_FISCAL_YEAR FY,
1676: FA_BOOK_CONTROLS_MRC_V BC
1677: where TH.ASSET_ID= px_rule_in.asset_id
1678: and TH.BOOK_TYPE_CODE = px_rule_in.book_type_code