Operation Details
Description: Reads the number of hours worked on active records for an employment based on the paidEmploymentID and a searchDate. Current functionality ensures that only one value will be returned for each searchDate.
Sterotype: ns
SQL 
SELECT
  EmploymentWorkingHour.noHoursWorked
INTO
  :noHoursWorked 
FROM
  EmploymentWorkingHour,
  PaidEmployment 
WHERE PaidEmployment.evidenceID = :evidenceID 
  AND PaidEmployment.employmentID = EmploymentWorkingHour.employmentID 
  AND EmploymentWorkingHour.recordStatus = :recordStatus 
  AND EmploymentWorkingHour.fromDate = 
  ( 
  SELECT
    MAX(EmploymentWorkingHour.fromDate) 
  FROM
    EmploymentWorkingHour,
    PaidEmployment 
  WHERE PaidEmployment.evidenceID = :evidenceID 
    AND PaidEmployment.employmentID = EmploymentWorkingHour.employmentID 
    AND EmploymentWorkingHour.fromDate <= :searchDate 
    AND EmploymentWorkingHour.recordStatus = :recordStatus 
  )