DBA Data[Home] [Help]

APPS.FA_AMORT_VAL_PKG dependencies on FA_TRANSACTION_HEADERS

Line 119: from fa_transaction_headers

115: -- previous txn date, set txns_exist
116:
117: select MAX(transaction_date_entered),MAX(date_effective)
118: into h_prior_transaction_date,h_prior_date_effective
119: from fa_transaction_headers
120: where asset_id = x_asset_id
121: and book_type_code = x_book;
122:
123: if (x_new_amort_start_date < h_prior_transaction_date) then

Line 152: from fa_transaction_headers

148: -- set x_new_amort_start_date := latest txn date
149:
150: select MAX(date_effective)
151: into h_prior_date_effective
152: from fa_transaction_headers
153: where asset_id = x_asset_id
154: and book_type_code = x_book
155: and transaction_type_code in ('REVALUATION');
156: