DBA Data[Home] [Help]

APPS.FA_SORP_REVALUATION_PKG dependencies on FA_TRANSACTION_HEADERS

Line 64: fa_transaction_headers

60: where book_type_code = p_book_type_code and
61: asset_id = p_asset_id and
62: transaction_header_id_out = (select transaction_header_id
63: from
64: fa_transaction_headers
65: where MASS_TRANSACTION_ID = fa_sorp_process_imp_id_fn(p_impairment_id));
66:
67:
68: CURSOR c_get_period_rec (c_start_date date) IS

Line 2023: fa_transaction_headers fth

2019: fbs.reval_loss_balance
2020: FROM
2021: FA_ADJUSTMENTS adj,
2022: fa_books_summary fbs,
2023: fa_transaction_headers fth
2024: WHERE adj.asset_id = p_asset_hdr_rec.asset_id
2025: AND adj.book_type_code = p_asset_hdr_rec.book_type_code
2026: AND adj.adjustment_type in ('REVAL LOSS','REVAL RESERVE')
2027: AND adj.debit_credit_flag = 'DR'

Line 2052: fa_transaction_headers fth

2048: fbs.reval_loss_balance
2049: FROM
2050: FA_MC_ADJUSTMENTS adj,
2051: fa_mc_books_summary fbs,
2052: fa_transaction_headers fth
2053: WHERE adj.asset_id = p_asset_hdr_rec.asset_id
2054: AND adj.book_type_code = p_asset_hdr_rec.book_type_code
2055: AND adj.adjustment_type in ('REVAL LOSS','REVAL RESERVE')
2056: AND adj.debit_credit_flag = 'DR'