152: where VENDOR_ID = p_dup_vendor_id
153: and nvl(VENDOR_SITE_ID, 0) = decode(VENDOR_SITE_ID, NULL, 0, p_dup_vendor_site_id);
154:
155: -- **********************************************************
156: -- Updating FA_INS_VALUES : VENDOR_ID
157: -- **********************************************************
158: l_location := 'FA_INS_VALUES';
159: update FA_INS_VALUES
160: set VENDOR_ID = p_vendor_id
154:
155: -- **********************************************************
156: -- Updating FA_INS_VALUES : VENDOR_ID
157: -- **********************************************************
158: l_location := 'FA_INS_VALUES';
159: update FA_INS_VALUES
160: set VENDOR_ID = p_vendor_id
161: where VENDOR_ID = p_dup_vendor_id;
162:
155: -- **********************************************************
156: -- Updating FA_INS_VALUES : VENDOR_ID
157: -- **********************************************************
158: l_location := 'FA_INS_VALUES';
159: update FA_INS_VALUES
160: set VENDOR_ID = p_vendor_id
161: where VENDOR_ID = p_dup_vendor_id;
162:
163: -- **********************************************************