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