9: 'YEAR END BALANCE WITH HALF YEAR RULE';
10:
11:
12: TYPE group_rec_type IS RECORD (
13: -- columns of fa_group_rep_itf (GRP_xxx, MEM_xxx)
14: asset_number fa_group_rep_itf.grp_asset_number%TYPE,
15: description fa_group_rep_itf.grp_description%TYPE,
16: asset_type fa_group_rep_itf.grp_asset_type%TYPE,
17: major_category fa_group_rep_itf.grp_major_category%TYPE,
10:
11:
12: TYPE group_rec_type IS RECORD (
13: -- columns of fa_group_rep_itf (GRP_xxx, MEM_xxx)
14: asset_number fa_group_rep_itf.grp_asset_number%TYPE,
15: description fa_group_rep_itf.grp_description%TYPE,
16: asset_type fa_group_rep_itf.grp_asset_type%TYPE,
17: major_category fa_group_rep_itf.grp_major_category%TYPE,
18: minor_category fa_group_rep_itf.grp_minor_category%TYPE,
11:
12: TYPE group_rec_type IS RECORD (
13: -- columns of fa_group_rep_itf (GRP_xxx, MEM_xxx)
14: asset_number fa_group_rep_itf.grp_asset_number%TYPE,
15: description fa_group_rep_itf.grp_description%TYPE,
16: asset_type fa_group_rep_itf.grp_asset_type%TYPE,
17: major_category fa_group_rep_itf.grp_major_category%TYPE,
18: minor_category fa_group_rep_itf.grp_minor_category%TYPE,
19: other_category fa_group_rep_itf.grp_other_category%TYPE,
12: TYPE group_rec_type IS RECORD (
13: -- columns of fa_group_rep_itf (GRP_xxx, MEM_xxx)
14: asset_number fa_group_rep_itf.grp_asset_number%TYPE,
15: description fa_group_rep_itf.grp_description%TYPE,
16: asset_type fa_group_rep_itf.grp_asset_type%TYPE,
17: major_category fa_group_rep_itf.grp_major_category%TYPE,
18: minor_category fa_group_rep_itf.grp_minor_category%TYPE,
19: other_category fa_group_rep_itf.grp_other_category%TYPE,
20: date_placed_in_service fa_group_rep_itf.grp_date_placed_in_service%TYPE,
13: -- columns of fa_group_rep_itf (GRP_xxx, MEM_xxx)
14: asset_number fa_group_rep_itf.grp_asset_number%TYPE,
15: description fa_group_rep_itf.grp_description%TYPE,
16: asset_type fa_group_rep_itf.grp_asset_type%TYPE,
17: major_category fa_group_rep_itf.grp_major_category%TYPE,
18: minor_category fa_group_rep_itf.grp_minor_category%TYPE,
19: other_category fa_group_rep_itf.grp_other_category%TYPE,
20: date_placed_in_service fa_group_rep_itf.grp_date_placed_in_service%TYPE,
21: deprn_method_code fa_group_rep_itf.grp_deprn_method_code%TYPE,
14: asset_number fa_group_rep_itf.grp_asset_number%TYPE,
15: description fa_group_rep_itf.grp_description%TYPE,
16: asset_type fa_group_rep_itf.grp_asset_type%TYPE,
17: major_category fa_group_rep_itf.grp_major_category%TYPE,
18: minor_category fa_group_rep_itf.grp_minor_category%TYPE,
19: other_category fa_group_rep_itf.grp_other_category%TYPE,
20: date_placed_in_service fa_group_rep_itf.grp_date_placed_in_service%TYPE,
21: deprn_method_code fa_group_rep_itf.grp_deprn_method_code%TYPE,
22: rule_name fa_group_rep_itf.grp_rule_name%TYPE,
15: description fa_group_rep_itf.grp_description%TYPE,
16: asset_type fa_group_rep_itf.grp_asset_type%TYPE,
17: major_category fa_group_rep_itf.grp_major_category%TYPE,
18: minor_category fa_group_rep_itf.grp_minor_category%TYPE,
19: other_category fa_group_rep_itf.grp_other_category%TYPE,
20: date_placed_in_service fa_group_rep_itf.grp_date_placed_in_service%TYPE,
21: deprn_method_code fa_group_rep_itf.grp_deprn_method_code%TYPE,
22: rule_name fa_group_rep_itf.grp_rule_name%TYPE,
23: tracking_method fa_group_rep_itf.grp_tracking_method%TYPE,
16: asset_type fa_group_rep_itf.grp_asset_type%TYPE,
17: major_category fa_group_rep_itf.grp_major_category%TYPE,
18: minor_category fa_group_rep_itf.grp_minor_category%TYPE,
19: other_category fa_group_rep_itf.grp_other_category%TYPE,
20: date_placed_in_service fa_group_rep_itf.grp_date_placed_in_service%TYPE,
21: deprn_method_code fa_group_rep_itf.grp_deprn_method_code%TYPE,
22: rule_name fa_group_rep_itf.grp_rule_name%TYPE,
23: tracking_method fa_group_rep_itf.grp_tracking_method%TYPE,
24: -- group only
17: major_category fa_group_rep_itf.grp_major_category%TYPE,
18: minor_category fa_group_rep_itf.grp_minor_category%TYPE,
19: other_category fa_group_rep_itf.grp_other_category%TYPE,
20: date_placed_in_service fa_group_rep_itf.grp_date_placed_in_service%TYPE,
21: deprn_method_code fa_group_rep_itf.grp_deprn_method_code%TYPE,
22: rule_name fa_group_rep_itf.grp_rule_name%TYPE,
23: tracking_method fa_group_rep_itf.grp_tracking_method%TYPE,
24: -- group only
25: adjusted_rate fa_group_rep_itf.grp_adjusted_rate%TYPE,
18: minor_category fa_group_rep_itf.grp_minor_category%TYPE,
19: other_category fa_group_rep_itf.grp_other_category%TYPE,
20: date_placed_in_service fa_group_rep_itf.grp_date_placed_in_service%TYPE,
21: deprn_method_code fa_group_rep_itf.grp_deprn_method_code%TYPE,
22: rule_name fa_group_rep_itf.grp_rule_name%TYPE,
23: tracking_method fa_group_rep_itf.grp_tracking_method%TYPE,
24: -- group only
25: adjusted_rate fa_group_rep_itf.grp_adjusted_rate%TYPE,
26: life_year_month fa_group_rep_itf.grp_life_year_month%TYPE,
19: other_category fa_group_rep_itf.grp_other_category%TYPE,
20: date_placed_in_service fa_group_rep_itf.grp_date_placed_in_service%TYPE,
21: deprn_method_code fa_group_rep_itf.grp_deprn_method_code%TYPE,
22: rule_name fa_group_rep_itf.grp_rule_name%TYPE,
23: tracking_method fa_group_rep_itf.grp_tracking_method%TYPE,
24: -- group only
25: adjusted_rate fa_group_rep_itf.grp_adjusted_rate%TYPE,
26: life_year_month fa_group_rep_itf.grp_life_year_month%TYPE,
27: cost fa_group_rep_itf.grp_cost%TYPE,
21: deprn_method_code fa_group_rep_itf.grp_deprn_method_code%TYPE,
22: rule_name fa_group_rep_itf.grp_rule_name%TYPE,
23: tracking_method fa_group_rep_itf.grp_tracking_method%TYPE,
24: -- group only
25: adjusted_rate fa_group_rep_itf.grp_adjusted_rate%TYPE,
26: life_year_month fa_group_rep_itf.grp_life_year_month%TYPE,
27: cost fa_group_rep_itf.grp_cost%TYPE,
28: salvage_value fa_group_rep_itf.grp_salvage_value%TYPE,
29: adjusted_recoverable_cost fa_group_rep_itf.grp_adjusted_recoverable_cost%TYPE,
22: rule_name fa_group_rep_itf.grp_rule_name%TYPE,
23: tracking_method fa_group_rep_itf.grp_tracking_method%TYPE,
24: -- group only
25: adjusted_rate fa_group_rep_itf.grp_adjusted_rate%TYPE,
26: life_year_month fa_group_rep_itf.grp_life_year_month%TYPE,
27: cost fa_group_rep_itf.grp_cost%TYPE,
28: salvage_value fa_group_rep_itf.grp_salvage_value%TYPE,
29: adjusted_recoverable_cost fa_group_rep_itf.grp_adjusted_recoverable_cost%TYPE,
30: beginning_nbv fa_group_rep_itf.grp_beginning_nbv%TYPE,
23: tracking_method fa_group_rep_itf.grp_tracking_method%TYPE,
24: -- group only
25: adjusted_rate fa_group_rep_itf.grp_adjusted_rate%TYPE,
26: life_year_month fa_group_rep_itf.grp_life_year_month%TYPE,
27: cost fa_group_rep_itf.grp_cost%TYPE,
28: salvage_value fa_group_rep_itf.grp_salvage_value%TYPE,
29: adjusted_recoverable_cost fa_group_rep_itf.grp_adjusted_recoverable_cost%TYPE,
30: beginning_nbv fa_group_rep_itf.grp_beginning_nbv%TYPE,
31: first_half_addition fa_group_rep_itf.grp_first_half_addition%TYPE,
24: -- group only
25: adjusted_rate fa_group_rep_itf.grp_adjusted_rate%TYPE,
26: life_year_month fa_group_rep_itf.grp_life_year_month%TYPE,
27: cost fa_group_rep_itf.grp_cost%TYPE,
28: salvage_value fa_group_rep_itf.grp_salvage_value%TYPE,
29: adjusted_recoverable_cost fa_group_rep_itf.grp_adjusted_recoverable_cost%TYPE,
30: beginning_nbv fa_group_rep_itf.grp_beginning_nbv%TYPE,
31: first_half_addition fa_group_rep_itf.grp_first_half_addition%TYPE,
32: second_half_addition fa_group_rep_itf.grp_second_half_addition%TYPE,
25: adjusted_rate fa_group_rep_itf.grp_adjusted_rate%TYPE,
26: life_year_month fa_group_rep_itf.grp_life_year_month%TYPE,
27: cost fa_group_rep_itf.grp_cost%TYPE,
28: salvage_value fa_group_rep_itf.grp_salvage_value%TYPE,
29: adjusted_recoverable_cost fa_group_rep_itf.grp_adjusted_recoverable_cost%TYPE,
30: beginning_nbv fa_group_rep_itf.grp_beginning_nbv%TYPE,
31: first_half_addition fa_group_rep_itf.grp_first_half_addition%TYPE,
32: second_half_addition fa_group_rep_itf.grp_second_half_addition%TYPE,
33: addition_amount fa_group_rep_itf.grp_addition_amount%TYPE,
26: life_year_month fa_group_rep_itf.grp_life_year_month%TYPE,
27: cost fa_group_rep_itf.grp_cost%TYPE,
28: salvage_value fa_group_rep_itf.grp_salvage_value%TYPE,
29: adjusted_recoverable_cost fa_group_rep_itf.grp_adjusted_recoverable_cost%TYPE,
30: beginning_nbv fa_group_rep_itf.grp_beginning_nbv%TYPE,
31: first_half_addition fa_group_rep_itf.grp_first_half_addition%TYPE,
32: second_half_addition fa_group_rep_itf.grp_second_half_addition%TYPE,
33: addition_amount fa_group_rep_itf.grp_addition_amount%TYPE,
34: adjustment_amount fa_group_rep_itf.grp_adjustment_amount%TYPE,
27: cost fa_group_rep_itf.grp_cost%TYPE,
28: salvage_value fa_group_rep_itf.grp_salvage_value%TYPE,
29: adjusted_recoverable_cost fa_group_rep_itf.grp_adjusted_recoverable_cost%TYPE,
30: beginning_nbv fa_group_rep_itf.grp_beginning_nbv%TYPE,
31: first_half_addition fa_group_rep_itf.grp_first_half_addition%TYPE,
32: second_half_addition fa_group_rep_itf.grp_second_half_addition%TYPE,
33: addition_amount fa_group_rep_itf.grp_addition_amount%TYPE,
34: adjustment_amount fa_group_rep_itf.grp_adjustment_amount%TYPE,
35: net_proceeds fa_group_rep_itf.grp_net_proceeds%TYPE,
28: salvage_value fa_group_rep_itf.grp_salvage_value%TYPE,
29: adjusted_recoverable_cost fa_group_rep_itf.grp_adjusted_recoverable_cost%TYPE,
30: beginning_nbv fa_group_rep_itf.grp_beginning_nbv%TYPE,
31: first_half_addition fa_group_rep_itf.grp_first_half_addition%TYPE,
32: second_half_addition fa_group_rep_itf.grp_second_half_addition%TYPE,
33: addition_amount fa_group_rep_itf.grp_addition_amount%TYPE,
34: adjustment_amount fa_group_rep_itf.grp_adjustment_amount%TYPE,
35: net_proceeds fa_group_rep_itf.grp_net_proceeds%TYPE,
36: proceeds_of_sale fa_group_rep_itf.grp_proceeds_of_sale%TYPE,
29: adjusted_recoverable_cost fa_group_rep_itf.grp_adjusted_recoverable_cost%TYPE,
30: beginning_nbv fa_group_rep_itf.grp_beginning_nbv%TYPE,
31: first_half_addition fa_group_rep_itf.grp_first_half_addition%TYPE,
32: second_half_addition fa_group_rep_itf.grp_second_half_addition%TYPE,
33: addition_amount fa_group_rep_itf.grp_addition_amount%TYPE,
34: adjustment_amount fa_group_rep_itf.grp_adjustment_amount%TYPE,
35: net_proceeds fa_group_rep_itf.grp_net_proceeds%TYPE,
36: proceeds_of_sale fa_group_rep_itf.grp_proceeds_of_sale%TYPE,
37: cost_of_removal fa_group_rep_itf.grp_cost_of_removal%TYPE,
30: beginning_nbv fa_group_rep_itf.grp_beginning_nbv%TYPE,
31: first_half_addition fa_group_rep_itf.grp_first_half_addition%TYPE,
32: second_half_addition fa_group_rep_itf.grp_second_half_addition%TYPE,
33: addition_amount fa_group_rep_itf.grp_addition_amount%TYPE,
34: adjustment_amount fa_group_rep_itf.grp_adjustment_amount%TYPE,
35: net_proceeds fa_group_rep_itf.grp_net_proceeds%TYPE,
36: proceeds_of_sale fa_group_rep_itf.grp_proceeds_of_sale%TYPE,
37: cost_of_removal fa_group_rep_itf.grp_cost_of_removal%TYPE,
38: cost_retired fa_group_rep_itf.grp_cost_retired%TYPE,
31: first_half_addition fa_group_rep_itf.grp_first_half_addition%TYPE,
32: second_half_addition fa_group_rep_itf.grp_second_half_addition%TYPE,
33: addition_amount fa_group_rep_itf.grp_addition_amount%TYPE,
34: adjustment_amount fa_group_rep_itf.grp_adjustment_amount%TYPE,
35: net_proceeds fa_group_rep_itf.grp_net_proceeds%TYPE,
36: proceeds_of_sale fa_group_rep_itf.grp_proceeds_of_sale%TYPE,
37: cost_of_removal fa_group_rep_itf.grp_cost_of_removal%TYPE,
38: cost_retired fa_group_rep_itf.grp_cost_retired%TYPE,
39: reserve_retired fa_group_rep_itf.grp_reserve_retired%TYPE,
32: second_half_addition fa_group_rep_itf.grp_second_half_addition%TYPE,
33: addition_amount fa_group_rep_itf.grp_addition_amount%TYPE,
34: adjustment_amount fa_group_rep_itf.grp_adjustment_amount%TYPE,
35: net_proceeds fa_group_rep_itf.grp_net_proceeds%TYPE,
36: proceeds_of_sale fa_group_rep_itf.grp_proceeds_of_sale%TYPE,
37: cost_of_removal fa_group_rep_itf.grp_cost_of_removal%TYPE,
38: cost_retired fa_group_rep_itf.grp_cost_retired%TYPE,
39: reserve_retired fa_group_rep_itf.grp_reserve_retired%TYPE,
40: recapture_amount fa_group_rep_itf.grp_recapture_amount%TYPE,
33: addition_amount fa_group_rep_itf.grp_addition_amount%TYPE,
34: adjustment_amount fa_group_rep_itf.grp_adjustment_amount%TYPE,
35: net_proceeds fa_group_rep_itf.grp_net_proceeds%TYPE,
36: proceeds_of_sale fa_group_rep_itf.grp_proceeds_of_sale%TYPE,
37: cost_of_removal fa_group_rep_itf.grp_cost_of_removal%TYPE,
38: cost_retired fa_group_rep_itf.grp_cost_retired%TYPE,
39: reserve_retired fa_group_rep_itf.grp_reserve_retired%TYPE,
40: recapture_amount fa_group_rep_itf.grp_recapture_amount%TYPE,
41: -- group only
34: adjustment_amount fa_group_rep_itf.grp_adjustment_amount%TYPE,
35: net_proceeds fa_group_rep_itf.grp_net_proceeds%TYPE,
36: proceeds_of_sale fa_group_rep_itf.grp_proceeds_of_sale%TYPE,
37: cost_of_removal fa_group_rep_itf.grp_cost_of_removal%TYPE,
38: cost_retired fa_group_rep_itf.grp_cost_retired%TYPE,
39: reserve_retired fa_group_rep_itf.grp_reserve_retired%TYPE,
40: recapture_amount fa_group_rep_itf.grp_recapture_amount%TYPE,
41: -- group only
42: terminal_gain_loss_amount fa_group_rep_itf.grp_terminal_gain_loss_amount%TYPE,
35: net_proceeds fa_group_rep_itf.grp_net_proceeds%TYPE,
36: proceeds_of_sale fa_group_rep_itf.grp_proceeds_of_sale%TYPE,
37: cost_of_removal fa_group_rep_itf.grp_cost_of_removal%TYPE,
38: cost_retired fa_group_rep_itf.grp_cost_retired%TYPE,
39: reserve_retired fa_group_rep_itf.grp_reserve_retired%TYPE,
40: recapture_amount fa_group_rep_itf.grp_recapture_amount%TYPE,
41: -- group only
42: terminal_gain_loss_amount fa_group_rep_itf.grp_terminal_gain_loss_amount%TYPE,
43: -- group only
36: proceeds_of_sale fa_group_rep_itf.grp_proceeds_of_sale%TYPE,
37: cost_of_removal fa_group_rep_itf.grp_cost_of_removal%TYPE,
38: cost_retired fa_group_rep_itf.grp_cost_retired%TYPE,
39: reserve_retired fa_group_rep_itf.grp_reserve_retired%TYPE,
40: recapture_amount fa_group_rep_itf.grp_recapture_amount%TYPE,
41: -- group only
42: terminal_gain_loss_amount fa_group_rep_itf.grp_terminal_gain_loss_amount%TYPE,
43: -- group only
44: nbv_before_deprn fa_group_rep_itf.grp_nbv_before_deprn%TYPE,
38: cost_retired fa_group_rep_itf.grp_cost_retired%TYPE,
39: reserve_retired fa_group_rep_itf.grp_reserve_retired%TYPE,
40: recapture_amount fa_group_rep_itf.grp_recapture_amount%TYPE,
41: -- group only
42: terminal_gain_loss_amount fa_group_rep_itf.grp_terminal_gain_loss_amount%TYPE,
43: -- group only
44: nbv_before_deprn fa_group_rep_itf.grp_nbv_before_deprn%TYPE,
45: deprn_basis_adjustment fa_group_rep_itf.grp_deprn_basis_adjustment%TYPE,
46: reduced_nbv fa_group_rep_itf.grp_reduced_nbv%TYPE,
40: recapture_amount fa_group_rep_itf.grp_recapture_amount%TYPE,
41: -- group only
42: terminal_gain_loss_amount fa_group_rep_itf.grp_terminal_gain_loss_amount%TYPE,
43: -- group only
44: nbv_before_deprn fa_group_rep_itf.grp_nbv_before_deprn%TYPE,
45: deprn_basis_adjustment fa_group_rep_itf.grp_deprn_basis_adjustment%TYPE,
46: reduced_nbv fa_group_rep_itf.grp_reduced_nbv%TYPE,
47: regular_deprn_amount fa_group_rep_itf.grp_regular_deprn_amount%TYPE,
48: -- group only
41: -- group only
42: terminal_gain_loss_amount fa_group_rep_itf.grp_terminal_gain_loss_amount%TYPE,
43: -- group only
44: nbv_before_deprn fa_group_rep_itf.grp_nbv_before_deprn%TYPE,
45: deprn_basis_adjustment fa_group_rep_itf.grp_deprn_basis_adjustment%TYPE,
46: reduced_nbv fa_group_rep_itf.grp_reduced_nbv%TYPE,
47: regular_deprn_amount fa_group_rep_itf.grp_regular_deprn_amount%TYPE,
48: -- group only
49: reduced_deprn_amount fa_group_rep_itf.grp_reduced_deprn_amount%TYPE,
42: terminal_gain_loss_amount fa_group_rep_itf.grp_terminal_gain_loss_amount%TYPE,
43: -- group only
44: nbv_before_deprn fa_group_rep_itf.grp_nbv_before_deprn%TYPE,
45: deprn_basis_adjustment fa_group_rep_itf.grp_deprn_basis_adjustment%TYPE,
46: reduced_nbv fa_group_rep_itf.grp_reduced_nbv%TYPE,
47: regular_deprn_amount fa_group_rep_itf.grp_regular_deprn_amount%TYPE,
48: -- group only
49: reduced_deprn_amount fa_group_rep_itf.grp_reduced_deprn_amount%TYPE,
50: -- group only
43: -- group only
44: nbv_before_deprn fa_group_rep_itf.grp_nbv_before_deprn%TYPE,
45: deprn_basis_adjustment fa_group_rep_itf.grp_deprn_basis_adjustment%TYPE,
46: reduced_nbv fa_group_rep_itf.grp_reduced_nbv%TYPE,
47: regular_deprn_amount fa_group_rep_itf.grp_regular_deprn_amount%TYPE,
48: -- group only
49: reduced_deprn_amount fa_group_rep_itf.grp_reduced_deprn_amount%TYPE,
50: -- group only
51: annual_deprn_amount fa_group_rep_itf.grp_annual_deprn_amount%TYPE,
45: deprn_basis_adjustment fa_group_rep_itf.grp_deprn_basis_adjustment%TYPE,
46: reduced_nbv fa_group_rep_itf.grp_reduced_nbv%TYPE,
47: regular_deprn_amount fa_group_rep_itf.grp_regular_deprn_amount%TYPE,
48: -- group only
49: reduced_deprn_amount fa_group_rep_itf.grp_reduced_deprn_amount%TYPE,
50: -- group only
51: annual_deprn_amount fa_group_rep_itf.grp_annual_deprn_amount%TYPE,
52: deprn_reserve fa_group_rep_itf.grp_deprn_reserve%TYPE,
53: ending_nbv fa_group_rep_itf.grp_ending_nbv%TYPE,
47: regular_deprn_amount fa_group_rep_itf.grp_regular_deprn_amount%TYPE,
48: -- group only
49: reduced_deprn_amount fa_group_rep_itf.grp_reduced_deprn_amount%TYPE,
50: -- group only
51: annual_deprn_amount fa_group_rep_itf.grp_annual_deprn_amount%TYPE,
52: deprn_reserve fa_group_rep_itf.grp_deprn_reserve%TYPE,
53: ending_nbv fa_group_rep_itf.grp_ending_nbv%TYPE,
54: status fa_group_rep_itf.mem_status%TYPE,
55: -- member only
48: -- group only
49: reduced_deprn_amount fa_group_rep_itf.grp_reduced_deprn_amount%TYPE,
50: -- group only
51: annual_deprn_amount fa_group_rep_itf.grp_annual_deprn_amount%TYPE,
52: deprn_reserve fa_group_rep_itf.grp_deprn_reserve%TYPE,
53: ending_nbv fa_group_rep_itf.grp_ending_nbv%TYPE,
54: status fa_group_rep_itf.mem_status%TYPE,
55: -- member only
56: -- necessities for query and calculation
49: reduced_deprn_amount fa_group_rep_itf.grp_reduced_deprn_amount%TYPE,
50: -- group only
51: annual_deprn_amount fa_group_rep_itf.grp_annual_deprn_amount%TYPE,
52: deprn_reserve fa_group_rep_itf.grp_deprn_reserve%TYPE,
53: ending_nbv fa_group_rep_itf.grp_ending_nbv%TYPE,
54: status fa_group_rep_itf.mem_status%TYPE,
55: -- member only
56: -- necessities for query and calculation
57: asset_id fa_additions.asset_id%TYPE,
50: -- group only
51: annual_deprn_amount fa_group_rep_itf.grp_annual_deprn_amount%TYPE,
52: deprn_reserve fa_group_rep_itf.grp_deprn_reserve%TYPE,
53: ending_nbv fa_group_rep_itf.grp_ending_nbv%TYPE,
54: status fa_group_rep_itf.mem_status%TYPE,
55: -- member only
56: -- necessities for query and calculation
57: asset_id fa_additions.asset_id%TYPE,
58: pre_group_asset_id fa_books.group_asset_id%TYPE,
70:
71:
72: TYPE info_rec_type IS RECORD (
73: book_type_code fa_books.book_type_code%TYPE,
74: request_id fa_group_rep_itf.request_id%TYPE,
75: user_id fa_group_rep_itf.created_by%TYPE,
76: organization_name fa_group_rep_itf.organization_name%TYPE,
77: functional_currency_code fa_group_rep_itf.functional_currency_code%TYPE,
78: set_of_books_id fa_group_rep_itf.set_of_books_id%TYPE,
71:
72: TYPE info_rec_type IS RECORD (
73: book_type_code fa_books.book_type_code%TYPE,
74: request_id fa_group_rep_itf.request_id%TYPE,
75: user_id fa_group_rep_itf.created_by%TYPE,
76: organization_name fa_group_rep_itf.organization_name%TYPE,
77: functional_currency_code fa_group_rep_itf.functional_currency_code%TYPE,
78: set_of_books_id fa_group_rep_itf.set_of_books_id%TYPE,
79: deprn_calendar fa_group_rep_itf.deprn_calendar%TYPE,
72: TYPE info_rec_type IS RECORD (
73: book_type_code fa_books.book_type_code%TYPE,
74: request_id fa_group_rep_itf.request_id%TYPE,
75: user_id fa_group_rep_itf.created_by%TYPE,
76: organization_name fa_group_rep_itf.organization_name%TYPE,
77: functional_currency_code fa_group_rep_itf.functional_currency_code%TYPE,
78: set_of_books_id fa_group_rep_itf.set_of_books_id%TYPE,
79: deprn_calendar fa_group_rep_itf.deprn_calendar%TYPE,
80: fiscal_year fa_group_rep_itf.fiscal_year%TYPE,
73: book_type_code fa_books.book_type_code%TYPE,
74: request_id fa_group_rep_itf.request_id%TYPE,
75: user_id fa_group_rep_itf.created_by%TYPE,
76: organization_name fa_group_rep_itf.organization_name%TYPE,
77: functional_currency_code fa_group_rep_itf.functional_currency_code%TYPE,
78: set_of_books_id fa_group_rep_itf.set_of_books_id%TYPE,
79: deprn_calendar fa_group_rep_itf.deprn_calendar%TYPE,
80: fiscal_year fa_group_rep_itf.fiscal_year%TYPE,
81: max_period_counter fa_deprn_periods.period_counter%TYPE,
74: request_id fa_group_rep_itf.request_id%TYPE,
75: user_id fa_group_rep_itf.created_by%TYPE,
76: organization_name fa_group_rep_itf.organization_name%TYPE,
77: functional_currency_code fa_group_rep_itf.functional_currency_code%TYPE,
78: set_of_books_id fa_group_rep_itf.set_of_books_id%TYPE,
79: deprn_calendar fa_group_rep_itf.deprn_calendar%TYPE,
80: fiscal_year fa_group_rep_itf.fiscal_year%TYPE,
81: max_period_counter fa_deprn_periods.period_counter%TYPE,
82: min_period_counter fa_deprn_periods.period_counter%TYPE,
75: user_id fa_group_rep_itf.created_by%TYPE,
76: organization_name fa_group_rep_itf.organization_name%TYPE,
77: functional_currency_code fa_group_rep_itf.functional_currency_code%TYPE,
78: set_of_books_id fa_group_rep_itf.set_of_books_id%TYPE,
79: deprn_calendar fa_group_rep_itf.deprn_calendar%TYPE,
80: fiscal_year fa_group_rep_itf.fiscal_year%TYPE,
81: max_period_counter fa_deprn_periods.period_counter%TYPE,
82: min_period_counter fa_deprn_periods.period_counter%TYPE,
83: major_cat_select_stmt VARCHAR2(100),
76: organization_name fa_group_rep_itf.organization_name%TYPE,
77: functional_currency_code fa_group_rep_itf.functional_currency_code%TYPE,
78: set_of_books_id fa_group_rep_itf.set_of_books_id%TYPE,
79: deprn_calendar fa_group_rep_itf.deprn_calendar%TYPE,
80: fiscal_year fa_group_rep_itf.fiscal_year%TYPE,
81: max_period_counter fa_deprn_periods.period_counter%TYPE,
82: min_period_counter fa_deprn_periods.period_counter%TYPE,
83: major_cat_select_stmt VARCHAR2(100),
84: minor_cat_select_stmt VARCHAR2(100),