BEGIN
FOR
SELECT VATIndex_ID, DocQueue_ID, OrdNumber, Period_ID, TAmountWithoutVAT,
LocalTAmountWithoutVAT, TAmount, LocalTAmount, Text, Description, Division_ID, BusOrder_ID,
BusTransaction_ID, BusProject_ID, Firm_ID, ESLDate$Date, PosIndex, RelatedDocName, ESLIndicator_ID,
Document_ID, VIESKind
FROM
VATSummaryInvESL(:FirmSelID, :DivisionsSelID, :BusOrdersSelID, :BusTransactionsSelID, :BusProjectsSelID,
:AESLDateFrom , :AESLDateTo, :DivisionsWithChilds,
:BusOrdersWithChilds, :BusTransactionsWithChilds, :BusProjectsWithChilds, :VATCountry_ID)
INTO
:VATIndex_ID, :DocQueue_ID, :OrdNumber, :Period_ID, :TAmountWithoutVAT,
:LocalTAmountWithoutVAT, :TAmount, :LocalTAmount, :Text, :Description, :Division_ID, :BusOrder_ID,
:BusTransaction_ID, :BusProject_ID, :Firm_ID, :ESLDate$Date, :PosIndex, :RelatedDocName, :ESLIndicator_ID,
:Document_ID, :VIESKind
DO begin
SUSPEND;
end
RelatedDocName = '';
FOR
SELECT VATIndex_ID, DocQueue_ID, OrdNumber, Period_ID, TAmountWithoutVAT,
LocalTAmountWithoutVAT, TAmount, LocalTAmount, Text, Description, Division_ID, BusOrder_ID,
BusTransaction_ID, BusProject_ID, Firm_ID, ESLDate$Date, PosIndex, ESLIndicator_ID,
Document_ID, VIESKind
FROM
VATSummaryCashESL(:FirmSelID, :DivisionsSelID, :BusOrdersSelID, :BusTransactionsSelID, :BusProjectsSelID,
:AESLDateFrom , :AESLDateTo, :DivisionsWithChilds,
:BusOrdersWithChilds, :BusTransactionsWithChilds, :BusProjectsWithChilds, :VATCountry_ID)
INTO
:VATIndex_ID, :DocQueue_ID, :OrdNumber, :Period_ID, :TAmountWithoutVAT,
:LocalTAmountWithoutVAT, :TAmount, :LocalTAmount, :Text, :Description, :Division_ID, :BusOrder_ID,
:BusTransaction_ID, :BusProject_ID, :Firm_ID, :ESLDate$Date, :PosIndex, :ESLIndicator_ID,
:Document_ID, :VIESKind
DO begin
SUSPEND;
end
RelatedDocName = '';
FOR
SELECT VATIndex_ID, DocQueue_ID, OrdNumber, Period_ID, TAmountWithoutVAT,
LocalTAmountWithoutVAT, TAmount, LocalTAmount, Text, Description, Division_ID, BusOrder_ID,
BusTransaction_ID, BusProject_ID, Firm_ID, ESLDate$Date, PosIndex, ESLIndicator_ID,
Document_ID, VIESKind
FROM
VATSummaryCOSESL(:FirmSelID, :DivisionsSelID, :BusOrdersSelID, :BusTransactionsSelID, :BusProjectsSelID,
:AESLDateFrom , :AESLDateTo, :DivisionsWithChilds,
:BusOrdersWithChilds, :BusTransactionsWithChilds, :BusProjectsWithChilds, :VATCountry_ID)
INTO
:VATIndex_ID, :DocQueue_ID, :OrdNumber, :Period_ID, :TAmountWithoutVAT,
:LocalTAmountWithoutVAT, :TAmount, :LocalTAmount, :Text, :Description, :Division_ID, :BusOrder_ID,
:BusTransaction_ID, :BusProject_ID, :Firm_ID, :ESLDate$Date, :PosIndex, :ESLIndicator_ID,
:Document_ID, :VIESKind
DO begin
SUSPEND;
end
END;