DBA Data[Home] [Help]

APPS.FA_DISTRIBUTION_PVT dependencies on FA_DEPRN_PERIODS

Line 1278: (select period_counter from fa_deprn_periods where book_type_code =

1274: where adj.asset_id = l_asset_id
1275: and adj.book_type_code = l_book_type_code
1276: and source_type_code = 'TRANSFER'
1277: and adj.period_counter_created =
1278: (select period_counter from fa_deprn_periods where book_type_code =
1279: l_book_type_code and period_close_date is null);
1280: --bug fix 2186234 ends
1281:
1282:

Line 1332: from fa_deprn_periods

1328: -- as it does extra select on fiscal yr which
1329: -- is redundant.
1330: select calendar_period_open_date
1331: into l_tax_cal_period_open_date
1332: from fa_deprn_periods
1333: where book_type_code = l_tax_book_type_code
1334: and period_close_date is null;
1335:
1336: --bug fix 2186234 starts