SQL-017 Retrieve attorney person list for other parties¶
Retrieves LEGAL_PERSON rows joined to LEGAL_PERSON_TYPE where the type is ATTY or OUTC and the type assignment has not expired (exp_date is null), for the ATTORNEYPERSONSQL code-table lookup used by the other-parties maintenance UI.
Classification¶
| Field | Value |
|---|---|
| SQL ID | SQL-017 |
| Operation type | Read |
| Execution method | Inline SQL (clsCodeCollection.GetCodeCollection) |
| Database | Oracle |
| Command type | Text |
| Business object | N/A (Application layer) |
| Criteria property | N/A (Application layer) |
| Lifecycle method | N/A (Application layer) |
| Application class | clsOtherPartiesManager |
Parameters¶
No runtime parameters — this is a static code-table lookup constant (ATTORNEYPERSONSQL), executed as-is via clsCodeCollection.GetCodeCollection(DPI, ATTORNEYPERSONSQL).
Tables¶
| Table | Access | Columns used |
|---|---|---|
| LEGAL_PERSON | SELECT, JOIN | LEGAL_PERSON_SEQ_NUM, LAST_NAME, FIRST_NAME |
| LEGAL_PERSON_TYPE | SELECT, JOIN | LEGAL_PERSON_SEQ_NUM, LEGAL_PERSON_TYPE_CODE, EXP_DATE |
Sample SQL¶
SELECT
to_char(p.legal_person_seq_num) As code,
last_name || ', ' || first_name as code_descr
from legal_person p, legal_person_type t
where p.legal_person_seq_num = t.legal_person_seq_num
and (t.legal_person_type_code = 'ATTY' or t.legal_person_type_code = 'OUTC')
and t.exp_date is null
Sources¶
SAIF.Application.Claim.Legal\LegalNet\clsOtherPartiesManager.vb