---
title: SAIF.Business.View.Policy stored procedures
summary: Catalog of Oracle packages, procedures, and functions called by this library.
status: draft
owner: SAIF Doc Gen
last_reviewed: "2026-08-17"
library: SAIF.Business.View.Policy
reference_type: package
---

# SAIF.Business.View.Policy stored procedures

This page catalogs every stored procedure, package, and function that `SAIF.Business.View.Policy` calls. Most policy data reaches this library through these objects rather than through direct table access, so a significant share of the behaviour visible to callers is implemented in PL/SQL.

All nine call targets are located and analysed: eight Oracle objects and one SQL Server procedure (`cp_external_client_lookup`, confirmed via a SQL Server BDS query after previously being unresolved when only Oracle was checked).

## Procedure catalog

| Package / Procedure | Schema | Type | Status | Methods used | Calling classes |
| --- | --- | --- | --- | --- | --- |
| [pk72846_view_policy](pk72846_view_policy.md) | `WCIS_DBA` | Package | Found | `getviewdetail`, `getwrapuplegalname`, `getparentpolicy`, `getpolicyaffiliatetype`, `getgaps`, `getagency`, `getpolicyaddress`, `getpolicyaddressbylocseqnum`, `getpolicyperiods`, `getpolicyaffiliatelist`, `team_assign_query` | `clsPolicyData`, `clsAgency`, `clsPolicyAddress`, `clsPolicyPeriodCollection`, `clsAffiliatedPolicyCollection`, `clsTeamAssignmentCollection` |
| [pk73094_policy_data](pk73094_policy_data.md) | `WCIS_DBA` | Package | Found | `getpolicy` | `clsPolicyData` |
| [Pk82033_ThirdParty](pk82033_thirdparty.md) | `WCIS_DBA` | Package | Found | `get_policy_waiver_count` | `clsPolicyData` |
| [coveragelimits_pkg](coveragelimits_pkg.md) | `WCIS_DBA` | Package | Found | `getSpecificLimitsForPolicyNum` | `clsPolicyPeriod` |
| [sp72268_get_cancel_status](sp72268_get_cancel_status.md) | `WCIS_DBA` | Function (standalone) | Found | `sp72268_get_cancel_status` | `clsPolicyData` |
| [sp73089_get_policy_bound_flag](sp73089_get_policy_bound_flag.md) | `WCIS_DBA` | Function (standalone) | Found | `sp73089_get_policy_bound_flag` | `clsPolicyData` |
| [sp72347_info_page_printed_yn](sp72347_info_page_printed_yn.md) | `WCIS_DBA` | Function (standalone) | Found | `sp72347_info_page_printed_yn` | `clsPolicyData` |
| [sp73341_external_client_lookup](sp73341_external_client_lookup.md) | `WCIS_DBA` | Function (standalone) | Found | `sp73341_external_client_lookup` | `clsTeamAssignment` |
| [cp_external_client_lookup](cp_external_client_lookup.md) | `dbo` (SQL Server, database `eisD0P11`) | Stored procedure | Found | `cp_external_client_lookup` | `clsTeamAssignment` |

## SQL statements backed by these procedures

| SQL ID | Statement | Procedure |
| --- | --- | --- |
| [SQL-001](../sql/SQL-001-affiliated-policy-list.md) | Affiliated policy list retrieval | [pk72846_view_policy](pk72846_view_policy.md) |
| [SQL-002](../sql/SQL-002-agency-retrieval.md) | Agency and producer retrieval | [pk72846_view_policy](pk72846_view_policy.md) |
| [SQL-005](../sql/SQL-005-policy-address-by-type.md) | Policy address retrieval by address type | [pk72846_view_policy](pk72846_view_policy.md) |
| [SQL-006](../sql/SQL-006-policy-address-by-location.md) | Policy address retrieval by location sequence number | [pk72846_view_policy](pk72846_view_policy.md) |
| [SQL-008](../sql/SQL-008-policy-periods.md) | Policy period retrieval | [pk72846_view_policy](pk72846_view_policy.md) |
| [SQL-009](../sql/SQL-009-team-assignments.md) | Team assignment retrieval | [pk72846_view_policy](pk72846_view_policy.md) |
| [SQL-013](../sql/SQL-013-policy-affiliate-type.md) | Policy affiliate-type classification (superseded) | [pk72846_view_policy](pk72846_view_policy.md) |
| [SQL-016](../sql/SQL-016-coverage-gaps.md) | Coverage gap retrieval | [pk72846_view_policy](pk72846_view_policy.md) |
| [SQL-019](../sql/SQL-019-parent-policy.md) | Parent policy resolution (superseded) | [pk72846_view_policy](pk72846_view_policy.md) |
| [SQL-021](../sql/SQL-021-wrapup-legal-name.md) | Wrap-up legal name retrieval | [pk72846_view_policy](pk72846_view_policy.md) |
| [SQL-007](../sql/SQL-007-policy-header.md) | Policy header retrieval | [pk73094_policy_data](pk73094_policy_data.md) |
| [SQL-022](../sql/SQL-022-policy-waiver-count.md) | Policy waiver count check | [Pk82033_ThirdParty](pk82033_thirdparty.md) |
| [SQL-023](../sql/SQL-023-employer-liability-limits.md) | Employer-liability limits retrieval | [coveragelimits_pkg](coveragelimits_pkg.md) |
| [SQL-020](../sql/SQL-020-secondary-policy-status.md) | Secondary policy status derivation | [sp72268_get_cancel_status](sp72268_get_cancel_status.md) |
| [SQL-014](../sql/SQL-014-coverage-bound-flag.md) | Coverage-bound flag check | [sp73089_get_policy_bound_flag](sp73089_get_policy_bound_flag.md) |
| [SQL-017](../sql/SQL-017-info-page-printed.md) | Information-page-printed check | [sp72347_info_page_printed_yn](sp72347_info_page_printed_yn.md) |
| [SQL-025](../sql/SQL-025-system-user-email-lookup.md) | System user e-mail lookup | [sp73341_external_client_lookup](sp73341_external_client_lookup.md) |
| [SQL-024](../sql/SQL-024-external-client-lookup-legacy.md) | External client e-mail lookup (legacy path, SQL Server) | [cp_external_client_lookup](cp_external_client_lookup.md) |

## Notes

- Procedure owner names are recorded from the Oracle data dictionary for the eight Oracle objects. They are unrelated to the table schema qualifier, which this library never states in SQL.**
- `cp_external_client_lookup` is a SQL Server stored procedure (schema `dbo`, database `eisD0P11`), confirmed via `legends sqlserver query` — unlike the other eight objects in this catalog, which are Oracle objects.
- `sp72268_get_cancel_status` and `sp72347_info_page_printed_yn` are also invoked from inside `pk73094_policy_data.getpolicy` and `pk72846_view_policy.getpolicyperiods` respectively, so their behaviour affects rows that this library never requests from them directly.
- The dynamic call documented as [SQL-029](../sql/SQL-029-non-typed-associations.md) executes a procedure whose name is read from `ASSOCIATION_TYPE_CODE.SOURCE_PROCEDURE_NAME` at run time. No catalog entry can be created for it because the target varies per row.**

> **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.

## Related documentation

- [Index](../index.md)
- [Overview](../overview.md)
- [Architecture](../architecture.md)
- [Dependencies](../dependencies.md)
- [Operations and processes](../operations-processes.md)
- [Business rules](../business-rules.md)
- [Security and authorization](../security-authorization.md)
- [Database tables](../database-tables.md)
- [SQL catalog](../sql/index.md)
- [API reference](../api/index.md)
- [Configuration](../configuration.md)

## Sources

- `Business/SAIF.Business.View.Policy/clsAffiliatedPolicyCollection.vb`
- `Business/SAIF.Business.View.Policy/clsAgency.vb`
- `Business/SAIF.Business.View.Policy/clsPolicyAddress.vb`
- `Business/SAIF.Business.View.Policy/clsPolicyData.vb`
- `Business/SAIF.Business.View.Policy/clsPolicyPeriod.vb`
- `Business/SAIF.Business.View.Policy/clsPolicyPeriodCollection.vb`
- `Business/SAIF.Business.View.Policy/clsTeamAssignment.vb`
- `Business/SAIF.Business.View.Policy/clsTeamAssignmentCollection.vb`
- Oracle data dictionary source for the eight located objects