DBA Data[Home] [Help]

APPS.FA_AMORT_VAL_PKG dependencies on FA_TRANSACTION_HEADERS

Line 116: from fa_transaction_headers

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

Line 149: from fa_transaction_headers

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