---

SELECT
    opaa.id AS application_id,
    opaa.number AS application_number,
    opaa.appeal_date,
    opaa.registration,
    opaa.accepted AS application_accepted,

    opaa.ops_payment_type_code,
    opaa.decision_payment_type_code AS application_decision_payment_type,

    opd.id AS decision_id,
    opd.number AS decision_number,
    opd.date AS decision_date,
    opd.accepted AS decision_accepted,
    opd.rejected AS decision_rejected,
    opd.canceled AS decision_canceled,
    opd.completed AS decision_completed,
    opd.decision_type_code,
    opd.decision_payment_type_code,

    opaa.bank_detail_id,
    opaa.bank_account_id,

    aibd.id AS bank_detail_found,
    aibd.personal_account,
    aibd.bic,
    aibd.accepted AS bank_detail_accepted

FROM ourpension.ops_pension_assignment_application opaa

JOIN back_office.ops_payment_decision opd
    ON opd.ops_pension_assignment_application_id = opaa.id

LEFT JOIN ourpension.application_individual_bank_detail aibd
    ON aibd.id = opaa.bank_detail_id

WHERE opd.decision_payment_type_code = '01'
  AND (
       opd.date >= CURRENT_DATE - INTERVAL '30 days'
       OR opd.accepted >= CURRENT_DATE - INTERVAL '30 days'
  )

ORDER BY
    opd.date DESC NULLS LAST,
    opd.id DESC;