SQL-006 Policy ownership system lookup

Calls the Oracle PL/SQL function pk73102_policy.does_wcis_own_submission inline via SELECT ... FROM DUAL to determine which system owns a policy submission; the result is parsed to Boolean and mapped by the caller to Enums.PolicyOwnershipSystems.WCIS or .SAIFQuote.

Classification

Field	Value
SQL ID	SQL-006
Operation type	Read
Execution method	Inline SQL — calls an Oracle PL/SQL function inline via SELECT ... FROM DUAL
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	N/A (Application layer)
Criteria property	N/A
Lifecycle method	N/A
Application class	PolicyInformation (property GetPolicyOwnershipSystem, Get)

Parameters

Parameter	Direction	Type	Max length	Description
:in_policy_num	Input	Decimal (inPolicyNumber)	N/A	Policy number passed to the PL/SQL function does_wcis_own_submission.

Tables

No tables — this is a scalar PL/SQL function call against DUAL. See pk73102_policy for the underlying package.

Sample SQL

select pk73102_policy.does_wcis_own_submission(:in_policy_num)
from dual

A prior, now-commented-out version of this line set DataRequest.SQLStatement to the bare call signature "pk73102_policy.does_wcis_own_submission" with CommandType.Text (not StoredProcedure) — this dead line is excluded from findings per the commented-out-code rule but confirms the object is invoked as a scalar function, not executed as a stored procedure.*

Operations and processes

• Determine policy ownership system

Note: Statements marked with * were inferred from code structure, naming conventions, or contextual evidence where direct confirmation was not available in source artifacts.

Sources

• SAIF.Business.Policy\PolicyInformation.vb