Operation Details
Description: This method is used to return the applicable rules set for a given Assessment Configuration record on a given date.
Sterotype: ns
SQL 
SELECT
  assessmentRulesLinkID,
  assessmentConfigurationID,
  ruleSetID,
  startDate,
  endDate,
  comments,
  statusCode,
  versionNo
INTO
  :assessmentRulesLinkID,
  :assessmentConfigurationID,
  :ruleSetID,
  :startDate,
  :endDate,
  :comments,
  :statusCode,
  :versionNo 
FROM
  AssessmentRulesLink 
WHERE assessmentConfigurationID = :assessmentConfigurationID 
  AND 
  (
    startDate <= :dateOfCalculation 
    AND endDate >= :dateOfCalculation 
  ) 
  AND statusCode <> :statusCode