APPS.OKL_VENDORMERGE_GRP dependencies on OKL_TXL_ASSETS_B

Line 428: --Update OKL_TXL_ASSETS_B for references of Vendor in SUPPLIER_ID

424: LAST_UPDATE_DATE = l_last_update_date,
425: LAST_UPDATE_LOGIN = l_last_update_login
426: WHERE VENDOR_ID = p_dup_vendor_id;
427:
428: --Update OKL_TXL_ASSETS_B for references of Vendor in SUPPLIER_ID
429: UPDATE OKL_TXL_ASSETS_B
430: SET SUPPLIER_ID = p_vendor_id,
431: LAST_UPDATED_BY = l_last_updated_by,
432: LAST_UPDATE_DATE = l_last_update_date,

Line 429: UPDATE OKL_TXL_ASSETS_B

425: LAST_UPDATE_LOGIN = l_last_update_login
426: WHERE VENDOR_ID = p_dup_vendor_id;
427:
428: --Update OKL_TXL_ASSETS_B for references of Vendor in SUPPLIER_ID
429: UPDATE OKL_TXL_ASSETS_B
430: SET SUPPLIER_ID = p_vendor_id,
431: LAST_UPDATED_BY = l_last_updated_by,
432: LAST_UPDATE_DATE = l_last_update_date,
433: LAST_UPDATE_LOGIN = l_last_update_login

Line 436: --Update OKL_TXL_ASSETS_B for references of Vendor in RESIDUAL_SHR_PARTY_ID

432: LAST_UPDATE_DATE = l_last_update_date,
433: LAST_UPDATE_LOGIN = l_last_update_login
434: WHERE SUPPLIER_ID = p_dup_vendor_id;
435:
436: --Update OKL_TXL_ASSETS_B for references of Vendor in RESIDUAL_SHR_PARTY_ID
437: UPDATE OKL_TXL_ASSETS_B
438: SET RESIDUAL_SHR_PARTY_ID = p_vendor_id,
439: LAST_UPDATED_BY = l_last_updated_by,
440: LAST_UPDATE_DATE = l_last_update_date,

Line 437: UPDATE OKL_TXL_ASSETS_B

433: LAST_UPDATE_LOGIN = l_last_update_login
434: WHERE SUPPLIER_ID = p_dup_vendor_id;
435:
436: --Update OKL_TXL_ASSETS_B for references of Vendor in RESIDUAL_SHR_PARTY_ID
437: UPDATE OKL_TXL_ASSETS_B
438: SET RESIDUAL_SHR_PARTY_ID = p_vendor_id,
439: LAST_UPDATED_BY = l_last_updated_by,
440: LAST_UPDATE_DATE = l_last_update_date,
441: LAST_UPDATE_LOGIN = l_last_update_login