[Home] [Help]
324: , cp.period_num period_num
325: , fy.fiscal_year fiscal_year
326: , 'N'
327: from fa_book_controls bc
328: , fa_fiscal_year fy
329: , fa_calendar_types ct
330: , fa_calendar_periods cp
331: where bc.book_type_code = p_asset_hdr_rec.book_type_code
332: and bc.deprn_calendar = ct.calendar_type
987: , cp.end_date calendar_period_close_date
988: , cp.period_num period_num
989: , fy.fiscal_year fiscal_year
990: , 'N'
991: from fa_fiscal_year fy
992: , fa_calendar_types ct
993: , fa_calendar_periods cp
994: where ct.calendar_type = fa_cache_pkg.fazcbc_record.deprn_calendar
995: and fy.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
7542: select ds.deprn_reserve - ds.ytd_deprn
7543: , ds.bonus_deprn_reserve - ds.bonus_ytd_deprn
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
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
7989: and bc.book_type_code = p_asset_hdr_rec.book_type_code
7990: and bc.fiscal_year_name = fy.fiscal_year_name
8021: from fa_retirements ret,
8022: fa_transaction_headers mth,
8023: fa_transaction_headers gth,
8024: fa_book_controls bc,
8025: fa_fiscal_year fy
8026: where gth.asset_id = p_asset_hdr_rec.asset_id
8027: and gth.book_type_code = p_asset_hdr_rec.book_type_code
8028: and bc.book_type_code = p_asset_hdr_rec.book_type_code
8029: and bc.fiscal_year_name = fy.fiscal_year_name
8037: and ret.book_type_code = p_asset_hdr_rec.book_type_code
8038: and ret.transaction_header_id_out is null
8039: and fy.start_date =
8040: (select fy.start_date
8041: from fa_fiscal_year fy,
8042: fa_book_controls bc
8043: where bc.book_type_code = p_asset_hdr_rec.book_type_code
8044: and bc.fiscal_year_name = fy.fiscal_year_name
8045: and fy.start_date <= p_trans_rec.transaction_date_entered
8052: from fa_retirements_mrc_v ret,
8053: fa_transaction_headers mth,
8054: fa_transaction_headers gth,
8055: fa_book_controls_mrc_v bc,
8056: fa_fiscal_year fy
8057: where gth.asset_id = p_asset_hdr_rec.asset_id
8058: and gth.book_type_code = p_asset_hdr_rec.book_type_code
8059: and bc.book_type_code = p_asset_hdr_rec.book_type_code
8060: and bc.fiscal_year_name = fy.fiscal_year_name
8068: and ret.book_type_code = p_asset_hdr_rec.book_type_code
8069: and ret.transaction_header_id_out is null
8070: and fy.start_date =
8071: (select fy.start_date
8072: from fa_fiscal_year fy,
8073: fa_book_controls_mrc_v bc
8074: where bc.book_type_code = p_asset_hdr_rec.book_type_code
8075: and bc.fiscal_year_name = fy.fiscal_year_name
8076: and fy.start_date <= p_trans_rec.transaction_date_entered
8082: nvl(sum(ret.eofy_reserve), 0)
8083: from fa_retirements ret,
8084: fa_transaction_headers th,
8085: fa_book_controls bc,
8086: fa_fiscal_year fy
8087: where th.asset_id = p_asset_hdr_rec.asset_id
8088: and th.book_type_code = p_asset_hdr_rec.book_type_code
8089: and bc.book_type_code = p_asset_hdr_rec.book_type_code
8090: and bc.fiscal_year_name = fy.fiscal_year_name
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
8156: and dp.book_type_code = p_asset_hdr_rec.book_type_code