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_REVAL_CRUD dependencies on FA_DEPRN_PERIODS

Line 1167: and fdd.period_counter in (select period_counter from fa_deprn_periods

1163: from fa_deprn_detail fdd
1164: where fdd.book_type_code = fp_reval_params.reval_asset_params.book_type_code
1165: and fdd.asset_id = fp_reval_params.reval_asset_params.asset_id
1166: and fdd.distribution_id = cp_distribution_id
1167: and fdd.period_counter in (select period_counter from fa_deprn_periods
1168: where book_type_code = fp_reval_params.reval_asset_params.book_type_code
1169: and fiscal_year = (select decode(period_num,1,fiscal_year-1,fiscal_year)
1170: from fa_deprn_periods
1171: where period_close_date is NULL

Line 1170: from fa_deprn_periods

1166: and fdd.distribution_id = cp_distribution_id
1167: and fdd.period_counter in (select period_counter from fa_deprn_periods
1168: where book_type_code = fp_reval_params.reval_asset_params.book_type_code
1169: and fiscal_year = (select decode(period_num,1,fiscal_year-1,fiscal_year)
1170: from fa_deprn_periods
1171: where period_close_date is NULL
1172: and book_type_code = fp_reval_params.reval_asset_params.book_type_code))
1173: group by fdd.asset_id,fdd.distribution_id;
1174: