Database SQL Operation: PaidEmployment.readEmploymentWorkingHourDetailsByPaidEmploymentID
Description: | Reads the employmentWorkingHourID, employmentID, concernRoleID and the caseParticipantRoleID of the employment working hour record corresponding to a paid-employment instance. |
Sterotype: | nsmulti |
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
|