eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FA_CALC_DEPRN_BASIS2_PKG dependencies on FA_TRACK_MEMBERS

Line 469: from FA_TRACK_MEMBERS TRC

465: select nvl(sum(TRC.adjusted_cost),0) fully_rsv_adjusted_cost,
466: nvl(sum(TRC.salvage_value),0) fully_rsv_salvage_value,
467: nvl(sum(TRC.recoverable_cost),0) fully_rsv_recoverable_cost,
468: nvl(sum(TRC.deprn_reserve),0) fully_rsv_deprn_reserve
469: from FA_TRACK_MEMBERS TRC
470: where TRC.GROUP_ASSET_ID = px_rule_in.asset_id
471: and TRC.PERIOD_COUNTER <= p_period_counter
472: and TRC.FULLY_RESERVED_FLAG='Y'
473: and nvl(TRC.SET_OF_BOOKS_ID,-99) = nvl(h_set_of_books_id,-99) /*Bug# 7462260 Added filter conition for MRC */

Line 482: from FA_TRACK_MEMBERS TRC

478: select nvl(sum(TRC.adjusted_cost),0) fully_rsv_adjusted_cost,
479: nvl(sum(TRC.salvage_value),0) fully_rsv_salvage_value,
480: nvl(sum(TRC.recoverable_cost),0) fully_rsv_recoverable_cost,
481: nvl(sum(TRC.deprn_reserve),0) fully_rsv_deprn_reserve
482: from FA_TRACK_MEMBERS TRC
483: where TRC.GROUP_ASSET_ID = px_rule_in.asset_id
484: and TRC.PERIOD_COUNTER = p_period_counter
485: and TRC.FULLY_RESERVED_FLAG='Y'
486: and nvl(TRC.SET_OF_BOOKS_ID,-99) = nvl(h_set_of_books_id,-99) /*Bug# 7462260 Added filter conition for MRC */

Line 492: from FA_TRACK_MEMBERS TRC

488:
489: cursor MIN_TRC_PERIOD
490: is
491: select min(TRC.period_counter)
492: from FA_TRACK_MEMBERS TRC
493: where TRC.GROUP_ASSET_ID = px_rule_in.asset_id
494: and TRC.MEMBER_ASSET_ID is not null
495: and nvl(TRC.SET_OF_BOOKS_ID,-99) = nvl(h_set_of_books_id,-99); /*Bug# 7462260 Added filter conition for MRC */
496:

Line 610: trc_fully_rsv_adjusted_cost NUMBER :=0; -- Summary of Fully reserved member's adjusted cost from FA_TRACK_MEMBERS

606: l_fully_rsv_salvage_value NUMBER :=0; -- Summary of Fully reserved member's salvage value
607: l_fully_rsv_recoverable_cost NUMBER :=0; -- Summary of Fully reserved member's recoverable cost
608: l_fully_rsv_deprn_reserve NUMBER :=0; -- Summary of Fully reserved member's deprn reserve
609:
610: trc_fully_rsv_adjusted_cost NUMBER :=0; -- Summary of Fully reserved member's adjusted cost from FA_TRACK_MEMBERS
611: trc_fully_rsv_salvage_value NUMBER :=0; -- Summary of Fully reserved member's salvage value from FA_TRACK_MEMBERS
612: trc_fully_rsv_recoverable_cost NUMBER :=0; -- Summary of Fully reserved member's recoverable cost from FA_TRACK_MEMBERS
613: trc_fully_rsv_deprn_reserve NUMBER :=0; -- Summary of Fully reserved member's deprn reserve from FA_TRACK_MEMBERS
614:

Line 611: trc_fully_rsv_salvage_value NUMBER :=0; -- Summary of Fully reserved member's salvage value from FA_TRACK_MEMBERS

607: l_fully_rsv_recoverable_cost NUMBER :=0; -- Summary of Fully reserved member's recoverable cost
608: l_fully_rsv_deprn_reserve NUMBER :=0; -- Summary of Fully reserved member's deprn reserve
609:
610: trc_fully_rsv_adjusted_cost NUMBER :=0; -- Summary of Fully reserved member's adjusted cost from FA_TRACK_MEMBERS
611: trc_fully_rsv_salvage_value NUMBER :=0; -- Summary of Fully reserved member's salvage value from FA_TRACK_MEMBERS
612: trc_fully_rsv_recoverable_cost NUMBER :=0; -- Summary of Fully reserved member's recoverable cost from FA_TRACK_MEMBERS
613: trc_fully_rsv_deprn_reserve NUMBER :=0; -- Summary of Fully reserved member's deprn reserve from FA_TRACK_MEMBERS
614:
615: bk_fully_rsv_adjusted_cost NUMBER :=0; -- Summary of Fully reserved member's adjusted cost from FA_BOOKS

Line 612: trc_fully_rsv_recoverable_cost NUMBER :=0; -- Summary of Fully reserved member's recoverable cost from FA_TRACK_MEMBERS

608: l_fully_rsv_deprn_reserve NUMBER :=0; -- Summary of Fully reserved member's deprn reserve
609:
610: trc_fully_rsv_adjusted_cost NUMBER :=0; -- Summary of Fully reserved member's adjusted cost from FA_TRACK_MEMBERS
611: trc_fully_rsv_salvage_value NUMBER :=0; -- Summary of Fully reserved member's salvage value from FA_TRACK_MEMBERS
612: trc_fully_rsv_recoverable_cost NUMBER :=0; -- Summary of Fully reserved member's recoverable cost from FA_TRACK_MEMBERS
613: trc_fully_rsv_deprn_reserve NUMBER :=0; -- Summary of Fully reserved member's deprn reserve from FA_TRACK_MEMBERS
614:
615: bk_fully_rsv_adjusted_cost NUMBER :=0; -- Summary of Fully reserved member's adjusted cost from FA_BOOKS
616: bk_fully_rsv_salvage_value NUMBER :=0; -- Summary of Fully reserved member's salvage value from FA_BOOKS

Line 613: trc_fully_rsv_deprn_reserve NUMBER :=0; -- Summary of Fully reserved member's deprn reserve from FA_TRACK_MEMBERS

609:
610: trc_fully_rsv_adjusted_cost NUMBER :=0; -- Summary of Fully reserved member's adjusted cost from FA_TRACK_MEMBERS
611: trc_fully_rsv_salvage_value NUMBER :=0; -- Summary of Fully reserved member's salvage value from FA_TRACK_MEMBERS
612: trc_fully_rsv_recoverable_cost NUMBER :=0; -- Summary of Fully reserved member's recoverable cost from FA_TRACK_MEMBERS
613: trc_fully_rsv_deprn_reserve NUMBER :=0; -- Summary of Fully reserved member's deprn reserve from FA_TRACK_MEMBERS
614:
615: bk_fully_rsv_adjusted_cost NUMBER :=0; -- Summary of Fully reserved member's adjusted cost from FA_BOOKS
616: bk_fully_rsv_salvage_value NUMBER :=0; -- Summary of Fully reserved member's salvage value from FA_BOOKS
617: bk_fully_rsv_recoverable_cost NUMBER :=0; -- Summary of Fully reserved member's recoverable cost from FA_BOOKS

Line 622: l_trc_min_period_counter NUMBER :=null; -- Minimum period counter on FA_TRACK_MEMBERS

618: bk_fully_rsv_deprn_reserve NUMBER :=0; -- Summary of Fully reserved member's deprn reserve from FA_BOOKS
619:
620: l_exclude_fully_rsv_flag VARCHAR2(1); -- Exclude fully Reserved flag
621: l_exclude_salvage_value_flag VARCHAR2(3); -- Exclude salvage value flag
622: l_trc_min_period_counter NUMBER :=null; -- Minimum period counter on FA_TRACK_MEMBERS
623: l_mem_ret_adj_cost NUMBER :=0; -- Member retirement adjusted cost
624:
625: l_calling_fn VARCHAR2(50) := 'fa_calc_deprn_basis2_pkg.flat_extension';
626: l_function VARCHAR2(20) := 'flat_extension';

Line 1131: -- Query fully Reserved member assets info from FA_TRACK_MEMBERS

1127: else -- Not use old_adjusted_cost
1128:
1129: if nvl(px_rule_in.used_by_adjustment,'NULL') <> 'ADJUSTMENT' then
1130: --
1131: -- Query fully Reserved member assets info from FA_TRACK_MEMBERS
1132: --
1133: open FULL_RSV_MEMBER_TRC (px_rule_in.period_counter);
1134: fetch FULL_RSV_MEMBER_TRC into trc_fully_rsv_adjusted_cost,
1135: trc_fully_rsv_salvage_value,

Line 1141: -- Query Minimum period counter on FA_TRACK_MEMBERS

1137: trc_fully_rsv_deprn_reserve;
1138: close FULL_RSV_MEMBER_TRC;
1139:
1140: --
1141: -- Query Minimum period counter on FA_TRACK_MEMBERS
1142: --
1143: open MIN_TRC_PERIOD;
1144: fetch MIN_TRC_PERIOD into l_trc_min_period_counter;
1145: