Operation Details
Description: Reads the employmentWorkingHourID, employmentID, concernRoleID and the caseParticipantRoleID of the employment working hour record corresponding to a paid-employment instance.
Sterotype: nsmulti
SQL
SELECT
  EmploymentWorkingHour.employmentWorkingHourID,
  EmploymentWorkingHour.employmentID,
  Employment.concernRoleID
INTO
  :employmentWorkingHourID,
  :employmentID,
  :concernRoleID 
FROM
  PaidEmployment,
  EmploymentWorkingHour,
  Employment 
WHERE PaidEmployment.evidenceID = :evidenceID 
  AND Employment.employmentID = PaidEmployment.employmentID 
  AND EmploymentWorkingHour.employmentID = PaidEmployment.employmentID