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_FISCAL_YEAR

Line 75: FROM fa_calendar_periods fcp, fa_calendar_types fct, fa_fiscal_year ffy

71: l_calling_fn varchar2(40) := 'FA_AMORT_PVT.get_dcal_pc';
72: BEGIN
73: SELECT fcp.period_num +( fct.number_per_fiscal_year * ffy.fiscal_year)
74: INTO l_pc
75: FROM fa_calendar_periods fcp, fa_calendar_types fct, fa_fiscal_year ffy
76: WHERE pp_date BETWEEN fcp.start_date AND fcp.end_date
77: AND pp_date BETWEEN ffy.start_date AND ffy.end_date
78: AND fct.calendar_type = fcp.calendar_type
79: AND ffy.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name

Line 360: , fa_fiscal_year fy

356: , cp.period_num period_num
357: , fy.fiscal_year fiscal_year
358: , 'N'
359: from fa_book_controls bc
360: , fa_fiscal_year fy
361: , fa_calendar_types ct
362: , fa_calendar_periods cp
363: where bc.book_type_code = p_asset_hdr_rec.book_type_code
364: and bc.deprn_calendar = ct.calendar_type

Line 1038: from fa_fiscal_year fy

1034: , cp.end_date calendar_period_close_date
1035: , cp.period_num period_num
1036: , fy.fiscal_year fiscal_year
1037: , 'N'
1038: from fa_fiscal_year fy
1039: , fa_calendar_types ct
1040: , fa_calendar_periods cp
1041: where ct.calendar_type = fa_cache_pkg.fazcbc_record.deprn_calendar
1042: and fy.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name

Line 7650: from fa_fiscal_year fy

7646: , ds.bonus_deprn_reserve - ds.bonus_ytd_deprn
7647: , ds.impairment_reserve - ds.ytd_impairment
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

Line 7675: fa_fiscal_year fy,

7671: (select (fy.fiscal_year * ct.NUMBER_PER_FISCAL_YEAR + cp.PERIOD_NUM)
7672: add_amort_period
7673: from fa_calendar_periods cp,
7674: fa_book_controls bc,
7675: fa_fiscal_year fy,
7676: fa_calendar_types ct,
7677: fa_transaction_headers th
7678: WHERE th.book_type_code = p_asset_hdr_rec.book_type_code
7679: and th.asset_id = p_asset_hdr_rec.asset_id

Line 8197: fa_fiscal_year fy

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
8200: and bc.book_type_code = p_asset_hdr_rec.book_type_code
8201: and bc.fiscal_year_name = fy.fiscal_year_name

Line 8235: fa_fiscal_year fy

8231: from fa_retirements ret,
8232: fa_transaction_headers mth,
8233: fa_transaction_headers gth,
8234: fa_book_controls bc,
8235: fa_fiscal_year fy
8236: where gth.asset_id = p_asset_hdr_rec.asset_id
8237: and gth.book_type_code = p_asset_hdr_rec.book_type_code
8238: and bc.book_type_code = p_asset_hdr_rec.book_type_code
8239: and bc.fiscal_year_name = fy.fiscal_year_name

Line 8251: from fa_fiscal_year fy,

8247: and ret.book_type_code = p_asset_hdr_rec.book_type_code
8248: and ret.transaction_header_id_out is null
8249: and fy.start_date =
8250: (select fy.start_date
8251: from fa_fiscal_year fy,
8252: fa_book_controls bc
8253: where bc.book_type_code = p_asset_hdr_rec.book_type_code
8254: and bc.fiscal_year_name = fy.fiscal_year_name
8255: and fy.start_date <= p_trans_rec.transaction_date_entered

Line 8267: fa_fiscal_year fy

8263: fa_transaction_headers mth,
8264: fa_transaction_headers gth,
8265: fa_mc_book_controls mbc,
8266: fa_book_controls bc,
8267: fa_fiscal_year fy
8268: where gth.asset_id = p_asset_hdr_rec.asset_id
8269: and gth.book_type_code = p_asset_hdr_rec.book_type_code
8270: and bc.book_type_code = p_asset_hdr_rec.book_type_code
8271: and mbc.book_type_code = p_asset_hdr_rec.book_type_code

Line 8286: from fa_fiscal_year fy,

8282: and ret.transaction_header_id_out is null
8283: and ret.set_of_books_id = p_asset_hdr_rec.set_of_books_id
8284: and fy.start_date =
8285: (select fy.start_date
8286: from fa_fiscal_year fy,
8287: fa_mc_book_controls bc
8288: where bc.book_type_code = p_asset_hdr_rec.book_type_code
8289: and bc.set_of_books_id = p_asset_hdr_rec.set_of_books_id
8290: and bc.fiscal_year_name = fy.fiscal_year_name

Line 8301: fa_fiscal_year fy

8297: nvl(sum(ret.eofy_reserve), 0)
8298: from fa_retirements ret,
8299: fa_transaction_headers th,
8300: fa_book_controls bc,
8301: fa_fiscal_year fy
8302: where th.asset_id = p_asset_hdr_rec.asset_id
8303: and th.book_type_code = p_asset_hdr_rec.book_type_code
8304: and bc.book_type_code = p_asset_hdr_rec.book_type_code
8305: and bc.fiscal_year_name = fy.fiscal_year_name

Line 8367: fa_fiscal_year fy,

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
8371: and dp.book_type_code = p_asset_hdr_rec.book_type_code

Line 11638: fa_fiscal_year fy,

11634: CURSOR c_get_dpis_period IS
11635: select fy.fiscal_year
11636: from fa_calendar_periods cp,
11637: fa_book_controls bc,
11638: fa_fiscal_year fy,
11639: fa_calendar_types ct,
11640: fa_books bk
11641: WHERE bk.book_type_code = p_asset_hdr_rec.book_type_code
11642: and bk.asset_id = p_asset_hdr_rec.asset_id

Line 13216: fa_fiscal_year fy,

13212: select fy.fiscal_year * ct.NUMBER_PER_FISCAL_YEAR + cp.PERIOD_NUM
13213: into l_ret_prorate_pc
13214: from fa_calendar_periods cp,
13215: fa_book_controls bc,
13216: fa_fiscal_year fy,
13217: fa_calendar_types ct,
13218: fa_retirements ret,
13219: fa_conventions con
13220: WHERE ret.book_type_code = p_asset_hdr_rec.book_type_code