[Home] [Help]
355: , cp.end_date calendar_period_close_date
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
7670: ,
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
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
8200: and bc.book_type_code = p_asset_hdr_rec.book_type_code
8230: nvl(sum(ret.eofy_reserve), 0)
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
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
8256: and fy.end_date >= p_trans_rec.transaction_date_entered
8262: from fa_mc_retirements ret,
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
8296: select nvl(sum(ret.reserve_retired), 0),
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
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
8372: and dp.book_type_code = bc.book_type_code
11633: -- for the prorate date.
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
13211: -- Get the prorate period counter for the retirement
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