SQL-005 Get policy ownership system

Invokes the Oracle package function pk73102_policy.does_wcis_own_submission via a scalar SELECT ... FROM DUAL to determine which system owns a policy (BR-POL-005). The function body could not be retrieved in this environment.**

Classification

Field	Value
SQL ID	SQL-005
Operation type	Read (function call)
Execution method	Inline SQL (CommandType.Text, DataRequestType.Scalar)
Database	Oracle
Schema	[unqualified]** — no owner in call text
Command type	Text
Business object	N/A (Application layer)
Criteria property	N/A
Lifecycle method	N/A
Application class	PolicyInformation (GetPolicyOwnershipSystem property getter)

Parameters

Parameter	Direction	Type	Max length	Description
:in_policy_num	Input	Decimal (Oracle NUMBER)	N/A	Policy number passed to the Oracle function pk73102_policy.does_wcis_own_submission.

Tables

Table	Access	Columns used
DUAL	SELECT	N/A (pseudo-table used to invoke the function)

Sample SQL

SELECT
  pk73102_policy.does_wcis_own_submission(:in_policy_num)
FROM dual

The function body resides in the Oracle database package pk73102_policy; it could not be retrieved in this environment (status: not-found).**

Operations and processes

• OP-11 Determine the owning policy system (see Operations and processes)

Business rules

• BR-POL-005: Policy ownership determination

Note: Statements marked with ** could not be confirmed; treat as unknown until verified.

Sources

• SAIF.Business.Policy/PolicyInformation.vb