SQL-085: Call pk72846_view_policy.sp73111_get_wcis_std_premium¶
Call pk72846_view_policy.sp73111_get_wcis_std_premium in the context of clsPolicyPeriodBase.
Classification¶
| Field | Value |
|---|---|
| SQL ID | SQL-085 |
| Operation type | Read |
| Execution method | CommandType.StoredProcedure / DataRequestType.Scalar |
| Database | Oracle |
| Schema | Oracle synonym / runtime resolution** |
| Command type | StoredProcedure |
| Business object | clsPolicyPeriodBase |
| Criteria property | *n/a - application layer* |
| Lifecycle method | clsPolicyPeriodBase.GetWCISStandardPremium (application layer) |
Parameters¶
This statement has no bind parameters.
Tables¶
This statement executes as a stored procedure call and does not expose table references in repository source.**
Sample SQL¶
CALL pk72846_view_policy.sp73111_get_wcis_std_premium()
-- Procedure body resides in Oracle database
Operations and processes¶
Business rules¶
- BR-013: Standard premium is sourced from WCIS for WCIS
- BR-022: A policy period must have a non-zero policy
- BR-023: A policy period must have an effective date
Note: Statements marked with * were inferred from code structure, naming conventions, or contextual evidence where direct confirmation was not available in source artifacts. Statements marked with ** could not be confirmed; treat as unknown until verified.
Sources¶
Business\SAIF.Business.Policy.Core\clsPolicyPeriodBase.vb