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

Line 186: FROM fa_deprn_periods

182: WHERE fdd.distribution_id = cp_distribution_id
183: AND fdd.book_type_code = cp_book_type_code
184: AND fdd.asset_id = cp_asset_id
185: AND fdd.period_counter IN (SELECT period_counter
186: FROM fa_deprn_periods
187: WHERE book_type_code = cp_book_type_code
188: AND fiscal_year = (SELECT fiscal_year
189: FROM fa_deprn_periods
190: WHERE period_close_date IS NULL

Line 189: FROM fa_deprn_periods

185: AND fdd.period_counter IN (SELECT period_counter
186: FROM fa_deprn_periods
187: WHERE book_type_code = cp_book_type_code
188: AND fiscal_year = (SELECT fiscal_year
189: FROM fa_deprn_periods
190: WHERE period_close_date IS NULL
191: AND book_type_code = cp_book_type_code))
192: GROUP BY fdd.distribution_id;
193: /* Bug 2906934 vgadde 25/04/2003 End(1) */

Line 280: FROM fa_deprn_periods

276: WHERE fdd.distribution_id = cp_distribution_id
277: AND fdd.book_type_code = cp_book_type_code
278: AND fdd.asset_id = cp_asset_id
279: AND fdd.period_counter = (SELECT period_counter
280: FROM fa_deprn_periods
281: WHERE book_type_code = cp_book_type_code
282: AND period_counter = cp_period_counter
283: AND fiscal_year = (SELECT fiscal_year
284: FROM fa_deprn_periods

Line 284: FROM fa_deprn_periods

280: FROM fa_deprn_periods
281: WHERE book_type_code = cp_book_type_code
282: AND period_counter = cp_period_counter
283: AND fiscal_year = (SELECT fiscal_year
284: FROM fa_deprn_periods
285: WHERE period_close_date IS NULL
286: AND book_type_code = cp_book_type_code)) ;
287: -- GROUP BY fdd.asset_id,fdd.distribution_id;
288: -- bug 2480915, end (1)