SQL:AssignedIncome.searchByLinkedIncomeIDAndLinkedIncomeType

Home
Application Views and Tabs
Database Tables
Pages
Domain Definitions
Code Tables
Message Files
Application Properties
Workflows
Rule Sets
Dynamic Evidence
IEG Scripts
Datastore Schemas
Page Flows

Database SQL Operation: AssignedIncome.searchByLinkedIncomeIDAndLinkedIncomeType

Operation Details

Description:	search AssignedIncome by the linkedIncomeID and the linkedIncomeType
Sterotype:	nsmulti

SQL

SELECT
  AssignedIncome.evidenceID,
  AssignedIncome.assignedAmount
INTO
  :evidenceID,
  :assignedAmount 
FROM
  AssignedIncome 
WHERE AssignedIncome.linkedIncomeID = :linkedIncomeID 
  AND AssignedIncome.linkedIncomeType = :linkedIncomeType