DBA Data[Home] [Help]

APPS.FA_GAINLOSS_UPD_PKG dependencies on FA_CONVENTIONS

Line 2946: ,fa_conventions conv

2942:
2943: select dp.period_counter
2944: into h_ret_prorate_pc
2945: from fa_retirements new_ret
2946: ,fa_conventions conv
2947: ,fa_deprn_periods dp
2948: where new_ret.transaction_header_id_in=ret.th_id_in
2949: and conv.prorate_convention_code=new_ret.retirement_prorate_convention
2950: and new_ret.date_retired between conv.start_date and conv.end_date