APPS.FA_RECLASS_UTIL_PVT dependencies on FA_TRANSACTION_HEADERS

Line 354: FA_TRANSACTION_HEADERS TH

350: into v_is_prior_period
351: FA_DEPRN_PERIODS DP_NOW,
352: FA_DEPRN_PERIODS DP,
353: FA_BOOK_CONTROLS BC,
354: FA_TRANSACTION_HEADERS TH
355: WHERE
356: TH.ASSET_ID = p_asset_id AND
357: TH.TRANSACTION_TYPE_CODE = DECODE(BC.BOOK_CLASS,'CORPORATE',
358: 'TRANSFER IN','ADDITION') AND

Line 410: FROM FA_TRANSACTION_HEADERS

406: l_calling_fn varchar2(40) := 'fa_reclass_util_pvt.validate_trx_date';
407:
408: CURSOR get_prior_trans_date IS
409: SELECT max(transaction_date_entered)
410: FROM FA_TRANSACTION_HEADERS
411: WHERE asset_id = p_asset_id
412: AND book_type_code = p_book
413: AND transaction_type_code not like '%/VOID';
414:

Line 417: FROM FA_TRANSACTION_HEADERS

413: AND transaction_type_code not like '%/VOID';
414:
415: CURSOR get_prior_date_effective IS
416: SELECT max(date_effective)
417: FROM FA_TRANSACTION_HEADERS
418: WHERE asset_id = p_asset_id
419: AND book_type_code = p_book;
420: BEGIN
421: /* Logic from FA_BOOKS_VAL5.Amortization_Start_Date from FAXASSET. */