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 1960: from fa_deprn_periods dp,

1956: CURSOR c_curr_dep_prd (c_book_type_code IN varchar) IS
1957: Select dp.period_name,
1958: bc.last_deprn_run_date,
1959: bc.deprn_calendar
1960: from fa_deprn_periods dp,
1961: fa_deprn_periods dp2,
1962: fa_deprn_periods dp3,
1963: fa_book_controls bc
1964: where dp.book_type_code =c_book_type_code

Line 1961: fa_deprn_periods dp2,

1957: Select dp.period_name,
1958: bc.last_deprn_run_date,
1959: bc.deprn_calendar
1960: from fa_deprn_periods dp,
1961: fa_deprn_periods dp2,
1962: fa_deprn_periods dp3,
1963: fa_book_controls bc
1964: where dp.book_type_code =c_book_type_code
1965: and dp.period_close_date is null

Line 1962: fa_deprn_periods dp3,

1958: bc.last_deprn_run_date,
1959: bc.deprn_calendar
1960: from fa_deprn_periods dp,
1961: fa_deprn_periods dp2,
1962: fa_deprn_periods dp3,
1963: fa_book_controls bc
1964: where dp.book_type_code =c_book_type_code
1965: and dp.period_close_date is null
1966: and dp2.book_type_code(+) = bc.distribution_source_book

Line 2661: fa_deprn_periods dp

2657: IS
2658: SELECT 'N'
2659: FROM fa_transaction_headers th,
2660: fa_book_controls bc,
2661: fa_deprn_periods dp
2662: WHERE th.asset_id = p_asset_id
2663: AND th.book_type_code = p_book_type_code
2664: AND bc.book_type_code = th.book_type_code
2665: AND th.transaction_type_code||''