APPS.JL_ZZ_FA_CALC_ADJUSTMENT_PKG dependencies on FA_DEPRN_SUMMARY

Line 191: FROM fa_deprn_summary dsc,

187:
188: IF (p_mode = 'CC') THEN
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

Line 213: FROM fa_deprn_summary dsc,

209:
210: IF (p_mode = 'CO') THEN
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

Line 234: FROM fa_deprn_summary dsc,

230:
231: IF (p_mode = 'OO') THEN
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

Line 293: FROM fa_deprn_summary dsc,

289:
290: IF (p_mode = 'CC') THEN
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

Line 315: FROM fa_deprn_summary dsc,

311:
312: IF (p_mode = 'CO') THEN
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

Line 336: FROM fa_deprn_summary dsc,

332:
333: IF (p_mode = 'OO') THEN
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