SQL-014 Opposingoutside attorney person list

Inline (const ATTORNEYPERSONSQL → GetCodeCollection) for clsOtherPartiesManager.

Classification

Field	Value
SQL ID	SQL-014
Operation type	Read
Execution method	Inline (const ATTORNEYPERSONSQL → GetCodeCollection)
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	clsOtherPartiesManager
Criteria property	N/A
Lifecycle method	AttorneyPersonList property getter

Tables

Table	Access	Columns used
LEGAL_PERSON	SELECT	See database table section
LEGAL_PERSON_TYPE	SELECT	See database table section
DUAL	SELECT	See database table section

Sample SQL

SELECT
  '0',
  ' '
FROM dual
UNION
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

Operations and processes

• Other parties maintenance — attorney person picklist

Sources

• clsOtherPartiesManager.vb