---
title: "SQL-033: Quoted policy expiry check"
summary: Calls Oracle stored procedure pk72971_epay_policy.is_expired_quoted_policy.
status: draft
owner: <owner>
last_reviewed: 2026-07-24
library: SAIF.Business.External.Users
reference_type: package
---

# SQL-033: Quoted policy expiry check

Calls the Oracle stored procedure `pk72971_epay_policy.is_expired_quoted_policy` to check whether a quoted policy is expired. The procedure body resides in the Oracle database and was not retrieved in the analysis pass.**

## Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-033 |
| **Operation type** | Read |
| **Execution method** | Stored procedure |
| **Database** | Oracle |
| **Schema** | [unknown]** |
| **Command type** | StoredProcedure |
| **Business object** | `clsUserType` |
| **Criteria property** | Local SQL |
| **Lifecycle method** | `IsQuotedPolicyExpired` |

## Parameters

| Parameter | Direction | Type | Max length | Description |
| --- | --- | --- | --- | --- |
| `:in_policy_num` | Input | Decimal | 10 | Policy number to check. |
| `:return_value` | ReturnValue | String | N/A | Return value from the procedure.** |

## Tables

This statement calls Oracle package `pk72971_epay_policy`. The package body resides in the Oracle database and is not available in the repository source; table-level access within the package cannot be determined from this library.**

## Sample SQL

```sql
-- Stored procedure call
pk72971_epay_policy.is_expired_quoted_policy(:in_policy_num, :return_value)
-- Procedure body resides in Oracle database
```

## Operations and processes
- [User type management](../operations/user-type-management.md)


> **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.External.Users\clsUserType.vb`