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 412: from fa_retirements

408: l_calling_fn VARCHAR2(50) := 'FA_GAINLOSS_DPR_PKG.CALC_CATCHUP';
409:
410: CURSOR c_get_rein_thid IS
411: select nvl(transaction_header_id_out, transaction_header_id_in) -- Bug# 5074257
412: from fa_retirements
413: where retirement_id = ret.retirement_id;
414:
415:
416: CURSOR c_get_trans_rec(c_thid number) IS

Line 480: from fa_retirements ret,

476: -- date based on retirement prorate convention
477: CURSOR c_get_retire_prorate (c_thid number,
478: c_trx_date date ) IS
479: select con.prorate_date
480: from fa_retirements ret,
481: fa_conventions con
482: where ret.transaction_header_id_in = c_thid
483: and con.prorate_convention_code = ret.RETIREMENT_PRORATE_CONVENTION
484: and c_trx_date between con.start_date and con.end_date ;

Line 489: from fa_retirements_mrc_v ret,

485:
486: CURSOR c_mc_get_retire_prorate (c_thid number,
487: c_trx_date date ) IS
488: select con.prorate_date
489: from fa_retirements_mrc_v ret,
490: fa_conventions con
491: where ret.transaction_header_id_in = c_thid
492: and con.prorate_convention_code = ret.RETIREMENT_PRORATE_CONVENTION
493: and c_trx_date between con.start_date and con.end_date ;