DBA Data[Home] [Help]

APPS.FA_TRANSFER_PVT dependencies on FA_TRANSACTION_HEADERS

Line 609: from fa_transaction_headers trx

605: /* Check if the current prior period transfer overlaps the previous one */
606: begin
607: select max(trx.transaction_header_id)
608: into prev_trx_id
609: from fa_transaction_headers trx
610: where trx.book_type_code = p_asset_hdr_rec.book_type_code
611: and trx.asset_id = p_asset_hdr_rec.asset_id
612: and trx.transaction_type_code = 'TRANSFER'
613: and trx.transaction_header_id < p_trans_rec.transaction_header_id

Line 616: from fa_transaction_headers trx2,

612: and trx.transaction_type_code = 'TRANSFER'
613: and trx.transaction_header_id < p_trans_rec.transaction_header_id
614: and exists
615: (select 1
616: from fa_transaction_headers trx2,
617: fa_deprn_periods dp_trx,
618: fa_deprn_periods dp_eff
619: where trx2.transaction_header_id=trx.transaction_header_id
620: and trx2.transaction_date_entered between dp_trx.calendar_period_open_date

Line 644: from fa_transaction_headers trx,

640: select dp1.period_counter
641: ,dp2.period_counter
642: into prev_from_ctr_trx
643: ,prev_from_ctr_eff
644: from fa_transaction_headers trx,
645: fa_deprn_periods dp1,
646: fa_deprn_periods dp2
647: where trx.transaction_header_id=prev_trx_id
648: and dp1.book_type_code = trx.book_type_code