Operation Details
Description: Retrieves the working pattern for the specified user and date.
Sterotype: ns
SQL 
SELECT
  defaultStartTime,
  defaultEndTime
INTO
  :defaultStartTime,
  :defaultEndTime 
FROM
  WorkingPattern 
WHERE 
  (
    userName = :userName 
  ) 
  AND 
  (
    startDate <= :effectiveDate 
  ) 
  AND 
  (
    
    (
      endDate IS NULL 
    ) 
    OR 
    (
      endDate >= :effectiveDate 
    ) 
  ) 
  AND 
  (
    recordStatusCode = :recordStatusCode 
  )