403: upc,
404: tod,
405: tpc
406: FROM
407: FA_DEPRN_PERIODS DP,
408: FA_DEPRN_PERIODS DP_FY,
409: FA_BOOK_CONTROLS BC
410: WHERE
411: DP.BOOK_TYPE_CODE = book AND
404: tod,
405: tpc
406: FROM
407: FA_DEPRN_PERIODS DP,
408: FA_DEPRN_PERIODS DP_FY,
409: FA_BOOK_CONTROLS BC
410: WHERE
411: DP.BOOK_TYPE_CODE = book AND
412: DP.PERIOD_NAME = period AND
493: BOOKS.GROUP_ASSET_ID is not null
494: and exists (select 1
495: from fa_books oldbk
496: , fa_transaction_headers oldth
497: , fa_deprn_periods dp
498: where oldbk.transaction_header_id_out = books.transaction_header_id_in
499: and oldbk.transaction_header_id_out = oldth.transaction_header_id
500: and dp.book_type_code = book
501: and dp.period_counter = dd.period_counter