Database SQL Operation: ContactLogConcern.searchActiveByContactLogID
Description: | Method to list active Contact Log Concern records for specified Contact Log id. |
Sterotype: | nsmulti |
SELECT
ContactLogConcern.contactLogConcernID,
ContactLogConcern.concernRoleID,
ConcernRole.concernRoleName,
ContactLogConcern.versionNo
INTO
:contactLogConcernID,
:concernRoleID,
:concernRoleName,
:versionNo
FROM
ContactLogConcern,
ConcernRole
WHERE ContactLogConcern.contactLogID = :contactLogID
AND ContactLogConcern.recordStatus = :recordStatus
AND ContactLogConcern.concernRoleID = ConcernRole.concernRoleID
|