Operation Details
Description: Retrieves a list of Employment Working Hour Snapshot details for the specified Employment Working Hour record.
Sterotype: nsmulti
SQL 
SELECT
  employWorkingHourSnapshotID,
  fromDate,
  noHoursWorked,
  shiftWorkInd,
  recordStatus,
  creationDateTime
INTO
  :employWorkingHourSnapshotID,
  :fromDate,
  :noHoursWorked,
  :shiftWorkInd,
  :recordStatus,
  :creationDateTime
FROM
  EmploymentWorkingHourSnapshot
WHERE employmentWorkingHourID = :employmentWorkingHourID 
ORDER BY creationDateTime DESC