Operation Details
Description: Retrieves the list of intsruction line items associated with provider based on financial instruction id and ILI type.
Sterotype: nsmulti
SQL 
SELECT FINANCIALINSTRUCTION.FININSTRUCTIONID,
INSTRUCTIONLINEITEM.CASEID, 
INSTRUCTIONLINEITEM.INSTRUCTIONLINEITEMTYPE,
OVERUNDERPAYMENTBREAKDOWN.RELATEDREFERENCE,
INSTRUCTIONLINEITEM.INSTRUCTLINEITEMCATEGORY,
FINANCIALINSTRUCTION.CONCERNROLEID,
INSTRUCTIONLINEITEM.COVERPERIODFROM,
INSTRUCTIONLINEITEM.COVERPERIODTO,
INSTRUCTIONLINEITEM.INSTRUCTLINEITEMID
INTO 
:fininstructionID, :caseID, :iliType, :relatedReference, :iliCategory, :concernRoleID, :coverperiodFrom, :coverperiodTo, :instructionLineItemID
FROM 
FINANCIALINSTRUCTION,
INSTRUCTIONLINEITEM,
FINANCIALCOMPONENT,
PAYMENTCORRECTIONFCLINK,
PAYMENTCORRECTIONEVIDENCE,
OVERUNDERPAYMENTBREAKDOWN
WHERE FINANCIALINSTRUCTION.FININSTRUCTIONID = INSTRUCTIONLINEITEM.FININSTRUCTIONID
AND FINANCIALCOMPONENT.FINANCIALCOMPID  = INSTRUCTIONLINEITEM.FINANCIALCOMPID
AND PAYMENTCORRECTIONFCLINK.FINANCIALCOMPONENTID = FINANCIALCOMPONENT.FINANCIALCOMPID
AND PAYMENTCORRECTIONFCLINK.PAYMENTCORRECTIONEVIDENCEID = PAYMENTCORRECTIONEVIDENCE.PAYMENTCORRECTIONEVIDENCEID
AND PAYMENTCORRECTIONEVIDENCE.OVERUNDERPAYMENTBREAKDOWNID = OVERUNDERPAYMENTBREAKDOWN.OVERUNDERPAYMENTBREAKDOWNID
AND INSTRUCTIONLINEITEM.INSTRUCTIONLINEITEMTYPE = :iliType
AND FINANCIALINSTRUCTION.FININSTRUCTIONID = :financialInstructionID