DBA Data[Home] [Help]

APPS.FA_RETIREMENT_PUB dependencies on FA_CONVENTIONS

Line 1493: fa_conventions conv

1489:
1490: select prorate_date
1491: into l_ret_prorate_date
1492: from fa_calendar_periods cp,
1493: fa_conventions conv
1494: where conv.prorate_convention_code = l_asset_retire_rec.retirement_prorate_convention
1495: and conv.start_date <= l_asset_retire_rec.date_retired
1496: and conv.end_date >= l_asset_retire_rec.date_retired
1497: and cp.calendar_type = l_prorate_calendar

Line 2988: fa_conventions conv

2984: if l_asset_fin_rec.period_counter_fully_extended is not null then
2985: select prorate_date
2986: into l_ret_prorate_date
2987: from fa_calendar_periods cp,
2988: fa_conventions conv
2989: where conv.prorate_convention_code = l_asset_retire_rec.retirement_prorate_convention
2990: and conv.start_date <= l_asset_retire_rec.date_retired
2991: and conv.end_date >= l_asset_retire_rec.date_retired
2992: and cp.calendar_type = fa_cache_pkg.fazcbc_record.prorate_calendar

Line 7258: fa_conventions con,

7254: from
7255: fa_transaction_headers th,
7256: fa_calendar_periods cp,
7257: fa_book_controls bc,
7258: fa_conventions con,
7259: fa_additions_b ad,
7260: fa_category_book_defaults cbd
7261: where th.book_type_code = l_asset_hdr_rec.book_type_code
7262: and th.asset_id = l_asset_hdr_rec.asset_id

Line 7292: fa_conventions con,

7288: into l_trans_flag
7289: from
7290: fa_calendar_periods cp,
7291: fa_book_controls bc,
7292: fa_conventions con,
7293: fa_deprn_override ovr,
7294: fa_deprn_periods fadp,
7295: fa_additions_b ad,
7296: fa_category_book_defaults cbd