241: begin
242: select distinct 1
243: into l_is_retired
244: from FA_TRANSACTION_HEADERS TH,
245: FA_DEPRN_PERIODS DP1,
246: FA_DEPRN_PERIODS DP2
247: where TH.asset_id = g_adj_asset_hdr_rec.asset_id
248: and TH.book_type_code = g_adj_asset_hdr_rec.book_type_code
249: and TH.transaction_type_code = 'PARTIAL RETIREMENT'
242: select distinct 1
243: into l_is_retired
244: from FA_TRANSACTION_HEADERS TH,
245: FA_DEPRN_PERIODS DP1,
246: FA_DEPRN_PERIODS DP2
247: where TH.asset_id = g_adj_asset_hdr_rec.asset_id
248: and TH.book_type_code = g_adj_asset_hdr_rec.book_type_code
249: and TH.transaction_type_code = 'PARTIAL RETIREMENT'
250: and DP1.period_counter = g_start_pc and