SELECT
  Employer.concernRoleID,
  Employer.tradingName
INTO
  :employerConcernRoleID,
  :tradingName 
FROM
  Employment,
  Employer 
WHERE Employment.concernRoleID = :concernRoleID 
  AND Employment.status = :status 
  AND Employment.primaryCurrentInd = :primaryCurrentInd 
  AND Employer.concernRoleID = Employment.employerConcernRoleID