SELECT
  OrganisationUnit.organisationUnitID,
  OrgUnitPositionLink.organisationStructureID,
  OrganisationUnit.name,
  Position.name
INTO
  :orgUnitID,
  :orgStructureID,
  :orgUnitName,
  :positionName 
FROM
  OrgUnitPositionLink,
  PositionHolderLink,
  Position,
  OrganisationUnit,
  OrganisationStructure 
WHERE OrgUnitPositionLink.positionID = PositionHolderLink.positionID 
  AND userName = :userName 
  AND Position.positionID = PositionHolderLink.positionID 
  AND Position.recordStatus = PositionHolderLink.recordStatus 
  AND OrgUnitPositionLink.organisationUnitID = OrganisationUnit.organisationUnitID 
  AND OrganisationStructure.organisationStructureID = OrgUnitPositionLink.organisationStructureID 
  AND OrganisationStructure.organisationStructureID = PositionHolderLink.organisationStructureID 
  AND OrganisationStructure.statusCode = :statusCode