The below query gives the list of CPs with custom JSON configured.
select
cp.short_title
from
catissue_collection_protocol cp
JOIN
os_cp_workflows wf
ON
cp.identifier = wf.cp_id
where
wf.workflows is not null and
cp.activity_status = 'Active' and
wf.workflows <> '';