SQL-030: cls801Submission¶

This statement supports cls801Submission by executing a Other operation through inline.

Classification¶

Field	Value
SQL ID	SQL-030
Operation type	Other
Execution method	Inline SQL
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	`cls801Submission`
Criteria property	`RetrieveSQL`
Lifecycle method	`BeforeRetrieve`

Parameters¶

Parameter	Direction	Type	Max length	Description
`:SubSeqNum`	Input	Unknown	—	Passed from cls801Submission via BeforeRetrieve.
`:ClaimID`	Input	Unknown	—	Passed from cls801Submission via BeforeRetrieve.

Tables¶

Table	Access	Columns used
DUAL	Other	Not enumerated directly in the stage findings.**

Sample SQL¶

-- When retrieving by submission ID
EXEC PK82538_ONLINE_801_CLAIM.submission_select(SubSeqNum => :SubSeqNum, recordset => :recordset);

-- When retrieving by claim
EXEC PK82538_ONLINE_801_CLAIM.submission_claim_select(ClaimID => :ClaimID, recordset => :recordset);

Operations and processes¶

cls801Submission BeforeRetrieve

Note: Statements marked with ** could not be confirmed; treat them as unknown until verified.

Sources¶

Business/SAIF.Business.Claim.Entry/Online801/Submission/cls801Submission.vb