Employee reporting to x++

static void empReportingTo(Args _args)
{
HcmWorker hcmWorker;
HcmPositionWorkerAssignment workerAssignment;
HcmPosition hcmPosition;
HcmPositionDetail hcmPositionDetail;
HcmPositionHierarchy hcmPositionHierarchy; // declare this table to get report to position

select Person, RecId, PersonnelNumber from hcmWorker
where hcmWorker.PersonnelNumber == “854” //personnel Number
join workerAssignment
where workerAssignment.Worker == hcmWorker.RecId
join hcmPosition
where hcmPosition.RecId == workerAssignment.Position
join hcmPositionHierarchy
where hcmPositionHierarchy.Position == hcmPosition.RecId
join hcmPositionDetail
where hcmPositionDetail.Position == hcmPosition.RecId;

info(strFmt(“Name :%1’s , EmployeeId :%2 , position :%3 , Reporting to:%4 “,hcmWorker.name(),hcmWorker.PersonnelNumber,
hcmPositionDetail.Description,hcmPosition::find(hcmPositionHierarchy.ParentPosition).description()));
}