SQL-057: clsClaimSupportOrder
This statement supports clsClaimSupportOrder by executing a Read operation through storedproc.
Classification
Field
Value
SQL ID
SQL-057
Operation type
Read
Execution method
Stored procedure
Database
Oracle
Schema
[unqualified]**
Command type
StoredProcedure
Business object
clsClaimSupportOrder
Criteria property
PaymentAboutToBeIssued
Lifecycle method
PaymentAboutToBeIssued
Parameters
Parameter
Direction
Type
Max length
Description
:inWorkerID
Input
Unknown
—
Passed from clsClaimSupportOrder via PaymentAboutToBeIssued.
:CNT
Input
Unknown
—
Passed from clsClaimSupportOrder via PaymentAboutToBeIssued.
Tables
Table
Access
Columns used
CL_INJURY_CLAIM
Read
Not enumerated directly in the stage findings.**
DUAL
Read
Not enumerated directly in the stage findings.**
Sample SQL
PK82141_SUPPORT_ORDER . PaymentAboutToBeIssued (: inWorkerID , : CNT )
Operations and processes
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.Claim.Maintenance/clsClaimSupportOrder.vb