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_UPD_PKG dependencies on FA_CONVENTIONS

Line 3307: ,fa_conventions conv

3303:
3304: select ( cp1.period_num) ,( cp2.period_num)
3305: into h_new_ret_pn,h_old_ret_pn
3306: from fa_retirements new_ret
3307: ,fa_conventions conv
3308: ,fa_calendar_periods cp1
3309: ,fa_retirements old_ret
3310: ,fa_conventions conv2
3311: ,fa_calendar_periods cp2

Line 3310: ,fa_conventions conv2

3306: from fa_retirements new_ret
3307: ,fa_conventions conv
3308: ,fa_calendar_periods cp1
3309: ,fa_retirements old_ret
3310: ,fa_conventions conv2
3311: ,fa_calendar_periods cp2
3312: where new_ret.transaction_header_id_in=ret.th_id_in
3313: and conv.prorate_convention_code=new_ret.retirement_prorate_convention
3314: and new_ret.date_retired between conv.start_date and conv.end_date

Line 3755: fa_conventions conv

3751: from fa_transaction_headers trx,
3752: fa_deprn_periods dp1,
3753: fa_retirements old_ret,
3754: fa_deprn_periods dp2,
3755: fa_conventions conv
3756: where trx.transaction_header_id = h_old_reinst_trx_id
3757: and dp1.book_type_code = trx.book_type_code
3758: and trx.transaction_date_entered between dp1.CALENDAR_PERIOD_OPEN_DATE
3759: and dp1.CALENDAR_PERIOD_CLOSE_DATE

Line 3770: ,fa_conventions conv

3766:
3767: select dp.period_counter
3768: into h_ret_prorate_pc
3769: from fa_retirements new_ret
3770: ,fa_conventions conv
3771: ,fa_deprn_periods dp
3772: where new_ret.transaction_header_id_in=ret.th_id_in
3773: and conv.prorate_convention_code=new_ret.retirement_prorate_convention
3774: and new_ret.date_retired between conv.start_date and conv.end_date

Line 3790: fa_conventions conv

3786: from fa_transaction_headers trx,
3787: fa_deprn_periods dp1,
3788: fa_mc_retirements old_ret,
3789: fa_deprn_periods dp2,
3790: fa_conventions conv
3791: where trx.transaction_header_id = h_old_reinst_trx_id
3792: and dp1.book_type_code = trx.book_type_code
3793: and trx.transaction_date_entered between dp1.CALENDAR_PERIOD_OPEN_DATE
3794: and dp1.CALENDAR_PERIOD_CLOSE_DATE

Line 3806: ,fa_conventions conv

3802:
3803: select dp.period_counter
3804: into h_ret_prorate_pc
3805: from fa_mc_retirements new_ret
3806: ,fa_conventions conv
3807: ,fa_deprn_periods dp
3808: where new_ret.transaction_header_id_in=ret.th_id_in
3809: and conv.prorate_convention_code=new_ret.retirement_prorate_convention
3810: and new_ret.date_retired between conv.start_date and conv.end_date