266: h_old_adj_cost number;
267: h_formula_factor number;
268: h_allowed_deprn_limit_amount number;
269: -- +++++ Group Asset related information +++++
270: h_group_asset_id FA_BOOKS.group_asset_id%type;
271: h_recognize_gain_loss FA_BOOKS.RECOGNIZE_GAIN_LOSS%TYPE;
272: h_recapture_reserve_flag FA_BOOKS.RECAPTURE_RESERVE_FLAG%TYPE;
273: h_limit_proceeds_flag FA_BOOKS.LIMIT_PROCEEDS_FLAG%TYPE;
274: h_terminal_gain_loss FA_BOOKS.TERMINAL_GAIN_LOSS%TYPE;
267: h_formula_factor number;
268: h_allowed_deprn_limit_amount number;
269: -- +++++ Group Asset related information +++++
270: h_group_asset_id FA_BOOKS.group_asset_id%type;
271: h_recognize_gain_loss FA_BOOKS.RECOGNIZE_GAIN_LOSS%TYPE;
272: h_recapture_reserve_flag FA_BOOKS.RECAPTURE_RESERVE_FLAG%TYPE;
273: h_limit_proceeds_flag FA_BOOKS.LIMIT_PROCEEDS_FLAG%TYPE;
274: h_terminal_gain_loss FA_BOOKS.TERMINAL_GAIN_LOSS%TYPE;
275: h_tracking_method FA_BOOKS.TRACKING_METHOD%TYPE;
268: h_allowed_deprn_limit_amount number;
269: -- +++++ Group Asset related information +++++
270: h_group_asset_id FA_BOOKS.group_asset_id%type;
271: h_recognize_gain_loss FA_BOOKS.RECOGNIZE_GAIN_LOSS%TYPE;
272: h_recapture_reserve_flag FA_BOOKS.RECAPTURE_RESERVE_FLAG%TYPE;
273: h_limit_proceeds_flag FA_BOOKS.LIMIT_PROCEEDS_FLAG%TYPE;
274: h_terminal_gain_loss FA_BOOKS.TERMINAL_GAIN_LOSS%TYPE;
275: h_tracking_method FA_BOOKS.TRACKING_METHOD%TYPE;
276: h_exclude_fully_rsv_flag FA_BOOKS.EXCLUDE_FULLY_RSV_FLAG%TYPE;
269: -- +++++ Group Asset related information +++++
270: h_group_asset_id FA_BOOKS.group_asset_id%type;
271: h_recognize_gain_loss FA_BOOKS.RECOGNIZE_GAIN_LOSS%TYPE;
272: h_recapture_reserve_flag FA_BOOKS.RECAPTURE_RESERVE_FLAG%TYPE;
273: h_limit_proceeds_flag FA_BOOKS.LIMIT_PROCEEDS_FLAG%TYPE;
274: h_terminal_gain_loss FA_BOOKS.TERMINAL_GAIN_LOSS%TYPE;
275: h_tracking_method FA_BOOKS.TRACKING_METHOD%TYPE;
276: h_exclude_fully_rsv_flag FA_BOOKS.EXCLUDE_FULLY_RSV_FLAG%TYPE;
277: h_excess_allocation_option FA_BOOKS.EXCESS_ALLOCATION_OPTION%TYPE;
270: h_group_asset_id FA_BOOKS.group_asset_id%type;
271: h_recognize_gain_loss FA_BOOKS.RECOGNIZE_GAIN_LOSS%TYPE;
272: h_recapture_reserve_flag FA_BOOKS.RECAPTURE_RESERVE_FLAG%TYPE;
273: h_limit_proceeds_flag FA_BOOKS.LIMIT_PROCEEDS_FLAG%TYPE;
274: h_terminal_gain_loss FA_BOOKS.TERMINAL_GAIN_LOSS%TYPE;
275: h_tracking_method FA_BOOKS.TRACKING_METHOD%TYPE;
276: h_exclude_fully_rsv_flag FA_BOOKS.EXCLUDE_FULLY_RSV_FLAG%TYPE;
277: h_excess_allocation_option FA_BOOKS.EXCESS_ALLOCATION_OPTION%TYPE;
278: h_depreciation_option FA_BOOKS.DEPRECIATION_OPTION%TYPE;
271: h_recognize_gain_loss FA_BOOKS.RECOGNIZE_GAIN_LOSS%TYPE;
272: h_recapture_reserve_flag FA_BOOKS.RECAPTURE_RESERVE_FLAG%TYPE;
273: h_limit_proceeds_flag FA_BOOKS.LIMIT_PROCEEDS_FLAG%TYPE;
274: h_terminal_gain_loss FA_BOOKS.TERMINAL_GAIN_LOSS%TYPE;
275: h_tracking_method FA_BOOKS.TRACKING_METHOD%TYPE;
276: h_exclude_fully_rsv_flag FA_BOOKS.EXCLUDE_FULLY_RSV_FLAG%TYPE;
277: h_excess_allocation_option FA_BOOKS.EXCESS_ALLOCATION_OPTION%TYPE;
278: h_depreciation_option FA_BOOKS.DEPRECIATION_OPTION%TYPE;
279: h_member_rollup_flag FA_BOOKS.MEMBER_ROLLUP_FLAG%TYPE;
272: h_recapture_reserve_flag FA_BOOKS.RECAPTURE_RESERVE_FLAG%TYPE;
273: h_limit_proceeds_flag FA_BOOKS.LIMIT_PROCEEDS_FLAG%TYPE;
274: h_terminal_gain_loss FA_BOOKS.TERMINAL_GAIN_LOSS%TYPE;
275: h_tracking_method FA_BOOKS.TRACKING_METHOD%TYPE;
276: h_exclude_fully_rsv_flag FA_BOOKS.EXCLUDE_FULLY_RSV_FLAG%TYPE;
277: h_excess_allocation_option FA_BOOKS.EXCESS_ALLOCATION_OPTION%TYPE;
278: h_depreciation_option FA_BOOKS.DEPRECIATION_OPTION%TYPE;
279: h_member_rollup_flag FA_BOOKS.MEMBER_ROLLUP_FLAG%TYPE;
280: h_ltd_proceeds FA_BOOKS.LTD_PROCEEDS%TYPE;
273: h_limit_proceeds_flag FA_BOOKS.LIMIT_PROCEEDS_FLAG%TYPE;
274: h_terminal_gain_loss FA_BOOKS.TERMINAL_GAIN_LOSS%TYPE;
275: h_tracking_method FA_BOOKS.TRACKING_METHOD%TYPE;
276: h_exclude_fully_rsv_flag FA_BOOKS.EXCLUDE_FULLY_RSV_FLAG%TYPE;
277: h_excess_allocation_option FA_BOOKS.EXCESS_ALLOCATION_OPTION%TYPE;
278: h_depreciation_option FA_BOOKS.DEPRECIATION_OPTION%TYPE;
279: h_member_rollup_flag FA_BOOKS.MEMBER_ROLLUP_FLAG%TYPE;
280: h_ltd_proceeds FA_BOOKS.LTD_PROCEEDS%TYPE;
281: h_allocate_to_fully_rsv_flag FA_BOOKS.ALLOCATE_TO_FULLY_RSV_FLAG%TYPE;
274: h_terminal_gain_loss FA_BOOKS.TERMINAL_GAIN_LOSS%TYPE;
275: h_tracking_method FA_BOOKS.TRACKING_METHOD%TYPE;
276: h_exclude_fully_rsv_flag FA_BOOKS.EXCLUDE_FULLY_RSV_FLAG%TYPE;
277: h_excess_allocation_option FA_BOOKS.EXCESS_ALLOCATION_OPTION%TYPE;
278: h_depreciation_option FA_BOOKS.DEPRECIATION_OPTION%TYPE;
279: h_member_rollup_flag FA_BOOKS.MEMBER_ROLLUP_FLAG%TYPE;
280: h_ltd_proceeds FA_BOOKS.LTD_PROCEEDS%TYPE;
281: h_allocate_to_fully_rsv_flag FA_BOOKS.ALLOCATE_TO_FULLY_RSV_FLAG%TYPE;
282: h_allocate_to_fully_ret_flag FA_BOOKS.ALLOCATE_TO_FULLY_RET_FLAG%TYPE;
275: h_tracking_method FA_BOOKS.TRACKING_METHOD%TYPE;
276: h_exclude_fully_rsv_flag FA_BOOKS.EXCLUDE_FULLY_RSV_FLAG%TYPE;
277: h_excess_allocation_option FA_BOOKS.EXCESS_ALLOCATION_OPTION%TYPE;
278: h_depreciation_option FA_BOOKS.DEPRECIATION_OPTION%TYPE;
279: h_member_rollup_flag FA_BOOKS.MEMBER_ROLLUP_FLAG%TYPE;
280: h_ltd_proceeds FA_BOOKS.LTD_PROCEEDS%TYPE;
281: h_allocate_to_fully_rsv_flag FA_BOOKS.ALLOCATE_TO_FULLY_RSV_FLAG%TYPE;
282: h_allocate_to_fully_ret_flag FA_BOOKS.ALLOCATE_TO_FULLY_RET_FLAG%TYPE;
283: h_eofy_reserve FA_BOOKS.EOFY_RESERVE%TYPE;
276: h_exclude_fully_rsv_flag FA_BOOKS.EXCLUDE_FULLY_RSV_FLAG%TYPE;
277: h_excess_allocation_option FA_BOOKS.EXCESS_ALLOCATION_OPTION%TYPE;
278: h_depreciation_option FA_BOOKS.DEPRECIATION_OPTION%TYPE;
279: h_member_rollup_flag FA_BOOKS.MEMBER_ROLLUP_FLAG%TYPE;
280: h_ltd_proceeds FA_BOOKS.LTD_PROCEEDS%TYPE;
281: h_allocate_to_fully_rsv_flag FA_BOOKS.ALLOCATE_TO_FULLY_RSV_FLAG%TYPE;
282: h_allocate_to_fully_ret_flag FA_BOOKS.ALLOCATE_TO_FULLY_RET_FLAG%TYPE;
283: h_eofy_reserve FA_BOOKS.EOFY_RESERVE%TYPE;
284: h_cip_cost FA_BOOKS.CIP_COST%TYPE;
277: h_excess_allocation_option FA_BOOKS.EXCESS_ALLOCATION_OPTION%TYPE;
278: h_depreciation_option FA_BOOKS.DEPRECIATION_OPTION%TYPE;
279: h_member_rollup_flag FA_BOOKS.MEMBER_ROLLUP_FLAG%TYPE;
280: h_ltd_proceeds FA_BOOKS.LTD_PROCEEDS%TYPE;
281: h_allocate_to_fully_rsv_flag FA_BOOKS.ALLOCATE_TO_FULLY_RSV_FLAG%TYPE;
282: h_allocate_to_fully_ret_flag FA_BOOKS.ALLOCATE_TO_FULLY_RET_FLAG%TYPE;
283: h_eofy_reserve FA_BOOKS.EOFY_RESERVE%TYPE;
284: h_cip_cost FA_BOOKS.CIP_COST%TYPE;
285: h_ltd_cost_of_removal FA_BOOKS.LTD_COST_OF_REMOVAL%TYPE;
278: h_depreciation_option FA_BOOKS.DEPRECIATION_OPTION%TYPE;
279: h_member_rollup_flag FA_BOOKS.MEMBER_ROLLUP_FLAG%TYPE;
280: h_ltd_proceeds FA_BOOKS.LTD_PROCEEDS%TYPE;
281: h_allocate_to_fully_rsv_flag FA_BOOKS.ALLOCATE_TO_FULLY_RSV_FLAG%TYPE;
282: h_allocate_to_fully_ret_flag FA_BOOKS.ALLOCATE_TO_FULLY_RET_FLAG%TYPE;
283: h_eofy_reserve FA_BOOKS.EOFY_RESERVE%TYPE;
284: h_cip_cost FA_BOOKS.CIP_COST%TYPE;
285: h_ltd_cost_of_removal FA_BOOKS.LTD_COST_OF_REMOVAL%TYPE;
286: h_prior_eofy_reserve FA_BOOKS.PRIOR_EOFY_RESERVE%TYPE;
279: h_member_rollup_flag FA_BOOKS.MEMBER_ROLLUP_FLAG%TYPE;
280: h_ltd_proceeds FA_BOOKS.LTD_PROCEEDS%TYPE;
281: h_allocate_to_fully_rsv_flag FA_BOOKS.ALLOCATE_TO_FULLY_RSV_FLAG%TYPE;
282: h_allocate_to_fully_ret_flag FA_BOOKS.ALLOCATE_TO_FULLY_RET_FLAG%TYPE;
283: h_eofy_reserve FA_BOOKS.EOFY_RESERVE%TYPE;
284: h_cip_cost FA_BOOKS.CIP_COST%TYPE;
285: h_ltd_cost_of_removal FA_BOOKS.LTD_COST_OF_REMOVAL%TYPE;
286: h_prior_eofy_reserve FA_BOOKS.PRIOR_EOFY_RESERVE%TYPE;
287: h_eop_adj_cost FA_BOOKS.EOP_ADJ_COST%TYPE;
280: h_ltd_proceeds FA_BOOKS.LTD_PROCEEDS%TYPE;
281: h_allocate_to_fully_rsv_flag FA_BOOKS.ALLOCATE_TO_FULLY_RSV_FLAG%TYPE;
282: h_allocate_to_fully_ret_flag FA_BOOKS.ALLOCATE_TO_FULLY_RET_FLAG%TYPE;
283: h_eofy_reserve FA_BOOKS.EOFY_RESERVE%TYPE;
284: h_cip_cost FA_BOOKS.CIP_COST%TYPE;
285: h_ltd_cost_of_removal FA_BOOKS.LTD_COST_OF_REMOVAL%TYPE;
286: h_prior_eofy_reserve FA_BOOKS.PRIOR_EOFY_RESERVE%TYPE;
287: h_eop_adj_cost FA_BOOKS.EOP_ADJ_COST%TYPE;
288: h_eop_formula_factor FA_BOOKS.EOP_FORMULA_FACTOR%TYPE;
281: h_allocate_to_fully_rsv_flag FA_BOOKS.ALLOCATE_TO_FULLY_RSV_FLAG%TYPE;
282: h_allocate_to_fully_ret_flag FA_BOOKS.ALLOCATE_TO_FULLY_RET_FLAG%TYPE;
283: h_eofy_reserve FA_BOOKS.EOFY_RESERVE%TYPE;
284: h_cip_cost FA_BOOKS.CIP_COST%TYPE;
285: h_ltd_cost_of_removal FA_BOOKS.LTD_COST_OF_REMOVAL%TYPE;
286: h_prior_eofy_reserve FA_BOOKS.PRIOR_EOFY_RESERVE%TYPE;
287: h_eop_adj_cost FA_BOOKS.EOP_ADJ_COST%TYPE;
288: h_eop_formula_factor FA_BOOKS.EOP_FORMULA_FACTOR%TYPE;
289: h_exclude_proceeds_from_basis FA_BOOKS.EXCLUDE_PROCEEDS_FROM_BASIS%TYPE;
282: h_allocate_to_fully_ret_flag FA_BOOKS.ALLOCATE_TO_FULLY_RET_FLAG%TYPE;
283: h_eofy_reserve FA_BOOKS.EOFY_RESERVE%TYPE;
284: h_cip_cost FA_BOOKS.CIP_COST%TYPE;
285: h_ltd_cost_of_removal FA_BOOKS.LTD_COST_OF_REMOVAL%TYPE;
286: h_prior_eofy_reserve FA_BOOKS.PRIOR_EOFY_RESERVE%TYPE;
287: h_eop_adj_cost FA_BOOKS.EOP_ADJ_COST%TYPE;
288: h_eop_formula_factor FA_BOOKS.EOP_FORMULA_FACTOR%TYPE;
289: h_exclude_proceeds_from_basis FA_BOOKS.EXCLUDE_PROCEEDS_FROM_BASIS%TYPE;
290: h_retirement_deprn_option FA_BOOKS.RETIREMENT_DEPRN_OPTION%TYPE;
283: h_eofy_reserve FA_BOOKS.EOFY_RESERVE%TYPE;
284: h_cip_cost FA_BOOKS.CIP_COST%TYPE;
285: h_ltd_cost_of_removal FA_BOOKS.LTD_COST_OF_REMOVAL%TYPE;
286: h_prior_eofy_reserve FA_BOOKS.PRIOR_EOFY_RESERVE%TYPE;
287: h_eop_adj_cost FA_BOOKS.EOP_ADJ_COST%TYPE;
288: h_eop_formula_factor FA_BOOKS.EOP_FORMULA_FACTOR%TYPE;
289: h_exclude_proceeds_from_basis FA_BOOKS.EXCLUDE_PROCEEDS_FROM_BASIS%TYPE;
290: h_retirement_deprn_option FA_BOOKS.RETIREMENT_DEPRN_OPTION%TYPE;
291: h_terminal_gain_loss_amount FA_BOOKS.terminal_gain_loss_amount%type;
284: h_cip_cost FA_BOOKS.CIP_COST%TYPE;
285: h_ltd_cost_of_removal FA_BOOKS.LTD_COST_OF_REMOVAL%TYPE;
286: h_prior_eofy_reserve FA_BOOKS.PRIOR_EOFY_RESERVE%TYPE;
287: h_eop_adj_cost FA_BOOKS.EOP_ADJ_COST%TYPE;
288: h_eop_formula_factor FA_BOOKS.EOP_FORMULA_FACTOR%TYPE;
289: h_exclude_proceeds_from_basis FA_BOOKS.EXCLUDE_PROCEEDS_FROM_BASIS%TYPE;
290: h_retirement_deprn_option FA_BOOKS.RETIREMENT_DEPRN_OPTION%TYPE;
291: h_terminal_gain_loss_amount FA_BOOKS.terminal_gain_loss_amount%type;
292: h_pc_fully_reserved number;
285: h_ltd_cost_of_removal FA_BOOKS.LTD_COST_OF_REMOVAL%TYPE;
286: h_prior_eofy_reserve FA_BOOKS.PRIOR_EOFY_RESERVE%TYPE;
287: h_eop_adj_cost FA_BOOKS.EOP_ADJ_COST%TYPE;
288: h_eop_formula_factor FA_BOOKS.EOP_FORMULA_FACTOR%TYPE;
289: h_exclude_proceeds_from_basis FA_BOOKS.EXCLUDE_PROCEEDS_FROM_BASIS%TYPE;
290: h_retirement_deprn_option FA_BOOKS.RETIREMENT_DEPRN_OPTION%TYPE;
291: h_terminal_gain_loss_amount FA_BOOKS.terminal_gain_loss_amount%type;
292: h_pc_fully_reserved number;
293:
286: h_prior_eofy_reserve FA_BOOKS.PRIOR_EOFY_RESERVE%TYPE;
287: h_eop_adj_cost FA_BOOKS.EOP_ADJ_COST%TYPE;
288: h_eop_formula_factor FA_BOOKS.EOP_FORMULA_FACTOR%TYPE;
289: h_exclude_proceeds_from_basis FA_BOOKS.EXCLUDE_PROCEEDS_FROM_BASIS%TYPE;
290: h_retirement_deprn_option FA_BOOKS.RETIREMENT_DEPRN_OPTION%TYPE;
291: h_terminal_gain_loss_amount FA_BOOKS.terminal_gain_loss_amount%type;
292: h_pc_fully_reserved number;
293:
294: -- Japan Tax Phase3
287: h_eop_adj_cost FA_BOOKS.EOP_ADJ_COST%TYPE;
288: h_eop_formula_factor FA_BOOKS.EOP_FORMULA_FACTOR%TYPE;
289: h_exclude_proceeds_from_basis FA_BOOKS.EXCLUDE_PROCEEDS_FROM_BASIS%TYPE;
290: h_retirement_deprn_option FA_BOOKS.RETIREMENT_DEPRN_OPTION%TYPE;
291: h_terminal_gain_loss_amount FA_BOOKS.terminal_gain_loss_amount%type;
292: h_pc_fully_reserved number;
293:
294: -- Japan Tax Phase3
295: h_fully_extended integer;
491: h_fully_extended, -- Japan Tax Phase3
492: h_pc_fully_extended, -- Japan Tax Phase3
493: h_extended_flag -- Japan Tax Phase3
494: FROM
495: fa_books book,
496: fa_methods m,
497: fa_conventions conv,
498: fa_convention_types ctype,
499: fa_book_controls bc,
671: h_retirement_deprn_option,
672: h_terminal_gain_loss_amount,
673: h_pc_fully_reserved
674: FROM
675: fa_books_mrc_v book,
676: fa_methods m,
677: fa_conventions conv,
678: fa_convention_types ctype,
679: fa_book_controls_mrc_v bc,