DBA Data[Home] [Help]

APPS.FA_REC_PVT_PKG1 dependencies on FA_TRANSACTION_HEADERS

Line 299: FROM FA_TRANSACTION_HEADERS

295: prior_date_effective DATE;
296: check_another_trans NUMBER := 0;
297: CURSOR get_prior_trans_date IS
298: SELECT max(transaction_date_entered)
299: FROM FA_TRANSACTION_HEADERS
300: WHERE asset_id = p_asset_id
301: AND book_type_code = p_book_type_code
302: AND transaction_type_code not like '%/VOID';
303:

Line 306: FROM FA_TRANSACTION_HEADERS

302: AND transaction_type_code not like '%/VOID';
303:
304: CURSOR get_prior_date_effective IS
305: SELECT max(date_effective)
306: FROM FA_TRANSACTION_HEADERS
307: WHERE asset_id = p_asset_id
308: AND book_type_code = p_book_type_code;
309: BEGIN
310: /* Logic from FA_BOOKS_VAL5.Amortization_Start_Date from FAXASSET. */