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
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