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

Line 42: from fa_deprn_periods

38: CURSOR current_period_info IS
39: select greatest(calendar_period_open_date,
40: least(sysdate, calendar_period_close_date)),
41: calendar_period_close_date, calendar_period_open_date
42: from fa_deprn_periods
43: where book_type_code = x_book
44: and period_close_date is null;
45:
46: begin

Line 131: from fa_deprn_periods pdp, fa_deprn_periods adp

127:
128:
129: select count(*)
130: into h_count
131: from fa_deprn_periods pdp, fa_deprn_periods adp
132: where pdp.book_type_code = x_book
133: and pdp.book_type_code = adp.book_type_code
134: and pdp.period_counter > adp.period_counter
135: and h_prior_date_effective between pdp.period_open_date

Line 163: from fa_deprn_periods

159: -- get the latest available date
160: select greatest(calendar_period_open_date,
161: least(SYSDATE, calendar_period_close_date))
162: into h_amort_date
163: from fa_deprn_periods
164: where book_type_code = X_book
165: and h_prior_date_effective between
166: period_open_date and
167: nvl(period_close_date,sysdate);