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 1151: and fdd.period_counter in (select period_counter from fa_deprn_periods

1147: from fa_deprn_detail fdd
1148: where fdd.book_type_code = fp_reval_params.reval_asset_params.book_type_code
1149: and fdd.asset_id = fp_reval_params.reval_asset_params.asset_id
1150: and fdd.distribution_id = cp_distribution_id
1151: and fdd.period_counter in (select period_counter from fa_deprn_periods
1152: where book_type_code = fp_reval_params.reval_asset_params.book_type_code
1153: and fiscal_year = (select decode(period_num,1,fiscal_year-1,fiscal_year)
1154: from fa_deprn_periods
1155: where period_close_date is NULL

Line 1154: from fa_deprn_periods

1150: and fdd.distribution_id = cp_distribution_id
1151: and fdd.period_counter in (select period_counter from fa_deprn_periods
1152: where book_type_code = fp_reval_params.reval_asset_params.book_type_code
1153: and fiscal_year = (select decode(period_num,1,fiscal_year-1,fiscal_year)
1154: from fa_deprn_periods
1155: where period_close_date is NULL
1156: and book_type_code = fp_reval_params.reval_asset_params.book_type_code))
1157: group by fdd.asset_id,fdd.distribution_id;
1158: