SELECT
  startDate,
  endDate,
  statusCode,
  userName,
  typeCode,
  administrationConcernRoleID
INTO
  :startDate,
  :endDate,
  :statusCode,
  :userName,
  :typeCode,
  :administrationConcernRoleID 
FROM
  AdministrationRole,
  AdministrationConcernRole 
WHERE concernRoleID = :concernRoleID 
  AND 
  (
    startDate <= :currentDate 
    AND 
    (
      endDate IS NULL 
    ) 
  ) 
  AND AdministrationRole.administrationRoleID = AdministrationConcernRole.administrationRoleID