Database SQL Operation: IntakeAppConcernRoleLink.searchConcernByCWAccount
Description: | Searches for evidence descriptor records by case id and correction set id which do not match a given evidence descriptor id and statuses. |
Sterotype: | nsmulti |
select
cr.concernroleid, cr.concernrolename, pr.dateofbirth
into :concernRoleID, :concernRoleName, :concernRoleDOB
from concernrole cr
INNER JOIN person pr
ON pr.concernroleid = cr.concernroleid
where cr.concernroleid in
(select concernroleid from intakeappconcernrolelink where intakeapplicationid in
(select intakeapplicationid from intakeapplication where enteredbyuser = :username))
|