Database SQL Operation: FinancialCalendar.searchByDeliveryMethodExclusionDateRange
Description: | To retrieve FinancialCalendar records for a particular delivery method where the exclusionDate falls within a particular time period. |
Sterotype: | nsmulti |
SELECT
financialCalendarID,
exclusionDate,
deliveryMethodType,
prePaymentInd
INTO
:financialCalendarID,
:exclusionDate,
:deliveryMethodType,
:prePaymentInd
FROM
FinancialCalendar
WHERE deliveryMethodType = :deliveryMethodType
AND exclusionDate >= :dateFrom
AND exclusionDate <= :dateTo
ORDER BY exclusionDate
|