211:
212: x_transaction_header_id_in fa_transaction_headers.transaction_header_id%TYPE;
213: x_transaction_header_id_out fa_transaction_headers.transaction_header_id%TYPE;
214: x_date_effective fa_transaction_headers.date_effective%TYPE;
215: x_category_id fa_asset_history.category_id%TYPE;
216: x_prior_category_id fa_asset_history.category_id%TYPE;
217: x_old_category_id fa_asset_history.category_id%TYPE;
218: x_asset_id fa_additions.asset_id%TYPE;
219:
212: x_transaction_header_id_in fa_transaction_headers.transaction_header_id%TYPE;
213: x_transaction_header_id_out fa_transaction_headers.transaction_header_id%TYPE;
214: x_date_effective fa_transaction_headers.date_effective%TYPE;
215: x_category_id fa_asset_history.category_id%TYPE;
216: x_prior_category_id fa_asset_history.category_id%TYPE;
217: x_old_category_id fa_asset_history.category_id%TYPE;
218: x_asset_id fa_additions.asset_id%TYPE;
219:
220: x_distribution_id fa_distribution_history.distribution_id%TYPE;
213: x_transaction_header_id_out fa_transaction_headers.transaction_header_id%TYPE;
214: x_date_effective fa_transaction_headers.date_effective%TYPE;
215: x_category_id fa_asset_history.category_id%TYPE;
216: x_prior_category_id fa_asset_history.category_id%TYPE;
217: x_old_category_id fa_asset_history.category_id%TYPE;
218: x_asset_id fa_additions.asset_id%TYPE;
219:
220: x_distribution_id fa_distribution_history.distribution_id%TYPE;
221: x_debit_credit_flag fa_adjustments.debit_credit_flag%TYPE;
338: bk.rowid book_rowid
339: FROM fa_transaction_headers th,
340: fa_deprn_periods dp,
341: fa_additions ad,
342: fa_asset_history ah,
343: fa_books bk
344: WHERE dp.book_type_code = pc_tax_book
345: AND dp.period_counter = pc_period_counter
346: AND th.book_type_code = dp.book_type_code
384: bk.rowid
385: FROM fa_transaction_headers th,
386: fa_deprn_periods dp,
387: fa_additions ad,
388: fa_asset_history ah,
389: fa_books bk
390: WHERE dp.book_type_code = pc_corporate_book
391: AND dp.period_counter = pc_period_counter
392: AND th.book_type_code = dp.book_type_code
456: pc_transaction_header_id IN NUMBER
457: )
458: IS
459: SELECT category_id
460: FROM fa_asset_history
461: WHERE asset_id = pc_asset_id
462: AND transaction_header_id_out = pc_transaction_header_id;
463:
464: -----------------------------------------------------------------------------
727: bk.transaction_header_id_in,
728: fnd_number.canonical_to_number(nvl (bk.global_attribute7,0)) deprn_to_cost,
729: bk.rowid book_rowid
730: FROM fa_additions ad,
731: fa_asset_history ah,
732: fa_books bk,
733: fa_deprn_summary ds
734: WHERE ds.book_type_code = pc_book_type_code
735: AND ds.period_counter = pc_period_counter