416: AND EXISTS (SELECT ID
417: FROM OKL_K_HEADERS KHR
418: WHERE KHR.ID = RUL.DNZ_CHR_ID);
419:
420: --Update OKL_SUBSIDIES_ALL_B for reference of Vendor
421: UPDATE OKL_SUBSIDIES_ALL_B
422: SET VENDOR_ID = p_vendor_id,
423: LAST_UPDATED_BY = l_last_updated_by,
424: LAST_UPDATE_DATE = l_last_update_date,
417: FROM OKL_K_HEADERS KHR
418: WHERE KHR.ID = RUL.DNZ_CHR_ID);
419:
420: --Update OKL_SUBSIDIES_ALL_B for reference of Vendor
421: UPDATE OKL_SUBSIDIES_ALL_B
422: SET VENDOR_ID = p_vendor_id,
423: LAST_UPDATED_BY = l_last_updated_by,
424: LAST_UPDATE_DATE = l_last_update_date,
425: LAST_UPDATE_LOGIN = l_last_update_login