pk72846_view_policy.sp73111_get_wcis_std_premium¶

Overview¶

Field	Value
Schema	WCIS_DBA
Type	Package function
Database	Oracle
Calling libraries	`SAIF.Business.Policy.Core`
Calling classes	`clsPolicyPeriodBase`

Purpose¶

Resolves the latest premium-history set for the period and returns its standard premium

Procedures / Methods¶

sp73111_get_wcis_std_premium¶

Field	Value
Returns	See PL/SQL source below.
Called by	`clsPolicyPeriodBase`

Description: Resolves the latest premium-history set for the period and returns its standard premium

Parameters¶

Parameter	Direction	Type	Default	Description
`in_policy_num`	IN	`NUMBER`	—	Policy number whose WCIS standard premium is being resolved.
`in_pol_per_eff_date`	IN	`DATE`	—	Policy-period effective date used to find the latest premium-history set for the period.

Business Rules¶

Rule ID	Rule	Condition	Action
PROC-RULE-008	WCIS standard premium is always taken from the latest premium-history set for the policy period	Always	Return `pk73059_prem_hist_summary.get_standard_premium(get_max_ph_set_id(policy, eff_date))`

Operations¶

Operation	Description	Trigger
Retrieve standardised WCIS standard premium	Resolves the latest premium-history set for the period and returns its standard premium	`clsPolicyPeriodBase.GetWCISStandardPremium` (SQL-085), for WCIS-financial-system periods

Source Code¶

PL/SQL source

FUNCTION sp73111_get_wcis_std_premium
/****************************************************************
*Procedure Title  : Get WCIS Standard Premium
*Name             : SP73111_GET_WCIS_STD_PREMIUM
*Called by        : Business Online
*****************************************************************
* Description: This procedure gets the Standardized Standard Premium
*               based on the 9/8/07 New Standard Premium Project.
*
*               THIS LOGIC IS ALSO USED IN BDS.  IF YOU CHANGE THIS
*               YOU MUST CORRODINATE WITH THE BDS TEAM.
*
*               It gets the max premium history set for the policy
*               and policy period passed in.  It uses the Prem_Summary
*               view to define the correct set.
*
* Maintenance Log:
*   Name            CSR        Date     Description
* John Frey                 09/08/2007  Initial Release
******************************************************************/
   (
      in_policy_num         IN   NUMBER,
      in_pol_per_eff_date   IN   DATE
   )
      RETURN NUMBER
   IS
   BEGIN
      RETURN pk73059_prem_hist_summary.get_standard_premium(
                     pk73059_prem_hist_summary.get_max_ph_set_id(in_policy_num,in_pol_per_eff_date));
   END sp73111_get_wcis_std_premium;

/* Formatted on 4/23/2020 4:26:52 PM (QP5 v5.256.13226.35510) */

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¶

Oracle DBA_SOURCE: pk72846_view_policy.sp73111_get_wcis_std_premium
Business\SAIF.Business.Policy.Core\clsPolicyPeriodBase.vb