SQL-009: Read via pk83407_payment_hist_trans.SelectReimbFinTranByIssueDate

This SQL document describes how Criteria uses the stored procedure pk83407_payment_hist_trans.SelectReimbFinTranByIssueDate to support claim-domain read behavior.

Classification

Field	Value
SQL ID	SQL-009
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.SelectReimbFinTranByIssueDate(/* see source for parameters */); END;
-- Oracle source not found; calling code is possibly dead code.

Operations and processes

• Financial transaction retrieval

Business rules

• BR-001: Financial transaction retrieval mode selection

Sources

• Business\SAIF.Business.View.Claim\clsFinancialTransactionCollection.vb