---

SELECT
    id,
    code,
    name,
    short_name,
    group_code,
    service_type,
    type_movement,
    auto_approver,
    display_in_lkk,
    name_for_statement,
    display_in_statement,
    settings_transaction_extended_id
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',
    'CHANGE_CLASSIFICATION_PENSION_ACCOUNTS_INV_TO_STR',
    'CHANGE_CLASSIFICATION_PENSION_ACCOUNTS_STR_TO_INV',
    'ANNUAL_PAYMENT_ASV',
    'TRANSFER_FROM_RESERVE_TO_OUTSTANDING_DEBTS',
    'REFUSAL_BANK',
    'DEPOSIT_FUNDS_UNIDENTIFIED_PAYMENTS'
)
ORDER BY id;