360: -- bridgway 11/14/00
361: */
362: cursor same_fiscal_year is
363: select 'Y'
364: from fa_book_controls bc,
365: fa_fiscal_year fy
366: where bc.book_type_code = bks_book_type_code
367: and bc.fiscal_year_name = fy.fiscal_year_name
368: and bks_date_placed_in_service between
371:
372: CURSOR cbachand_part_ret IS
373: SELECT 'Y'
374: FROM fa_transaction_headers th,
375: fa_book_controls bc,
376: fa_deprn_periods dp
377: WHERE th.book_type_code = bks_book_type_code
378: AND th.book_type_code = bc.book_type_code
379: AND bc.book_type_code = dp.book_type_code