SELECT
  BankBranch.name,
  Bank.name
INTO
  :bankBranchName,
  :bankName 
FROM
  BankBranch,
  Bank 
WHERE BankBranch.bankSortCode = :bankSortCode 
  AND Bank.bankID = BankBranch.bankID 
  AND BankBranch.statusCode = :status