APPS.FA_RETIREMENT_PUB dependencies on FA_DEPRN_PERIODS

Line 2998: from FA_DEPRN_PERIODS DP1

2994: and conv.prorate_date <= cp.end_date;
2995:
2996: Select decode (count(*),0,l_asset_fin_rec.period_counter_fully_extended,null)
2997: INTO l_period_fully_extend
2998: from FA_DEPRN_PERIODS DP1
2999: where DP1.book_type_code = l_asset_hdr_rec.Book_Type_Code and
3000: DP1.period_counter = l_asset_fin_rec.period_counter_fully_extended and
3001: DP1.CALENDAR_PERIOD_CLOSE_DATE > l_ret_prorate_date;
3002: end if;

Line 4471: from fa_deprn_periods dp

4467: l_tax_index number;
4468:
4469: cursor tde_cursor is
4470: select max(th.transaction_date_entered)
4471: from fa_deprn_periods dp
4472: ,fa_transaction_headers th
4473: ,fa_books bk
4474: where dp.book_type_code = l_asset_hdr_rec.book_type_code
4475: and dp.period_close_date is null

Line 6687: from fa_transaction_headers trx,fa_Deprn_periods prd

6683:
6684: -- bug#8941124: Cursor to check the period of extended depreciation.
6685: CURSOR c_check_extended_deprn IS
6686: select distinct 'Y'
6687: from fa_transaction_headers trx,fa_Deprn_periods prd
6688: where trx.book_type_code = p_asset_hdr_rec.book_type_code
6689: and trx.asset_id = p_asset_hdr_rec.asset_id
6690: and trx.date_effective > prd.period_open_date
6691: and prd.book_type_code = trx.book_type_code

Line 7294: fa_deprn_periods fadp,

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
7297: where ovr.book_type_code = l_asset_hdr_rec.book_type_code
7298: and ovr.asset_id = l_asset_hdr_rec.asset_id