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.IGIRX_IMP_IAC_REP dependencies on FA_DEPRN_SUMMARY

Line 584: FROM fa_deprn_summary

580:
581: CURSOR C_ytd_asset(p_asset_id in number,p_max_period_counter in number,p_book_type_code in varchar2)
582: IS
583: SELECT ytd_deprn
584: FROM fa_deprn_summary
585: WHERE asset_id=p_asset_id AND
586: book_type_code=p_book_type_code AND
587: period_counter=p_max_period_counter-1;
588:

Line 592: FROM fa_deprn_summary ds, fa_deprn_periods dp

588:
589: CURSOR C_ytd_asset_non_dep(p_asset_id in number, p_book_type_code in varchar2)
590: IS
591: SELECT ytd_deprn,fiscal_year
592: FROM fa_deprn_summary ds, fa_deprn_periods dp
593: WHERE ds.asset_id=p_asset_id AND
594: ds.book_type_code=p_book_type_code AND
595: ds.book_type_code = dp.book_type_code and
596: ds.period_counter= (select max(period_counter)

Line 597: from fa_deprn_summary

593: WHERE ds.asset_id=p_asset_id AND
594: ds.book_type_code=p_book_type_code AND
595: ds.book_type_code = dp.book_type_code and
596: ds.period_counter= (select max(period_counter)
597: from fa_deprn_summary
598: where asset_id=p_asset_id
599: and book_type_code=p_book_type_code )
600: and ds.period_counter=dp.period_counter;
601: