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_GROUP_RECLASS2_PVT dependencies on FA_DEPRN_SUMMARY

Line 2122: from fa_deprn_summary ds1,

2118:
2119: --* Cursor to populate the member level amounts
2120: cursor MEM_EXP_RESERVE is
2121: select ds1.deprn_reserve,ds1.ytd_deprn,dp1.fiscal_year
2122: from fa_deprn_summary ds1,
2123: fa_deprn_periods dp1
2124: where ds1.book_type_code = h_book_type_code
2125: and ds1.asset_id = h_member_asset_id
2126: and dp1.book_type_code = ds1.book_type_Code

Line 2130: from fa_deprn_summary ds2

2126: and dp1.book_type_code = ds1.book_type_Code
2127: and dp1.period_counter = ds1.period_counter
2128: and ds1.period_counter =
2129: (select max(period_counter)
2130: from fa_deprn_summary ds2
2131: where ds2.book_type_code = h_book_type_code
2132: and ds2.asset_id = h_member_asset_id
2133: and period_counter <= h_period_counter);
2134:

Line 2146: from fa_deprn_summary ds2

2142: and dp1.period_counter = ds1.period_counter
2143: and dp1.set_of_books_id = h_set_of_books_id
2144: and ds1.period_counter =
2145: (select max(period_counter)
2146: from fa_deprn_summary ds2
2147: where ds2.book_type_code = h_book_type_code
2148: and ds2.asset_id = h_member_asset_id
2149: and period_counter <= h_period_counter)
2150: and ds1.set_of_books_id = h_set_of_books_id;