SQL-003: Read via sp83411_Calc_Total_Paid¶
This SQL document describes how clsClaimData uses the stored procedure sp83411_Calc_Total_Paid to support claim-domain read behavior.
Classification¶
| Field | Value |
|---|---|
| SQL ID | SQL-003 |
| Operation type | Read |
| Execution method | StoredProc |
| Database | Oracle |
| Schema | N/A |
| Command type | StoredProcedure |
| Business object | clsClaimData |
| Criteria property | GetTotalPaidAmount |
| Lifecycle method | Cls Claim Data 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 sp83411_Calc_Total_Paid(/* see source for parameters */); END;
-- Oracle source not found; calling code is possibly dead code.
Operations and processes¶
Sources¶
Business\SAIF.Business.View.Claim\clsClaimData.vb