LINE 15: where par."DR_SEQ" = _dr_seq and par."AN_SEQ" = _an_seq
                                          ^
QUERY:  with products AS (select p.id, p.st_seq
                                  from keyvet.keyvet_drugallocationproduct p ),
farms AS (select dr_seq, an_seq, farm_name, supply_number
                  from clients.clients_farm where dr_seq = _dr_seq)

select products.id, par."PAR_SEQ", par."PAR_QTY"::integer, par."ST_SEQ",
par."ANSEQ",
CASE WHEN farm_name is null THEN 'Unassigned'
ELSE concat(farm_name,' ', supply_number)::character varying END AS farm,
par."PAR_START_DATE" AT TIME ZONE 'Pacific/Auckland' as par_start_date,
par."PAR_END_DATE" AT TIME ZONE 'Pacific/Auckland' as par_end_date
from vision_vs."F_Vet_Par" par
join products ON products.st_seq = par."ST_SEQ"
left join farms f ON f.an_seq = par."ANSEQ"
where par."DR_SEQ" = _dr_seq and par."AN_SEQ" = _an_seq
and "PAR_START_DATE" AT TIME ZONE 'Pacific/Auckland' >= finance.get_dairy_season_start_date_from_year(new_season_start_year)
CONTEXT:  PL/pgSQL function keyvet.all_animal_pre_allocations(integer,integer,integer) line 5 at RETURN QUERY