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 41: from fa_deprn_periods

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

Line 128: from fa_deprn_periods pdp, fa_deprn_periods adp

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

Line 160: from fa_deprn_periods

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