2359: a.account_number,
2360: a.bank_code,
2361: a.portfolio_code,
2362: a.year_calc_type 2363: from xtr_bank_accounts a, 2364: xtr_party_info b
2365: where a.party_code=b.party_code
2366: and b.party_type='C'
2367: and nvl(a.setoff_account_yn,'N') ='N'