422: upc,
423: tod,
424: tpc
425: FROM
426: FA_DEPRN_PERIODS DP,
427: FA_DEPRN_PERIODS DP_FY,
428: FA_BOOK_CONTROLS BC
429: WHERE
430: DP.BOOK_TYPE_CODE = book AND
423: tod,
424: tpc
425: FROM
426: FA_DEPRN_PERIODS DP,
427: FA_DEPRN_PERIODS DP_FY,
428: FA_BOOK_CONTROLS BC
429: WHERE
430: DP.BOOK_TYPE_CODE = book AND
431: DP.PERIOD_NAME = period AND
516: BOOKS.GROUP_ASSET_ID is not null
517: and exists (select 1
518: from fa_books oldbk
519: , fa_transaction_headers oldth
520: , fa_deprn_periods dp
521: where oldbk.transaction_header_id_out = books.transaction_header_id_in
522: and oldbk.transaction_header_id_out = oldth.transaction_header_id
523: and dp.book_type_code = book
524: and dp.period_counter = dd.period_counter