APPS.JA_AU_FA_BAL_CHG dependencies on FA_DEPRN_SUMMARY

Line 274: from fa_deprn_summary ds

270:
271: update ja_au_srw_tax_deprn_tmp t
272: set deprn_rsrve_start =
273: (select deprn_reserve
274: from fa_deprn_summary ds
275: where ds.asset_id = t.asset_id
276: and ds.period_counter =
277: (select max(dp2.period_counter)
278: from fa_deprn_summary ds2,

Line 278: from fa_deprn_summary ds2,

274: from fa_deprn_summary ds
275: where ds.asset_id = t.asset_id
276: and ds.period_counter =
277: (select max(dp2.period_counter)
278: from fa_deprn_summary ds2,
279: fa_deprn_periods dp2
280: where ds2.asset_id = t.asset_id
281: and ds2.period_counter = dp2.period_counter
282: and ds2.book_type_code = v_book_type_code

Line 292: from fa_deprn_summary ds

288:
289: update ja_au_srw_tax_deprn_tmp t
290: set deprn_rsrve_end =
291: (select deprn_reserve
292: from fa_deprn_summary ds
293: where ds.asset_id = t.asset_id
294: and ds.period_counter =
295: (select max(dp2.period_counter)
296: from fa_deprn_summary ds2,

Line 296: from fa_deprn_summary ds2,

292: from fa_deprn_summary ds
293: where ds.asset_id = t.asset_id
294: and ds.period_counter =
295: (select max(dp2.period_counter)
296: from fa_deprn_summary ds2,
297: fa_deprn_periods dp2
298: where ds2.asset_id = t.asset_id
299: and ds2.period_counter = dp2.period_counter
300: and ds2.book_type_code = v_book_type_code

Line 311: from fa_deprn_summary ds,

307:
308: update ja_au_srw_tax_deprn_tmp t
309: set deprn_amount =
310: (select sum(ds.deprn_amount)
311: from fa_deprn_summary ds,
312: fa_deprn_periods dp
313: where ds.asset_id = t.asset_id
314: and ds.period_counter = dp.period_counter
315: and ds.book_type_code = v_book_type_code