Operation Details
Description:  
Sterotype: nsmulti
SQL 
SELECT
  EmploymentWorkingHour.employmentWorkingHourID,
  EmploymentWorkingHour.employmentID,
  EmploymentWorkingHour.fromDate,
  EmploymentWorkingHour.noHoursWorked,
  EmploymentWorkingHour.shiftWorkInd,
  EmploymentWorkingHour.comments,
  EmploymentWorkingHour.recordStatus,
  EmploymentWorkingHour.noDaysWorkedPerWeek,
  EmploymentWorkingHour.versionNo
INTO
  :employmentWorkingHourID,
  :employmentID,
  :fromDate,
  :noHoursWorked,
  :shiftWorkInd,
  :comments,
  :recordStatus,
  :noDaysWorkedPerWeek,
  :versionNo
FROM
  Employment,
  EmploymentWorkingHour
WHERE Employment.concernRoleID = :concernRoleID
  AND Employment.employmentID = EmploymentWorkingHour.employmentID
  AND EmploymentWorkingHour.recordStatus = :statusCode