DECLARE
v_npi varchar2(40) := V('P11_LAB_NPI');
v_policy_number varchar2(40) := V('P11_POLICY_ENCRYPT');
--It looks like bind variables don't play nice with data types, so I'm manually adjusting

BEGIN

UPDATE hv_user.CMD_INS_FORM i

SET (i.LAB_NPI, i.LAB_ADDRESS, i.LAB_ADDRESS_2, i.CITY, i.LAB_NAME, i.PHONE_NUMBER,
     i.STATE, i.LAB_TAX_ID, i.CLIA, i.ZIP_CODE, i.AUTO_FLAG, i.EMPLOYMENT_RELATED, i.STATE_OF_AUTO_ACCIDENT)
=
(
SELECT DISTINCT
b3.BOX_33_LAB_NPI,
b3.BOX_33_LAB_ADDRESS,
b3.BOX_33_LAB_ADDRESS_2,
b3.BOX_33_CITY,
b3.BOX_33_LAB_NAME,
b3.BOX_33_PHONE_NUMBER,
b3.BOX_33_STATE,
b3.BOX_33_LAB_TAX_ID,
b3.BOX_33_CLIA,
b3.BOX_33_ZIP_CODE,
:P11_AUTO_FLAG,
:P11_EMPLOYMENT_RELATED,
:P11_STATE_OF_AUTO_ACCIDENT

FROM hv_user.CMD_BOX33_REFERENCE b3
WHERE b3.BOX_33_LAB_NPI = v_npi
)

WHERE i.POLICY_NUMBER = v_policy_number;
END;