---
title: "SQL-066: clsPaymentReturnReasonCode retrieve (culture-aware)"
summary: Retrieves a single payment return reason code with culture-aware description from PAYMENT_RETURN_REASON_CODE.
status: draft
owner: SAIF
last_reviewed: 2026-07-24
library: SAIF.Business.Payment.EFT
reference_type: package
---

# SQL-066: clsPaymentReturnReasonCode retrieve (culture-aware)

Retrieves a single payment return reason code with culture-aware description from PAYMENT_RETURN_REASON_CODE.

## Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-066 |
| **Operation type** | Read |
| **Execution method** | Inline SQL |
| **Database** | Oracle* |
| **Schema** | [unqualified]** |
| **Command type** | Text |
| **Business object** | `clsPaymentReturnReasonCode` |
| **Criteria property** | `RetrieveSQL` |
| **Lifecycle method** | `BeforeRetrieve / AfterRetrieve` |


## Parameters

| Parameter | Direction | Type | Max length | Description |
| --- | --- | --- | --- | --- |
| \:Code\ | Input | String | 5 | Binds \MyCriteria.Code\* |
| \:CultureCode\ | Input | String | 5 | Binds \MyCriteria.CultureCode\ and current thread culture* |

## Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [PAYMENT_RETURN_REASON_CODE](../database-tables.md#payment_return_reason_code) | — | — |
| [PAYMENT_RETURN_REASON_GCODE](../database-tables.md#payment_return_reason_gcode) | — | — |

## Sample SQL

```sql
Select p.BANK_TRANSMITTAL_FLAG as BankTransmittalFlag,
  p.CATEGORY as Category,
  p.CODE as Code,
  case when P2.code_descr is null
    then cast(P.CODE_DESCR as nvarchar2(2000))
    else P2.code_descr end AS Description,
  p.RETURN_PAYMENT_EVENT_CODE as ReturnPaymentEventCode
From PAYMENT_RETURN_REASON_CODE p
  left outer join PAYMENT_RETURN_REASON_GCODE p2
    on (P2.code = P.code
    and upper(P2.CULTURE_CODE) = upper(:CultureCode))
Where p.CODE = :Code
```

## Operations and processes
- [Payment return handling](../operations/payment-return-handling.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.

## Business rules
- [BR-EFT-03: Payment return classified by NACHA reason code](../business-rules.md#br-eft-03-returned-eft-payment-classified-by-nacha-return-reason-code)
- [BR-EFT-07: Return reason descriptions are culture-aware](../business-rules.md#br-eft-07-return-reason-description-is-culture-aware)

## Sources
- `Business\SAIF.Business.Payment.EFT\clsPaymentReturnReasonCode.vb`