920: close CUR_FULL_RSV_MEMBER_TRC;
921:
922: else -- used_by_adjsutment ='ADJUSTMENT'
923:
924: FOR i IN 1 .. fa_track_member_pvt.p_track_member_table.COUNT LOOP
925: if fa_track_member_pvt.p_track_member_table(i).group_asset_id
926: = px_rule_in.asset_id and
927: fa_track_member_pvt.p_track_member_table(i).period_counter
928: = px_rule_in.period_counter and
921:
922: else -- used_by_adjsutment ='ADJUSTMENT'
923:
924: FOR i IN 1 .. fa_track_member_pvt.p_track_member_table.COUNT LOOP
925: if fa_track_member_pvt.p_track_member_table(i).group_asset_id
926: = px_rule_in.asset_id and
927: fa_track_member_pvt.p_track_member_table(i).period_counter
928: = px_rule_in.period_counter and
929: nvl(fa_track_member_pvt.p_track_member_table(i).fully_reserved_flag,'N') = 'Y' then
923:
924: FOR i IN 1 .. fa_track_member_pvt.p_track_member_table.COUNT LOOP
925: if fa_track_member_pvt.p_track_member_table(i).group_asset_id
926: = px_rule_in.asset_id and
927: fa_track_member_pvt.p_track_member_table(i).period_counter
928: = px_rule_in.period_counter and
929: nvl(fa_track_member_pvt.p_track_member_table(i).fully_reserved_flag,'N') = 'Y' then
930:
931: trc_fully_rsv_adjusted_cost := trc_fully_rsv_adjusted_cost +
925: if fa_track_member_pvt.p_track_member_table(i).group_asset_id
926: = px_rule_in.asset_id and
927: fa_track_member_pvt.p_track_member_table(i).period_counter
928: = px_rule_in.period_counter and
929: nvl(fa_track_member_pvt.p_track_member_table(i).fully_reserved_flag,'N') = 'Y' then
930:
931: trc_fully_rsv_adjusted_cost := trc_fully_rsv_adjusted_cost +
932: fa_track_member_pvt.p_track_member_table(i).adjusted_cost;
933: trc_fully_rsv_salvage_value := trc_fully_rsv_salvage_value +
928: = px_rule_in.period_counter and
929: nvl(fa_track_member_pvt.p_track_member_table(i).fully_reserved_flag,'N') = 'Y' then
930:
931: trc_fully_rsv_adjusted_cost := trc_fully_rsv_adjusted_cost +
932: fa_track_member_pvt.p_track_member_table(i).adjusted_cost;
933: trc_fully_rsv_salvage_value := trc_fully_rsv_salvage_value +
934: fa_track_member_pvt.p_track_member_table(i).salvage_value;
935: trc_fully_rsv_recoverable_cost := trc_fully_rsv_recoverable_cost +
936: fa_track_member_pvt.p_track_member_table(i).recoverable_cost;
930:
931: trc_fully_rsv_adjusted_cost := trc_fully_rsv_adjusted_cost +
932: fa_track_member_pvt.p_track_member_table(i).adjusted_cost;
933: trc_fully_rsv_salvage_value := trc_fully_rsv_salvage_value +
934: fa_track_member_pvt.p_track_member_table(i).salvage_value;
935: trc_fully_rsv_recoverable_cost := trc_fully_rsv_recoverable_cost +
936: fa_track_member_pvt.p_track_member_table(i).recoverable_cost;
937: trc_fully_rsv_deprn_reserve := trc_fully_rsv_deprn_reserve +
938: fa_track_member_pvt.p_track_member_table(i).deprn_reserve;
932: fa_track_member_pvt.p_track_member_table(i).adjusted_cost;
933: trc_fully_rsv_salvage_value := trc_fully_rsv_salvage_value +
934: fa_track_member_pvt.p_track_member_table(i).salvage_value;
935: trc_fully_rsv_recoverable_cost := trc_fully_rsv_recoverable_cost +
936: fa_track_member_pvt.p_track_member_table(i).recoverable_cost;
937: trc_fully_rsv_deprn_reserve := trc_fully_rsv_deprn_reserve +
938: fa_track_member_pvt.p_track_member_table(i).deprn_reserve;
939:
940: end if;
934: fa_track_member_pvt.p_track_member_table(i).salvage_value;
935: trc_fully_rsv_recoverable_cost := trc_fully_rsv_recoverable_cost +
936: fa_track_member_pvt.p_track_member_table(i).recoverable_cost;
937: trc_fully_rsv_deprn_reserve := trc_fully_rsv_deprn_reserve +
938: fa_track_member_pvt.p_track_member_table(i).deprn_reserve;
939:
940: end if;
941:
942: END LOOP;
968: close MIN_TRC_PERIOD;
969:
970: else -- used_by_adjustment 'ADJUSTMENT'
971:
972: FOR i IN 1 .. fa_track_member_pvt.p_track_member_table.COUNT LOOP
973: if fa_track_member_pvt.p_track_member_table(i).group_asset_id
974: = px_rule_in.asset_id and
975: fa_track_member_pvt.p_track_member_table(i).period_counter
976: <= px_rule_in.period_counter and
969:
970: else -- used_by_adjustment 'ADJUSTMENT'
971:
972: FOR i IN 1 .. fa_track_member_pvt.p_track_member_table.COUNT LOOP
973: if fa_track_member_pvt.p_track_member_table(i).group_asset_id
974: = px_rule_in.asset_id and
975: fa_track_member_pvt.p_track_member_table(i).period_counter
976: <= px_rule_in.period_counter and
977: nvl(fa_track_member_pvt.p_track_member_table(i).fully_reserved_flag,'N') = 'Y' then
971:
972: FOR i IN 1 .. fa_track_member_pvt.p_track_member_table.COUNT LOOP
973: if fa_track_member_pvt.p_track_member_table(i).group_asset_id
974: = px_rule_in.asset_id and
975: fa_track_member_pvt.p_track_member_table(i).period_counter
976: <= px_rule_in.period_counter and
977: nvl(fa_track_member_pvt.p_track_member_table(i).fully_reserved_flag,'N') = 'Y' then
978:
979: trc_fully_rsv_adjusted_cost := trc_fully_rsv_adjusted_cost +
973: if fa_track_member_pvt.p_track_member_table(i).group_asset_id
974: = px_rule_in.asset_id and
975: fa_track_member_pvt.p_track_member_table(i).period_counter
976: <= px_rule_in.period_counter and
977: nvl(fa_track_member_pvt.p_track_member_table(i).fully_reserved_flag,'N') = 'Y' then
978:
979: trc_fully_rsv_adjusted_cost := trc_fully_rsv_adjusted_cost +
980: fa_track_member_pvt.p_track_member_table(i).adjusted_cost;
981: trc_fully_rsv_salvage_value := trc_fully_rsv_salvage_value +
976: <= px_rule_in.period_counter and
977: nvl(fa_track_member_pvt.p_track_member_table(i).fully_reserved_flag,'N') = 'Y' then
978:
979: trc_fully_rsv_adjusted_cost := trc_fully_rsv_adjusted_cost +
980: fa_track_member_pvt.p_track_member_table(i).adjusted_cost;
981: trc_fully_rsv_salvage_value := trc_fully_rsv_salvage_value +
982: fa_track_member_pvt.p_track_member_table(i).salvage_value;
983: trc_fully_rsv_recoverable_cost := trc_fully_rsv_recoverable_cost +
984: fa_track_member_pvt.p_track_member_table(i).recoverable_cost;
978:
979: trc_fully_rsv_adjusted_cost := trc_fully_rsv_adjusted_cost +
980: fa_track_member_pvt.p_track_member_table(i).adjusted_cost;
981: trc_fully_rsv_salvage_value := trc_fully_rsv_salvage_value +
982: fa_track_member_pvt.p_track_member_table(i).salvage_value;
983: trc_fully_rsv_recoverable_cost := trc_fully_rsv_recoverable_cost +
984: fa_track_member_pvt.p_track_member_table(i).recoverable_cost;
985: trc_fully_rsv_deprn_reserve := trc_fully_rsv_deprn_reserve +
986: fa_track_member_pvt.p_track_member_table(i).deprn_reserve;
980: fa_track_member_pvt.p_track_member_table(i).adjusted_cost;
981: trc_fully_rsv_salvage_value := trc_fully_rsv_salvage_value +
982: fa_track_member_pvt.p_track_member_table(i).salvage_value;
983: trc_fully_rsv_recoverable_cost := trc_fully_rsv_recoverable_cost +
984: fa_track_member_pvt.p_track_member_table(i).recoverable_cost;
985: trc_fully_rsv_deprn_reserve := trc_fully_rsv_deprn_reserve +
986: fa_track_member_pvt.p_track_member_table(i).deprn_reserve;
987:
988: end if;
982: fa_track_member_pvt.p_track_member_table(i).salvage_value;
983: trc_fully_rsv_recoverable_cost := trc_fully_rsv_recoverable_cost +
984: fa_track_member_pvt.p_track_member_table(i).recoverable_cost;
985: trc_fully_rsv_deprn_reserve := trc_fully_rsv_deprn_reserve +
986: fa_track_member_pvt.p_track_member_table(i).deprn_reserve;
987:
988: end if;
989:
990: END LOOP;
988: end if;
989:
990: END LOOP;
991:
992: FOR i IN 1 .. fa_track_member_pvt.p_track_member_table.COUNT LOOP
993: if fa_track_member_pvt.p_track_member_table(i).period_counter <
994: nvl(l_trc_min_period_counter,
995: fa_track_member_pvt.p_track_member_table(i).period_counter+1) and
996: fa_track_member_pvt.p_track_member_table(i).member_asset_id is not null then
989:
990: END LOOP;
991:
992: FOR i IN 1 .. fa_track_member_pvt.p_track_member_table.COUNT LOOP
993: if fa_track_member_pvt.p_track_member_table(i).period_counter <
994: nvl(l_trc_min_period_counter,
995: fa_track_member_pvt.p_track_member_table(i).period_counter+1) and
996: fa_track_member_pvt.p_track_member_table(i).member_asset_id is not null then
997:
991:
992: FOR i IN 1 .. fa_track_member_pvt.p_track_member_table.COUNT LOOP
993: if fa_track_member_pvt.p_track_member_table(i).period_counter <
994: nvl(l_trc_min_period_counter,
995: fa_track_member_pvt.p_track_member_table(i).period_counter+1) and
996: fa_track_member_pvt.p_track_member_table(i).member_asset_id is not null then
997:
998: l_trc_min_period_counter := fa_track_member_pvt.p_track_member_table(i).period_counter;
999: end if;
992: FOR i IN 1 .. fa_track_member_pvt.p_track_member_table.COUNT LOOP
993: if fa_track_member_pvt.p_track_member_table(i).period_counter <
994: nvl(l_trc_min_period_counter,
995: fa_track_member_pvt.p_track_member_table(i).period_counter+1) and
996: fa_track_member_pvt.p_track_member_table(i).member_asset_id is not null then
997:
998: l_trc_min_period_counter := fa_track_member_pvt.p_track_member_table(i).period_counter;
999: end if;
1000: END LOOP;
994: nvl(l_trc_min_period_counter,
995: fa_track_member_pvt.p_track_member_table(i).period_counter+1) and
996: fa_track_member_pvt.p_track_member_table(i).member_asset_id is not null then
997:
998: l_trc_min_period_counter := fa_track_member_pvt.p_track_member_table(i).period_counter;
999: end if;
1000: END LOOP;
1001:
1002: if l_trc_min_period_counter is null then