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.JL_ZZ_FA_CALC_ADJUSTMENT_PKG dependencies on FA_BOOK_CONTROLS

Line 102: fa_book_controls bcc,

98: IF (p_mode = 'CC') THEN
99: SELECT bkc.cost
100: INTO x_cost
101: FROM fa_deprn_periods dpc,
102: fa_book_controls bcc,
103: fa_books bkc
104: WHERE bcc.book_type_code = p_book_type_code
105: AND dpc.book_type_code = bcc.book_type_code
106: AND dpc.period_counter <= bcc.last_period_counter

Line 120: fa_book_controls bcc,

116: IF (p_mode = 'CO') THEN
117: SELECT bkc.cost
118: INTO x_cost
119: FROM fa_deprn_periods dpc,
120: fa_book_controls bcc,
121: fa_books bkc
122: WHERE bcc.book_type_code = p_book_type_code
123: AND dpc.book_type_code = bcc.book_type_code
124: AND dpc.period_counter = bcc.last_period_counter

Line 137: fa_book_controls bcc,

133: IF (p_mode = 'OO') THEN
134: SELECT bkc.cost
135: INTO x_cost
136: FROM fa_deprn_periods dpc,
137: fa_book_controls bcc,
138: fa_books bkc
139: WHERE bcc.book_type_code = p_book_type_code
140: AND dpc.book_type_code = bcc.book_type_code
141: AND dpc.period_counter = bcc.last_period_counter + 1

Line 193: fa_book_controls bcc,

189: SELECT dsc.deprn_reserve
190: INTO x_deprn_reserve
191: FROM fa_deprn_summary dsc,
192: fa_deprn_periods dpc,
193: fa_book_controls bcc,
194: fa_books bkc
195: WHERE bcc.book_type_code = p_book_type_code
196: AND dpc.book_type_code = bcc.book_type_code
197: AND dpc.period_counter <= bcc.last_period_counter

Line 215: fa_book_controls bcc,

211: SELECT dsc.deprn_reserve
212: INTO x_deprn_reserve
213: FROM fa_deprn_summary dsc,
214: fa_deprn_periods dpc,
215: fa_book_controls bcc,
216: fa_books bkc
217: WHERE bcc.book_type_code = p_book_type_code
218: AND dpc.book_type_code = bcc.book_type_code
219: AND dpc.period_counter = bcc.last_period_counter

Line 236: fa_book_controls bcc,

232: SELECT dsc.deprn_reserve - jl_zz_fa_calc_adjustment_pkg.calc_adjustments (bcc.book_type_code, dpc.period_counter, p_asset_id, 'RESERVE', 'NET' )
233: INTO x_deprn_reserve
234: FROM fa_deprn_summary dsc,
235: fa_deprn_periods dpc,
236: fa_book_controls bcc,
237: fa_books bkc
238: WHERE bcc.book_type_code = p_book_type_code
239: AND dpc.book_type_code = bcc.book_type_code
240: AND dpc.period_counter = bcc.last_period_counter + 1

Line 295: fa_book_controls bcc,

291: SELECT dsc.ytd_deprn
292: INTO x_ytd_deprn
293: FROM fa_deprn_summary dsc,
294: fa_deprn_periods dpc,
295: fa_book_controls bcc,
296: fa_books bkc
297: WHERE bcc.book_type_code = p_book_type_code
298: AND dpc.book_type_code = bcc.book_type_code
299: AND dpc.period_counter <= bcc.last_period_counter

Line 317: fa_book_controls bcc,

313: SELECT dsc.ytd_deprn
314: INTO x_ytd_deprn
315: FROM fa_deprn_summary dsc,
316: fa_deprn_periods dpc,
317: fa_book_controls bcc,
318: fa_books bkc
319: WHERE bcc.book_type_code = p_book_type_code
320: AND dpc.book_type_code = bcc.book_type_code
321: AND dpc.period_counter = bcc.last_period_counter

Line 338: fa_book_controls bcc,

334: SELECT dsc.ytd_deprn + jl_zz_fa_calc_adjustment_pkg.calc_adjustments (bcc.book_type_code, dpc.period_counter, p_asset_id, 'EXPENSE', 'NET' )
335: INTO x_ytd_deprn
336: FROM fa_deprn_summary dsc,
337: fa_deprn_periods dpc,
338: fa_book_controls bcc,
339: fa_books bkc
340: WHERE bcc.book_type_code = p_book_type_code
341: AND dpc.book_type_code = bcc.book_type_code
342: AND dpc.period_counter = bcc.last_period_counter + 1