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'
2368: and nvl(a.opening_balance,0) <> 0 ;