Database SQL Operation: ExternalPartyOfficeMember.searchForDuplicateOfficeMember
Description: | This method searches for any external party office members who belong to the same external party office, and have the same profile and name. |
Sterotype: | nsmulti |
SELECT
ExternalPartyOfficeMember.officeMemberID
INTO
:officeMemberID
FROM
ExternalPartyOfficeMember,
ConcernRole
WHERE ExternalPartyOfficeMember.externalPartyOfficeID = :externalPartyOfficeID
AND ExternalPartyOfficeMember.profile = :profile
AND ExternalPartyOfficeMember.concernRoleID = ConcernRole.concernRoleID
AND ConcernRole.concernRoleName = :name
|