APPS.FA_RECLASS_UTIL_PVT dependencies on FA_TRANSACTION_HEADERS

Line 337: FA_TRANSACTION_HEADERS TH

333: into v_is_prior_period
334: FA_DEPRN_PERIODS DP_NOW,
335: FA_DEPRN_PERIODS DP,
336: FA_BOOK_CONTROLS BC,
337: FA_TRANSACTION_HEADERS TH
338: WHERE
339: TH.ASSET_ID = p_asset_id AND
340: TH.TRANSACTION_TYPE_CODE = DECODE(BC.BOOK_CLASS,'CORPORATE',
341: 'TRANSFER IN','ADDITION') AND

Line 391: FROM FA_TRANSACTION_HEADERS

387: l_calling_fn varchar2(40) := 'fa_reclass_util_pvt.validate_trx_date';
388:
389: CURSOR get_prior_trans_date IS
390: SELECT max(transaction_date_entered)
391: FROM FA_TRANSACTION_HEADERS
392: WHERE asset_id = p_asset_id
393: AND book_type_code = p_book
394: AND transaction_type_code not like '%/VOID';
395:

Line 398: FROM FA_TRANSACTION_HEADERS

394: AND transaction_type_code not like '%/VOID';
395:
396: CURSOR get_prior_date_effective IS
397: SELECT max(date_effective)
398: FROM FA_TRANSACTION_HEADERS
399: WHERE asset_id = p_asset_id
400: AND book_type_code = p_book;
401: BEGIN
402: /* Logic from FA_BOOKS_VAL5.Amortization_Start_Date from FAXASSET. */