assigned jobs for worker/employee x++

static void JobsForPersonnelNum(Args _args)
{
HcmWorker hcmworker,worker;
HcmPositionWorkerAssignment hcmPositionWorkerAssignment;
HcmPositionDetail hcmPositionDetail;
HcmPosition hcmPosition;
HcmPositionHierarchy hcmpositionHierarchy;
HcmJob hcmJob;
HcmJobDetail hcmJobDetail;
HcmTitle hcmTitle;

while select hcmPositionWorkerAssignment
join Worker
where hcmPositionWorkerAssignment.Worker == worker.RecId
&& worker.PersonnelNumber == “977” //Personnel Number
join hcmPosition where hcmPosition.RecId == hcmPositionWorkerAssignment.Position
join hcmPositionDetail where hcmPositionDetail.Position == hcmPosition.RecId
join hcmJob where hcmJob.RecId == hcmPositionDetail.Job
join hcmJobDetail where hcmJobDetail.job == hcmJob.RecId
join hcmTitle where hcmTitle.RecId == hcmJobDetail.Title
{
info(strFmt(“%1—%2—%3”, hcmJob.JobId, worker.PersonnelNumber, hcmTitle.TitleId));
}
}