DBA Data[Home] [Help]

APPS.FA_GAINLOSS_DPR_PKG dependencies on FA_CONVENTIONS

Line 481: fa_conventions con

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 ;
485:

Line 490: fa_conventions con

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 ;
494: