APPS.FA_RETIREMENT_PUB dependencies on FA_CALENDAR_PERIODS

Line 1492: from fa_calendar_periods cp,

1488: end if;
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

Line 2987: from fa_calendar_periods cp,

2983: -- bug 14286465 start
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

Line 7256: fa_calendar_periods cp,

7252: select distinct 'Y'
7253: into l_trans_flag
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

Line 7290: fa_calendar_periods cp,

7286: begin
7287: select distinct 'Y'
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,