---

select
    n.nspname as schema_name,
    p.proname as object_name,
    'function' as object_type
from pg_proc p
join pg_namespace n
    on n.oid = p.pronamespace
where n.nspname in ('ourpension', 'back_office')
  and (
       p.prosrc ilike '%npo_agreement_id%'
       or p.prosrc ilike '%npo_pension_agreement%'
  )

union all

select
    schemaname,
    viewname,
    'view'
from pg_views
where schemaname in ('ourpension', 'back_office')
  and (
       definition ilike '%npo_agreement_id%'
       or definition ilike '%npo_pension_agreement%'
  )

order by object_type, schema_name, object_name;