SQL-017 Assigned attorney's manager email¶

Inline scalar (SqlHelper.ScalarQuery(Of String)), calls Oracle function pk80001_LEGALNET.get_atty_mngr_email for clsScheduleManager.

Classification¶

Field	Value
SQL ID	SQL-017
Operation type	Read
Execution method	Inline scalar (SqlHelper.ScalarQuery(Of String)), calls Oracle function pk80001_LEGALNET.get_atty_mngr_email
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	`clsScheduleManager`
Criteria property	N/A
Lifecycle method	getAttyMngrEmail()

Tables¶

Table	Access	Columns used
DUAL (function body opaque)	SELECT	See database table section

Sample SQL¶

-- Reconstructed: "select pk80001_LEGALNET.get_atty_mngr_email(" & caseSeqNum & ") from dual"
-- Oracle package FUNCTION invoked as inline SQL; function body resides in the Oracle database.
SELECT
  pk80001_LEGALNET.get_atty_mngr_email(<caseSeqNum>)
FROM dual

Operations and processes¶

Defense Evaluation Form email notification (clsScheduleManager.SendDEFEmail)

Sources¶

SAIF.Application.Claim.Legal\LegalNet\clsScheduleManager.vb