---

SELECT
    MAX(id) AS max_id
FROM back_office.operation_type;

SELECT
    id,
    code
FROM back_office.operation_type
WHERE code IN (
    'NPO_RETURN_PENSION_PAYMENT',
    'NPO_RETURN_RPPO_REDEMPTION_SUM',
    'NPO_RETURN_RPPO_SUCCESSOR_PAYMENT',
    'NPO_TARGET_CONTRIBUTIONS_SR',
    'NPO_TARGET_CONTRIBUTIONS_SS',
    'SECOND_PAYMENT_PENSION',
    'SECOND_PAYMENT_SUCCESSOR',
    'SECOND_PAYMENT_TERMINATED',
    'NPO_INSURED_FUND_REPLENISHMENT_SR',
    'NPO_RETURN_RPPO_NDFL',
    'ANNUAL_PAYMENT_ASV',
    'CHANGE_CLASSIFICATION_PENSION_ACCOUNTS_INV_TO_STR',
    'CHANGE_CLASSIFICATION_PENSION_ACCOUNTS_STR_TO_INV',
    'TRANSFER_FROM_RESERVE_TO_OUTSTANDING_DEBTS',
    'REFUSAL_BANK'
)
ORDER BY id;