Same code in multiple stored procedures
This should work for you:

CREATE VIEW MyView AS
SELECT &lt;colList&gt;
FROM &lt;TableOne&gt;
INNER JOIN &lt;TableTwo&gt; ON ...
AND .....
AND .....
LEFT JOIN &lt;TableThree&gt; ON ...
AND .....
AND .....
WHERE .....
AND .....
AND .....


Then replace in Procs with:

...
FROM MyView
WHERE
MedicalPlanCode IN ('abc', 'def', 'ghi')