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

Line 71: , fa_deprn_periods fdp

67: fa_transaction_history_trx_v fthv
68: , fa_distribution_history fdh
69: , gl_code_combinations expense_cc
70: , fa_book_controls_sec fbc
71: , fa_deprn_periods fdp
72: WHERE
73: fthv.book_type_code = fbc.book_type_code
74: AND fbc.book_class IN('CORPORATE', 'TAX')
75: AND fbc.gl_posting_allowed_flag = 'YES'

Line 81: FROM fa_deprn_periods dp

77: AND
78: ((SELECT greatest(greatest(dp.calendar_period_open_date,
79: least(sysdate, dp.calendar_period_close_date)),
80: dp.calendar_period_open_date)
81: FROM fa_deprn_periods dp
82: WHERE fthv.book_type_code = dp.book_type_code
83: AND fthv.date_effective BETWEEN dp.period_open_date AND
84: nvl(dp.period_close_date, SYSDATE)) BETWEEN ld_start_date AND ld_end_date)
85: AND fthv.asset_id = fdh.asset_id