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.IGI_IAC_YTD_PRE_PROCESS_PKG dependencies on FA_DEPRN_DETAIL

Line 25: from fa_deprn_detail fdd

21: cursor c_get_dist_ytd(cp_book_type_code varchar2,
22: cp_asset_id number,
23: cp_distribution_id number) is
24: select sum(nvl(fdd.deprn_amount,0)-nvl(fdd.deprn_adjustment_amount,0)) deprn_YTD
25: from fa_deprn_detail fdd
26: where fdd.distribution_id = cp_distribution_id
27: and fdd.book_type_code like cp_book_type_code
28: and fdd.asset_id = cp_asset_id
29: and fdd.period_counter in (select period_counter from fa_deprn_periods

Line 46: from fa_deprn_detail

42: cursor c_get_dist_deprn(cp_asset_id number,cp_distribution_id number) is
43: select (nvl(deprn_amount,0) - nvl(deprn_adjustment_amount,0)) deprn_amount,
44: deprn_reserve,
45: period_counter
46: from fa_deprn_detail
47: where book_type_code = p_book_type_code
48: and asset_id = cp_asset_id
49: and distribution_id = cp_distribution_id
50: and period_counter = (select max(period_counter)