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_AMORT_PVT dependencies on FA_DEPRN_PERIODS

Line 106: -- fa_deprn_periods, for all other cases, should call fazcdp to obtain period

102: -- Function: GetPeriodInfo
103: --
104: -- This function return period information.
105: -- The function should be called when period information is not available in
106: -- fa_deprn_periods, for all other cases, should call fazcdp to obtain period
107: -- information.
108: --+==============================================================================
109: FUNCTION GetPeriodInfo(
110: p_jdate NUMBER,

Line 128: from fa_deprn_periods

124: , calendar_period_open_date
125: , calendar_period_close_date
126: , fiscal_year
127: , period_num
128: from fa_deprn_periods
129: where book_type_code = p_book_type_code
130: and to_date (to_char (p_jdate), 'J') between calendar_period_open_date
131: and calendar_period_close_date;
132:

Line 142: from fa_deprn_periods_mrc_v

138: , calendar_period_open_date
139: , calendar_period_close_date
140: , fiscal_year
141: , period_num
142: from fa_deprn_periods_mrc_v
143: where book_type_code = p_book_type_code
144: and to_date (to_char (p_jdate), 'J') between calendar_period_open_date
145: and calendar_period_close_date;
146:

Line 3409: from fa_deprn_periods dp

3405:
3406: /* Following cursor is added by HHIRAGA for tracking */
3407: CURSOR c_get_current_period IS
3408: select dp.period_counter
3409: from fa_deprn_periods dp
3410: where dp.book_type_code = p_asset_hdr_rec.book_type_code
3411: and dp.period_close_date is null;
3412:
3413: CURSOR c_get_current_period_mrc IS

Line 3415: from fa_deprn_periods_mrc_v dp

3411: and dp.period_close_date is null;
3412:
3413: CURSOR c_get_current_period_mrc IS
3414: select dp.period_counter
3415: from fa_deprn_periods_mrc_v dp
3416: where dp.book_type_code = p_asset_hdr_rec.book_type_code
3417: and dp.period_close_date is null;
3418:
3419:

Line 7535: from fa_deprn_periods

7531: where asset_id = p_asset_hdr_rec.asset_id
7532: and book_type_code = p_asset_hdr_rec.book_type_code
7533: and period_counter <= p_period_rec.period_counter;
7534: /*
7535: from fa_deprn_periods
7536: where book_type_code = p_asset_hdr_rec.book_type_code
7537: and period_counter = p_period_rec.period_counter;
7538: */
7539:

Line 7548: , fa_deprn_periods dp

7544: , ds.ltd_production - ds.ytd_production
7545: , ds.reval_reserve - ds.ytd_reval_deprn_expense
7546: from fa_fiscal_year fy
7547: , fa_deprn_summary ds
7548: , fa_deprn_periods dp
7549: where ds.asset_id = p_asset_hdr_rec.asset_id
7550: and ds.book_type_code = p_asset_hdr_rec.book_type_code
7551: and ds.deprn_source_code = 'BOOKS'
7552: and dp.book_type_code = p_asset_hdr_rec.book_type_code

Line 7984: fa_deprn_periods dp,

7980: th.date_effective date_effective,
7981: th.transaction_type_code transaction_type_code
7982: from
7983: fa_transaction_headers th,
7984: fa_deprn_periods dp,
7985: fa_book_controls bc,
7986: fa_fiscal_year fy
7987: where th.asset_id = p_asset_hdr_rec.asset_id
7988: and th.book_type_code = p_asset_hdr_rec.book_type_code

Line 8005: , fa_deprn_periods dp2

8001: G_TRX_TYPE_REC, G_TRX_TYPE_UNIT_ADJ,
8002: G_TRX_TYPE_TFR_VOID)
8003: and not exists (select 1
8004: from fa_deprn_summary ds
8005: , fa_deprn_periods dp2
8006: where ds.asset_id = p_asset_hdr_rec.asset_id
8007: and ds.book_type_code = p_asset_hdr_rec.book_type_code
8008: and dp.book_type_code = p_asset_hdr_rec.book_type_code
8009: and dp.fiscal_year = fy.fiscal_year

Line 8105: from fa_deprn_periods

8101: select period_counter - 1
8102: , period_open_date
8103: , period_close_date
8104: , period_num
8105: from fa_deprn_periods
8106: where book_type_code = p_asset_hdr_rec.book_type_code
8107: and p_trans_rec.transaction_date_entered between
8108: calendar_period_open_date and calendar_period_close_date;
8109:

Line 8151: fa_deprn_periods dp,

8147: and transaction_header_id in
8148: -- Get reclassed transaction after this transaction's fiscal year
8149: (select th.member_transaction_header_id
8150: from fa_transaction_headers th,
8151: fa_deprn_periods dp,
8152: fa_fiscal_year fy,
8153: fa_book_controls bc
8154: where th.asset_id = p_asset_hdr_rec.asset_id
8155: and th.book_type_code = p_asset_hdr_rec.book_type_code

Line 11204: , fa_deprn_periods dp

11200:
11201: CURSOR c_get_deprn_period_date IS
11202: select dp.calendar_period_open_date
11203: from fa_deprn_summary ds
11204: , fa_deprn_periods dp
11205: where dp.book_type_code = p_asset_hdr_rec.book_type_code
11206: and ds.book_type_code = p_asset_hdr_rec.book_type_code
11207: and ds.asset_id = p_asset_hdr_rec.asset_id
11208: and ds.deprn_source_code = 'BOOKS'

Line 11264: , fa_deprn_periods dp

11260: ) transaction_date_entered,
11261: th.date_effective date_effective,
11262: th.transaction_type_code transaction_type_code
11263: from fa_transaction_headers th
11264: , fa_deprn_periods dp
11265: where th.asset_id = p_asset_hdr_rec.asset_id
11266: and th.book_type_code = p_asset_hdr_rec.book_type_code
11267: and dp.book_type_code = p_asset_hdr_rec.book_type_code
11268: -- and th.date_effective between dp.period_open_date

Line 11360: from fa_deprn_periods

11356: 1, decode(th.transaction_type_code,
11357: 'ADDITION', th.transaction_date_entered,
11358: 'ADDITION/VOID', th.transaction_date_entered,
11359: /* Japan Tax phase3 */ decode(th.transaction_key, 'ES', (select calendar_period_open_date
11360: from fa_deprn_periods
11361: where book_type_code = p_asset_hdr_rec.book_type_code
11362: and period_counter = bk.extended_depreciation_period),
11363: nvl(th.amortization_start_date,
11364: decode(th.transaction_subtype,

Line 11378: from fa_deprn_periods

11374: -- Bug# 4049799 bk.date_placed_in_service),
11375: px_asset_fin_rec_new.date_placed_in_service),
11376: th.transaction_date_entered)))),
11377: /* Japan Tax phase3 */decode(th.transaction_key, 'ES', (select calendar_period_open_date
11378: from fa_deprn_periods
11379: where book_type_code = p_asset_hdr_rec.book_type_code
11380: and period_counter = bk.extended_depreciation_period),
11381: nvl(th.amortization_start_date,
11382: decode(th.transaction_subtype,

Line 12046: fa_deprn_periods fdp

12042: th.transaction_date_entered,
12043: th.date_effective,
12044: th.transaction_type_code
12045: from fa_transaction_headers th,
12046: fa_deprn_periods fdp
12047: where th.asset_id = p_asset_hdr_rec.asset_id
12048: and th.book_type_code = p_asset_hdr_rec.book_type_code
12049: and fdp.book_type_code = p_asset_hdr_rec.book_type_code
12050: and th.date_effective between fdp.period_open_date and nvl(fdp.period_close_date,sysdate)

Line 13738: ,fa_deprn_periods dp

13734: declare
13735: cursor c_depreciate_flag is
13736: select bk.depreciate_flag
13737: from fa_books bk
13738: ,fa_deprn_periods dp
13739: where bk.asset_id = p_asset_hdr_rec.asset_id
13740: and bk.book_type_code = p_asset_hdr_rec.book_type_code
13741: and bk.date_effective <= nvl(dp.period_close_date, sysdate)
13742: and dp.book_type_code = p_asset_hdr_rec.book_type_code

Line 14902: fa_deprn_periods dp

14898: -- multiple backdate amortization enhancement - begin LSON
14899: cursor amort_date_before_add is
14900: select th.transaction_header_id
14901: from fa_transaction_headers th,
14902: fa_deprn_periods dp
14903: where th.book_type_code = p_asset_hdr_rec.book_type_code
14904: and th.asset_id = p_asset_hdr_rec.asset_id
14905: and th.transaction_type_code = 'ADDITION'
14906: and th.book_type_code = dp.book_type_code