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.CSE_ASSET_UTIL_PKG dependencies on FA_DEPRN_PERIODS

Line 1770: from fa_deprn_periods dp,

1766: CURSOR c_curr_dep_prd (c_book_type_code IN varchar) IS
1767: Select dp.period_name,
1768: bc.last_deprn_run_date,
1769: bc.deprn_calendar
1770: from fa_deprn_periods dp,
1771: fa_deprn_periods dp2,
1772: fa_deprn_periods dp3,
1773: fa_book_controls bc
1774: where dp.book_type_code =c_book_type_code

Line 1771: fa_deprn_periods dp2,

1767: Select dp.period_name,
1768: bc.last_deprn_run_date,
1769: bc.deprn_calendar
1770: from fa_deprn_periods dp,
1771: fa_deprn_periods dp2,
1772: fa_deprn_periods dp3,
1773: fa_book_controls bc
1774: where dp.book_type_code =c_book_type_code
1775: and dp.period_close_date is null

Line 1772: fa_deprn_periods dp3,

1768: bc.last_deprn_run_date,
1769: bc.deprn_calendar
1770: from fa_deprn_periods dp,
1771: fa_deprn_periods dp2,
1772: fa_deprn_periods dp3,
1773: fa_book_controls bc
1774: where dp.book_type_code =c_book_type_code
1775: and dp.period_close_date is null
1776: and dp2.book_type_code(+) = bc.distribution_source_book

Line 2397: fa_deprn_periods dp

2393: IS
2394: SELECT 'N'
2395: FROM fa_transaction_headers th,
2396: fa_book_controls bc,
2397: fa_deprn_periods dp
2398: WHERE th.asset_id = p_asset_id
2399: AND th.book_type_code = p_book_type_code
2400: AND bc.book_type_code = th.book_type_code
2401: AND th.transaction_type_code||''