270: max(dp.period_counter)
271: INTO l_transaction_header_id,
272: l_period_counter
273: FROM fa_books fb ,
274: fa_calendar_periods cp ,
275: fa_deprn_periods dp ,
276: fa_transaction_headers th ,
277: fa_asset_history ah ,
278: fa_additions ad ,
298: BEGIN
299: SELECT fb.cost
300: INTO p_asset_cost
301: FROM fa_books_mrc_v fb ,
302: fa_calendar_periods cp ,
303: fa_deprn_periods_mrc_v dp ,
304: fa_transaction_headers th ,
305: fa_asset_history ah ,
306: fa_additions ad ,
326: BEGIN
327: SELECT fb.cost
328: INTO p_asset_cost
329: FROM fa_books fb ,
330: fa_calendar_periods cp ,
331: fa_deprn_periods dp ,
332: fa_transaction_headers th ,
333: fa_asset_history ah ,
334: fa_additions ad ,