Operation Details |
Description: | To retrieve the max. effective date from the instruction line item table. |
Sterotype: | ns |
SQL |
SELECT MAX(effectiveDate) INTO :effectiveDate FROM InstructionLineItem WHERE InstructionLineItem.caseID = :caseID |
Operation Details |
Description: | To retrieve the max. effective date from the instruction line item table. |
Sterotype: | ns |
SQL |
SELECT MAX(effectiveDate) INTO :effectiveDate FROM InstructionLineItem WHERE InstructionLineItem.caseID = :caseID |