---

SELECT
    opaa.id,
    opaa.number,
    opaa."date",
    opaa.appeal_date,
    opaa.registration,
    opaa.accepted,
    opaa.ops_payment_type_code,
    opaa.decision_payment_type_code,
    opaa.bank_detail_id,
    opaa.bank_account_id
FROM ourpension.ops_pension_assignment_application opaa
WHERE opaa.ops_payment_type_code = '01'
ORDER BY
    opaa.registration DESC NULLS LAST,
    opaa.id DESC
LIMIT 50;




SELECT
    t.id AS decision_id,
    t.number AS decision_number,
    t.date AS decision_date,
    t.accepted AS decision_accepted,
    t.decision_type_code,
    t.decision_payment_type_code AS decision_payment_type_code_decision,

    pa.id AS application_id,
    pa.number AS application_number,
    pa."date" AS application_date,
    pa.appeal_date,
    pa.registration AS application_registration,
    pa.accepted AS application_accepted,

    pa.ops_payment_type_code,
    pa.decision_payment_type_code AS decision_payment_type_code_application,

    pa.bank_detail_id,
    pa.bank_account_id

FROM back_office.ops_payment_decision t
JOIN ourpension.ops_pension_assignment_application pa
    ON pa.id = t.ops_pension_assignment_application_id

WHERE
       t.date >= CURRENT_DATE - INTERVAL '30 days'
    OR t.accepted >= CURRENT_DATE - INTERVAL '30 days'

ORDER BY
    t.date DESC NULLS LAST,
    t.accepted DESC NULLS LAST,
    t.id DESC;