DBA Data[Home] [Help]

APPS.FA_GAINLOSS_DPR_PKG dependencies on FA_CONVENTIONS

Line 539: fa_conventions con

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

Line 548: fa_conventions con

544: CURSOR c_mc_get_retire_prorate (c_thid number,
545: c_trx_date date ) IS
546: select con.prorate_date
547: from fa_mc_retirements ret,
548: fa_conventions con
549: where ret.transaction_header_id_in = c_thid
550: and con.prorate_convention_code = ret.RETIREMENT_PRORATE_CONVENTION
551: and set_of_books_id = ret.set_of_books_id
552: and c_trx_date between con.start_date and con.end_date ;