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 677: fa_deprn_periods dp_trx,

673: and trx.transaction_header_id < p_trans_rec.transaction_header_id
674: and exists
675: (select 1
676: from fa_transaction_headers trx2,
677: fa_deprn_periods dp_trx,
678: fa_deprn_periods dp_eff
679: where trx2.transaction_header_id=trx.transaction_header_id
680: and trx2.transaction_date_entered between dp_trx.calendar_period_open_date
681: and dp_trx.calendar_period_close_date

Line 678: fa_deprn_periods dp_eff

674: and exists
675: (select 1
676: from fa_transaction_headers trx2,
677: fa_deprn_periods dp_trx,
678: fa_deprn_periods dp_eff
679: where trx2.transaction_header_id=trx.transaction_header_id
680: and trx2.transaction_date_entered between dp_trx.calendar_period_open_date
681: and dp_trx.calendar_period_close_date
682: and dp_trx.book_type_code=trx2.book_type_code

Line 705: fa_deprn_periods dp1,

701: ,dp2.period_counter
702: into prev_from_ctr_trx
703: ,prev_from_ctr_eff
704: from fa_transaction_headers trx,
705: fa_deprn_periods dp1,
706: fa_deprn_periods dp2
707: where trx.transaction_header_id=prev_trx_id
708: and dp1.book_type_code = trx.book_type_code
709: and trx.transaction_date_entered between dp1.CALENDAR_PERIOD_OPEN_DATE

Line 706: fa_deprn_periods dp2

702: into prev_from_ctr_trx
703: ,prev_from_ctr_eff
704: from fa_transaction_headers trx,
705: fa_deprn_periods dp1,
706: fa_deprn_periods dp2
707: where trx.transaction_header_id=prev_trx_id
708: and dp1.book_type_code = trx.book_type_code
709: and trx.transaction_date_entered between dp1.CALENDAR_PERIOD_OPEN_DATE
710: and dp1.CALENDAR_PERIOD_CLOSE_DATE

Line 737: from fa_deprn_periods dp1,

733: into h_no_of_per_to_exclude,
734: h_amort_per_ctr,
735: h_add_per_ctr,
736: h_trx_type
737: from fa_deprn_periods dp1,
738: fa_deprn_periods dp2,
739: fa_deprn_periods dp3,
740: fa_transaction_headers th
741: where dp1.book_type_code = p_asset_hdr_rec.book_type_code

Line 738: fa_deprn_periods dp2,

734: h_amort_per_ctr,
735: h_add_per_ctr,
736: h_trx_type
737: from fa_deprn_periods dp1,
738: fa_deprn_periods dp2,
739: fa_deprn_periods dp3,
740: fa_transaction_headers th
741: where dp1.book_type_code = p_asset_hdr_rec.book_type_code
742: and dp2.book_type_code = dp1.book_type_code

Line 739: fa_deprn_periods dp3,

735: h_add_per_ctr,
736: h_trx_type
737: from fa_deprn_periods dp1,
738: fa_deprn_periods dp2,
739: fa_deprn_periods dp3,
740: fa_transaction_headers th
741: where dp1.book_type_code = p_asset_hdr_rec.book_type_code
742: and dp2.book_type_code = dp1.book_type_code
743: and dp3.book_type_code = dp1.book_type_code