353: LAST_UPDATE_LOGIN = l_last_update_login
354: WHERE IPVS_ID = p_dup_vendor_site_id;
355:
356: --Insurance Objects
357: --Update OKL_INS_POLICIES_ALL_B for references of Vendor
358: UPDATE OKL_INS_POLICIES_ALL_B
359: SET ISU_ID = p_vendor_id,
360: LAST_UPDATED_BY = l_last_updated_by,
361: LAST_UPDATE_DATE = l_last_update_date,
354: WHERE IPVS_ID = p_dup_vendor_site_id;
355:
356: --Insurance Objects
357: --Update OKL_INS_POLICIES_ALL_B for references of Vendor
358: UPDATE OKL_INS_POLICIES_ALL_B
359: SET ISU_ID = p_vendor_id,
360: LAST_UPDATED_BY = l_last_updated_by,
361: LAST_UPDATE_DATE = l_last_update_date,
362: LAST_UPDATE_LOGIN = l_last_update_login