DBA Data[Home] [Help]

APPS.FA_WHATIF_DEPRN_PKG dependencies on FA_DEPRN_PERIODS

Line 1082: from fa_deprn_periods where

1078: /* Bug#13734783 */
1079: /* bug 10205614 we dont want to consider cases when asset is added with reserve
1080: select fiscal_year
1081: into first_fy
1082: from fa_deprn_periods where
1083: book_type_code = X_book
1084: and period_counter = ( select period_counter + 1
1085: from fa_deprn_summary where
1086: book_type_code = X_book

Line 1095: from fa_deprn_periods fadp,

1091: into first_fy
1092: from dual
1093: where EXISTS (
1094: select 'Y'
1095: from fa_deprn_periods fadp,
1096: fa_deprn_summary fads
1097: where fadp.book_type_code = X_book
1098: and fads.book_type_code = X_book
1099: and fads.asset_id = X_asset_id