SQL-007: Read via pk83407_payment_hist_trans.SelectFinTranByClaimId¶
This SQL document describes how Criteria uses the stored procedure pk83407_payment_hist_trans.SelectFinTranByClaimId to support claim-domain read behavior.
Classification¶
| Field | Value |
|---|---|
| SQL ID | SQL-007 |
| Operation type | Read |
| Execution method | StoredProc |
| Database | Oracle |
| Schema | N/A |
| Command type | StoredProcedure |
| Business object | Criteria |
| Criteria property | retrievesql |
| Lifecycle method | Criteria read |
Parameters¶
This SQL statement exposes no explicit input parameters in the analyzed source.
Tables¶
| Table | Access | Columns used |
|---|---|---|
| Stored procedure-owned tables not available | Stored procedure | Oracle source was not available during Stage 1b retry. |
Sample SQL¶
BEGIN pk83407_payment_hist_trans.SelectFinTranByClaimId(/* see source for parameters */); END;
-- Oracle source not found; calling code is possibly dead code.
Operations and processes¶
Business rules¶
Sources¶
Business\SAIF.Business.View.Claim\clsFinancialTransactionCollection.vb