83: ret.retirement_id
84: FROM fa_retirements ret,
85: fa_transaction_headers th,
86: fa_additions_b ad, 87: fa_books bk 88: WHERE th.mass_transaction_id = l_mass_retirement_id
89: AND th.book_type_code = l_Book_Type_Code
90: AND th.transaction_type_code in ('FULL RETIREMENT','PARTIAL RETIREMENT') -- df. this change makes partial unit retirements to be mass reinstated.
91: AND th.transaction_key = 'R'