Operation Details
Description: Retrieves a list of administration roles for the specified concern role, administration role type and administration role status.
Sterotype: nsmulti
SQL 
SELECT
  startDate,
  endDate,
  statusCode,
  userName,
  typeCode,
  administrationConcernRoleID
INTO
  :startDate,
  :endDate,
  :statusCode,
  :userName,
  :typeCode,
  :administrationConcernRoleID 
FROM
  AdministrationRole,
  AdministrationConcernRole 
WHERE concernRoleID = :concernRoleID 
  AND typeCode = :typeCode 
  AND statusCode = :statusCode 
  AND AdministrationRole.administrationRoleID = AdministrationConcernRole.administrationRoleID 
ORDER BY statusCode ASC,
  startDate DESC