SELECT
  Application.applicationID
INTO
  :applicationID
FROM
   Application,
   IntakeApplicant,
   AlternateName
WHERE application.applicationID = IntakeApplicant.applicationID
AND IntakeApplicant.concernRoleID = AlternateName.concernRoleID
AND (AlternateName.upperfirstForeName = :firstName 
OR AlternateName.uppersurName = :surName)