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

Line 125: FROM FA_DEPRN_PERIODS fdp

121: WHERE fdh.asset_id = fth.asset_id
122: AND fth.transaction_type_code NOT IN ('FULL RETIREMENT')
123: AND EXISTS
124: (SELECT fdp.period_close_date
125: FROM FA_DEPRN_PERIODS fdp
126: WHERE fdp.book_type_code = fbcs.book_type_code
127: AND fdp.calendar_period_close_date BETWEEN ld_start_date AND
128: ld_end_date
129: AND fdp.period_close_date IS NOT NULL)

Line 132: FROM FA_DEPRN_PERIODS fdp

128: ld_end_date
129: AND fdp.period_close_date IS NOT NULL)
130: AND fdh.date_effective <
131: nvl((SELECT MAX(fdp.period_close_date)
132: FROM FA_DEPRN_PERIODS fdp
133: WHERE fdp.book_type_code = fbcs.book_type_code
134: AND fdp.calendar_period_close_date <= ld_end_date
135: AND fdp.period_close_date IS NOT NULL),
136: SYSDATE)

Line 139: FROM FA_DEPRN_PERIODS fdp

135: AND fdp.period_close_date IS NOT NULL),
136: SYSDATE)
137: AND (fdh.date_ineffective >
138: nvl((SELECT MAX(fdp.period_close_date)
139: FROM FA_DEPRN_PERIODS fdp
140: WHERE fdp.book_type_code = fbcs.book_type_code
141: AND fdp.calendar_period_close_date <= ld_end_date
142: AND fdp.period_close_date IS NOT NULL),
143: SYSDATE) OR fdh.date_ineffective IS NULL)