SQL-029: Read via sp83411_Calc_Total_Paid
This SQL document describes how Criteria uses the stored procedure sp83411_Calc_Total_Paid to support claim-domain read behavior.
Classification
| Field |
Value |
| SQL ID |
SQL-029 |
| Operation type |
Read |
| Execution method |
StoredProc |
| Database |
Oracle |
| Schema |
N/A |
| Command type |
StoredProcedure |
| Business object |
Criteria |
| Criteria property |
totalpaidamountsql |
| Lifecycle method |
Criteria read |
Parameters
| Parameter |
Direction |
Type |
Max length |
Description |
(see source call) |
Input/Output |
N/A |
N/A |
The source call provides parameters, but not all names were visible in the analysis excerpt. |
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 sp83411_Calc_Total_Paid(:inClaimId, :inPaymentCategory, :returnValue); END;
-- Oracle source not found; calling code is possibly dead code.
Operations and processes
Sources
Business\SAIF.Business.View.Claim\clsClaimData.vb