---

SELECT ourpension.f_merge_year_tax_deduction(
    CAST(NULLIF(CAST(:p_application_termination_contract_id AS text), '') AS integer),
    CAST(CASE
        WHEN CAST(:p_date AS text) = '9999-99-99' OR CAST(:p_date AS text) = '' THEN NULL
        ELSE CAST(:p_date AS text)
    END AS date),
    CAST(NULLIF(CAST(:p_individual_id AS text), '') AS integer),
    CAST(NULLIF(CAST(:p_max_tax_deduction AS text), '') AS integer),
    12345.67,--CAST(NULLIF(CAST(:p_sum_income AS text), '') AS numeric),
NULLIF(
    CAST(
        NULLIF(CAST(:p_sum_tax_deduction AS text), '')
        AS numeric
    ),
    -1
),
    CAST(:p_type AS text),
    CAST(NULLIF(CAST(:p_year AS text), '') AS integer),
    CAST(:username AS text),
    CAST(NULLIF(CAST(:user_id AS text), '') AS integer),
    CAST(NULLIF(CAST(:p_batch_id AS text), '') AS integer),
    CAST(NULLIF(CAST(:tessa_doc_id AS text), '') AS integer),
     CAST(NULLIF(CAST(:p_version_datetime AS text), '') AS timestamp)
)