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 142: -- fa_deprn_periods, for all other cases, should call fazcdp to obtain period

138: -- Function: GetPeriodInfo
139: --
140: -- This function return period information.
141: -- The function should be called when period information is not available in
142: -- fa_deprn_periods, for all other cases, should call fazcdp to obtain period
143: -- information.
144: --+==============================================================================
145: FUNCTION GetPeriodInfo(
146: p_jdate NUMBER,

Line 165: from fa_deprn_periods

161: , calendar_period_open_date
162: , calendar_period_close_date
163: , fiscal_year
164: , period_num
165: from fa_deprn_periods
166: where book_type_code = p_book_type_code
167: and to_date (to_char (p_jdate), 'J') between calendar_period_open_date
168: and calendar_period_close_date;
169:

Line 3435: from fa_deprn_periods dp

3431:
3432: /* Following cursor is added by HHIRAGA for tracking */
3433: CURSOR c_get_current_period IS
3434: select dp.period_counter
3435: from fa_deprn_periods dp
3436: where dp.book_type_code = p_asset_hdr_rec.book_type_code
3437: and dp.period_close_date is null;
3438:
3439: CURSOR c_get_current_period_mrc IS

Line 7638: from fa_deprn_periods

7634: where asset_id = p_asset_hdr_rec.asset_id
7635: and book_type_code = p_asset_hdr_rec.book_type_code
7636: and period_counter <= p_period_rec.period_counter;
7637: /*
7638: from fa_deprn_periods
7639: where book_type_code = p_asset_hdr_rec.book_type_code
7640: and period_counter = p_period_rec.period_counter;
7641: */
7642:

Line 7652: , fa_deprn_periods dp

7648: , ds.ltd_production - ds.ytd_production
7649: , ds.reval_reserve - ds.ytd_reval_deprn_expense
7650: from fa_fiscal_year fy
7651: , fa_deprn_summary ds
7652: , fa_deprn_periods dp
7653: where ds.asset_id = p_asset_hdr_rec.asset_id
7654: and ds.book_type_code = p_asset_hdr_rec.book_type_code
7655: and ds.deprn_source_code = 'BOOKS'
7656: and dp.book_type_code = p_asset_hdr_rec.book_type_code

Line 7669: from fa_deprn_summary ds, fa_deprn_periods dp

7665: , ds.bonus_deprn_reserve
7666: , ds.impairment_reserve
7667: , ds.ltd_production
7668: , ds.reval_reserve
7669: from fa_deprn_summary ds, fa_deprn_periods dp
7670: ,
7671: (select (fy.fiscal_year * ct.NUMBER_PER_FISCAL_YEAR + cp.PERIOD_NUM)
7672: add_amort_period
7673: from fa_calendar_periods cp,

Line 8195: fa_deprn_periods dp,

8191: th.date_effective date_effective,
8192: th.transaction_type_code transaction_type_code
8193: from
8194: fa_transaction_headers th,
8195: fa_deprn_periods dp,
8196: fa_book_controls bc,
8197: fa_fiscal_year fy
8198: where th.asset_id = p_asset_hdr_rec.asset_id
8199: and th.book_type_code = p_asset_hdr_rec.book_type_code

Line 8216: , fa_deprn_periods dp2

8212: G_TRX_TYPE_REC, G_TRX_TYPE_UNIT_ADJ,
8213: G_TRX_TYPE_TFR_VOID)
8214: and not exists (select 1
8215: from fa_deprn_summary ds
8216: , fa_deprn_periods dp2
8217: where ds.asset_id = p_asset_hdr_rec.asset_id
8218: and ds.book_type_code = p_asset_hdr_rec.book_type_code
8219: and dp.book_type_code = p_asset_hdr_rec.book_type_code
8220: and dp.fiscal_year = fy.fiscal_year

Line 8320: from fa_deprn_periods

8316: select period_counter - 1
8317: , period_open_date
8318: , period_close_date
8319: , period_num
8320: from fa_deprn_periods
8321: where book_type_code = p_asset_hdr_rec.book_type_code
8322: and p_trans_rec.transaction_date_entered between
8323: calendar_period_open_date and calendar_period_close_date;
8324:

Line 8366: fa_deprn_periods dp,

8362: and transaction_header_id in
8363: -- Get reclassed transaction after this transaction's fiscal year
8364: (select th.member_transaction_header_id
8365: from fa_transaction_headers th,
8366: fa_deprn_periods dp,
8367: fa_fiscal_year fy,
8368: fa_book_controls bc
8369: where th.asset_id = p_asset_hdr_rec.asset_id
8370: and th.book_type_code = p_asset_hdr_rec.book_type_code

Line 11624: , fa_deprn_periods dp

11620: ,dp.fiscal_year
11621: ,ds.ytd_deprn
11622: ,ds.deprn_reserve
11623: from fa_deprn_summary ds
11624: , fa_deprn_periods dp
11625: where dp.book_type_code = p_asset_hdr_rec.book_type_code
11626: and ds.book_type_code = p_asset_hdr_rec.book_type_code
11627: and ds.asset_id = p_asset_hdr_rec.asset_id
11628: and ds.deprn_source_code = 'BOOKS'

Line 11710: , fa_deprn_periods dp

11706: ) transaction_date_entered,
11707: th.date_effective date_effective,
11708: th.transaction_type_code transaction_type_code
11709: from fa_transaction_headers th
11710: , fa_deprn_periods dp
11711: where th.asset_id = p_asset_hdr_rec.asset_id
11712: and th.book_type_code = p_asset_hdr_rec.book_type_code
11713: and dp.book_type_code = p_asset_hdr_rec.book_type_code
11714: -- and th.date_effective between dp.period_open_date

Line 11811: from fa_deprn_periods

11807: 'ADDITION', th.transaction_date_entered,
11808: 'ADDITION/VOID', th.transaction_date_entered,
11809: decode(th.transaction_key, 'IM', to_date('01-'||to_char(add_months(th.amortization_start_date, 1), 'MM-YYYY'), 'DD-MM-YYYY'),
11810: /* Japan Tax phase3 */ 'ES', (select calendar_period_open_date
11811: from fa_deprn_periods
11812: where book_type_code = p_asset_hdr_rec.book_type_code
11813: and period_counter = bk.extended_depreciation_period),
11814: nvl(th.amortization_start_date,
11815: decode(th.transaction_subtype,

Line 11829: from fa_deprn_periods

11825: px_asset_fin_rec_new.date_placed_in_service),
11826: th.transaction_date_entered)))),
11827: decode(th.transaction_key, 'IM', to_date('01-'||to_char(add_months(th.amortization_start_date, 1), 'MM-YYYY'), 'DD-MM-YYYY'),
11828: /* Japan Tax phase3 */ 'ES', (select calendar_period_open_date
11829: from fa_deprn_periods
11830: where book_type_code = p_asset_hdr_rec.book_type_code
11831: and period_counter = bk.extended_depreciation_period),
11832: nvl(th.amortization_start_date,
11833: decode(th.transaction_subtype,

Line 13240: FROM fa_deprn_periods dp,

13236: end if;
13237:
13238: SELECT count(th.transaction_header_id)
13239: INTO l_future_ret_count
13240: FROM fa_deprn_periods dp,
13241: fa_transaction_headers th,
13242: fa_retirements ret,
13243: fa_conventions con
13244: WHERE th.book_type_code = p_asset_hdr_rec.book_type_code

Line 14750: ,fa_deprn_periods dp

14746: declare
14747: cursor c_depreciate_flag is
14748: select bk.depreciate_flag
14749: from fa_books bk
14750: ,fa_deprn_periods dp
14751: where bk.asset_id = p_asset_hdr_rec.asset_id
14752: and bk.book_type_code = p_asset_hdr_rec.book_type_code
14753: and bk.date_effective <= nvl(dp.period_close_date, sysdate)
14754: and dp.book_type_code = p_asset_hdr_rec.book_type_code

Line 16020: fa_deprn_periods dp

16016: -- multiple backdate amortization enhancement - begin LSON
16017: cursor amort_date_before_add is
16018: select th.transaction_header_id
16019: from fa_transaction_headers th,
16020: fa_deprn_periods dp
16021: where th.book_type_code = p_asset_hdr_rec.book_type_code
16022: and th.asset_id = p_asset_hdr_rec.asset_id
16023: and th.transaction_type_code = 'ADDITION'
16024: and th.book_type_code = dp.book_type_code

Line 16803: from fa_deprn_periods

16799:
16800: --Bug6988399
16801: Cursor c_year_switch is
16802: select 'N'
16803: from fa_deprn_periods
16804: where book_type_code = p_asset_hdr_rec.book_type_code
16805: and period_counter = p_asset_fin_rec_old.period_counter_fully_reserved
16806: and fiscal_year = p_period_rec.fiscal_year;
16807:

Line 16818: fa_deprn_periods fadp,

16814:
16815: Cursor l_recal_ytd is
16816: Select count (1)
16817: from
16818: fa_deprn_periods fadp,
16819: fa_deprn_periods fadp1,
16820: fa_transaction_headers fatr,
16821: fa_deprn_summary fads
16822: where fadp.book_type_code = p_asset_hdr_rec.book_type_code

Line 16819: fa_deprn_periods fadp1,

16815: Cursor l_recal_ytd is
16816: Select count (1)
16817: from
16818: fa_deprn_periods fadp,
16819: fa_deprn_periods fadp1,
16820: fa_transaction_headers fatr,
16821: fa_deprn_summary fads
16822: where fadp.book_type_code = p_asset_hdr_rec.book_type_code
16823: and p_trans_rec.amortization_start_date between fadp.calendar_period_open_date and fadp.calendar_period_close_date

Line 17130: fa_deprn_periods dp

17126: -- Bug 7138798: Check for any transaction in current fiscal year
17127: select count(*)
17128: into l_last_trx_count
17129: from fa_books bks,
17130: fa_deprn_periods dp
17131: where bks.asset_id = p_asset_hdr_rec.asset_id
17132: and bks.book_type_code = p_asset_hdr_rec.book_type_code
17133: and bks.date_ineffective is null
17134: and dp.book_type_code = p_asset_hdr_rec.book_type_code