eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FA_TRANSFER_PVT dependencies on FA_DEPRN_PERIODS

Line 617: fa_deprn_periods dp_trx,

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
621: and dp_trx.calendar_period_close_date

Line 618: fa_deprn_periods dp_eff

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
621: and dp_trx.calendar_period_close_date
622: and dp_trx.book_type_code=trx2.book_type_code

Line 645: fa_deprn_periods dp1,

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
649: and trx.transaction_date_entered between dp1.CALENDAR_PERIOD_OPEN_DATE

Line 646: fa_deprn_periods dp2

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
649: and trx.transaction_date_entered between dp1.CALENDAR_PERIOD_OPEN_DATE
650: and dp1.CALENDAR_PERIOD_CLOSE_DATE