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_GAINLOSS_DPR_PKG dependencies on FA_RETIREMENTS

Line 120: from fa_retirements

116: l_transaction_header_id_out number;
117:
118: Cursor c_get_trxn_id is
119: select transaction_header_id_in,transaction_header_id_out
120: from fa_retirements
121: where book_type_code=dpr.book
122: and asset_id=dpr.asset_id
123: and retirement_id=retirement_id;
124:

Line 468: from fa_retirements

464:
465:
466: CURSOR c_get_rein_thid IS
467: select nvl(transaction_header_id_out, transaction_header_id_in) -- Bug# 5074257
468: from fa_retirements
469: where retirement_id = ret.retirement_id;
470:
471: CURSOR c_get_trans_rec(c_thid number) IS
472: select transaction_type_code

Line 538: from fa_retirements ret,

534: -- date based on retirement prorate convention
535: CURSOR c_get_retire_prorate (c_thid number,
536: c_trx_date date ) IS
537: select con.prorate_date
538: from fa_retirements ret,
539: fa_conventions con
540: where ret.transaction_header_id_in = c_thid
541: and con.prorate_convention_code = ret.RETIREMENT_PRORATE_CONVENTION
542: and c_trx_date between con.start_date and con.end_date ;