APPS.JL_CO_FA_ACCOUNTING_PKG dependencies on FA_DISTRIBUTION_HISTORY

Line 220: x_distribution_id fa_distribution_history.distribution_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;
222: x_code_combination_id fa_adjustments.code_combination_id%TYPE;
223: x_adjustment_amount fa_adjustments.adjustment_amount%TYPE;
224: x_adjustment_type fa_adjustments.adjustment_type%TYPE;

Line 695: FROM fa_distribution_history

691: IS
692: SELECT transaction_header_id_in
693: FROM fa_retirements
694: WHERE retirement_id = (SELECT retirement_id
695: FROM fa_distribution_history
696: WHERE distribution_id = (SELECT distribution_id
697: FROM fa_distribution_history
698: WHERE transaction_header_id_out = pc_transaction_header_id
699: AND rownum = 1));

Line 697: FROM fa_distribution_history

693: FROM fa_retirements
694: WHERE retirement_id = (SELECT retirement_id
695: FROM fa_distribution_history
696: WHERE distribution_id = (SELECT distribution_id
697: FROM fa_distribution_history
698: WHERE transaction_header_id_out = pc_transaction_header_id
699: AND rownum = 1));
700:
701: -----------------------------------------------------------------------------

Line 765: fa_distribution_history dh

761: nvl (dc.deprn_adjustment_amount, 0) corp_deprn_adjustment_amount,
762: dh.code_combination_id
763: FROM fa_deprn_detail dd,
764: fa_deprn_detail dc,
765: fa_distribution_history dh
766: WHERE dd.asset_id = pc_asset_id
767: AND dd.book_type_code = pc_tax_book
768: AND dd.period_counter = pc_period_counter
769: AND dc.asset_id = dd.asset_id