| Operation Details |  |
| Description: | list third party names for an appeal case. |
| Sterotype: | ns |
| SQL | |
SELECT ConcernRole.concernRoleName INTO :thirdPartyName FROM ThirdParty ThirdParty, ConcernRole ConcernRole WHERE ThirdParty.appealID = :appealID AND ConcernRole.ConcernRoleID = ThirdParty.caseParticipantRoleID |